Answer Questions
Poolius Grids are from Venus, cursors are from Mars (Help!)
Hey guys, long time,<br><br>I've been recently working on grids with cursors, and doing cursor transfer stuff. After some point in time during a function, one of the product IDs changes itself. I have figured out how it happens, but not why it happens. Below I will post the original code: set exact on SCAN WITH thisform.pftransact.pInvoices.grdInvoice .column1.text1.value = crsItems.barCode .column2.text1.value = crsItems.prodName .column3.text1.value = crsItems.quantity endwith SELECT crsTransaction UPDATE crsTransaction SET crsTransaction. ...Show All
Robert D Misiak Visual Foxpro report writer
I have a dbf with following fields bill no, bill date, cust name,item name,qty,rate,amount and i have 553 records. i want a simple report on 132 column stationary. i dont want totals also. (so no page footer or summary). i used visual foxpro report writer. but the report does not print with proper ejection i.e. second page starts printing from bottom of first page and third page prints from bottom of second page and so on. printer is absolutely fine because documents from excel and word print with proper page breaks. can anybody help I think u are completely mistaken about me. i am a small time foxpro for windows 2.6 programmer from bangalore, india. i am just trying to upgrade myself to visual foxpro. i have g ...Show All
Jason Zhang OLe error code 0x80040154 : class not registered
i have download a protect applications using dll files. but when i run it into my project above error pop-out. wat i missing if run from prg it works. Thanks in advance. This error indicates that a something (either a DLL or an OCX) has not been entered into the Windows Registry and so it cannot be located there. Presumably this is one (or more) of your downl;oaded DLL files. You need to find which one is causing the error and register it using the Windows REGSVR32 program. YOu can find details of that on the MSDN at http://support.microsoft.com/default.aspx/kb/249873/ ...Show All
slugonamission vfp command to eject a cash drawer
hello, i would like all you experts to help me out in figuring out how eject a cash drawer after finalizing the transaction. I need it to be done in vfp. my second question is, what is the command to write the code to print the transactioin in the receipt printer. thank you in advance Jason hi.. although i am not an expert but just have a little knowledge regarding your problem. just check your cash drawer if it connected directly to a printer there's a little jack at the back near the printer port cable or somewhere depending on the model, if it has then it is included in the printer driver already. Once you click the rpint button of your form it'll automatically kick-out the drawer.(Printer that hasno problem regarding the ...Show All
HSBF Lewe Using INI files to store settings in Visual foxpro applications
Does any one know a good example, tutorial, or walk through on how to save settings in your application to an ini file The best I found is "INI Class" at the UT: http://www.universalthread.com/wconnect/wc.dll 2,54,33,9309 You also have "Read / Write INI files": http://www.universalthread.com/wconnect/wc.dll 2,54,33,9766 ...Show All
Morten Dahl SCREEN RESOLUTION
HELLO EVERYBODY, CAN WE SET RESOLUTION PROGRAMATICALLY IF YES, PLEASE TELL ME HOW set display to vga25 HELLO EVERYBODY, CAN WE SET RESOLUTION PROGRAMATICALLY IS IT POSSIBLE IN VFP PLZ. ANSWER JUST YES OR NO. Hm my design resolution is 800x600 but when i install my program to my customer . his screen resolution is 1024x768 . Its makes my program screen so .... How do i fit my program to my customer screen Thanks in advance. Check http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=623910&SiteID=1 Yes. But don't do it. This is one of the few areas where software CAN break hardware. If you set a ...Show All
brokenrice arabic
hi i want write arabic in the textbox (right to left) what must ido Alex i do it but it dont work good ican not see cursor in the text box and when i use arrow key to back an edit text it dont work but it write right to left it is good but there is more problem . you say vfp team are workin on it when they correct it. i am useing vfp9 and windows Xp i would like to write in russian but when ever i try to put something in a text box i see " " Hi, Please check this article http://www.microsoft.com/middleeast/msdn/VisualFoxPro.aspx sorry bijansaba did not mean to hijack your thread. ...Show All
Jelena vfp 6 forms
Here is my situation. I am filtering in a combo box in reference to some info entered in a previous textbox. My problem that I am having is when you navigate records using the wizstyle textbuttons the info displayed disappears. I have tried set filter to in this.comboname.valid and lost focus events, but it still does not display info. I noticed that it seems to still go by the last combo box got focus event. I even tried rebuilding the combo in each textbutton and calling a requery event of the box from each textbutton! Any suggestions I figured another way in (believe it or not!) VFP 6. In each navigational textbuttons, I called a requery of each filtered combobox after doing the default procedures. ...Show All
igor_22 Using SQL to create a multi-periods sum result.
Hi; I need to create a cursor with multiple columns listing sums of sales. For example: Product# 2006 Sales 2005 Sales 2004 sales 2003 sales 2002 sales Lets assume the table structure is simply ProductId, SoldDate and SoldAmount. This table obviously lists individual sales. Before I start xbasing my way into this, can I do this using a SQL select command Thanks. The VFP Cross-Tab wizard will do this for you from a cursor that contains one record per year. Full details are in the help file, so take a look and come back if you need more specific help Sir, Sir, how to do this multi-periods sum using just foxpro for windows 2.6 or foxpro on dos 2.6.our company is ...Show All
olive2 Caps lock ON when application activate.
Can I trap the 'activate' of my app I want to turn on caps lock every time the user selects the VFP application. I don't want to do this at the start of the app because the user may minimize the app and then get back to it. Thx. Hi Aleniko, I agree partially with Don's reply to that ( if you really need to store them uppercased then set format to "!" in your base textbox class and that'd be all - however storing everything uppercased is ugly). "I may be wrong, but I think searching on upper is a big mistake. I think performance would suffer doing so. Are you implying that in order to take advantage of rushmore I should index everything on upper() Even so, I think doing search ...Show All
Andy McDonald Parameters in a VFP method
Hi All, I want to use PARAMETERS in a VFP method. How can I achieve this. Example: In a method called MyMethod FUNCTION getperiod(ldDateIn, lnPeriodIdIn) SELECT myTable SELECT periodid FROM myTable WHERE DateIn = ldDateIn AND PeriodIdIn = lnPeriodIdIn INTO CURSOR myCursor RETURN PeriodID (Which in this case is a numeric value) Thanks for any help or insight. Regards, Dave I'm not really sure what you're asking. The method you show has two parameters, ldDateIn and lnPeriodIDIn and you're using them. To return the value selected, you should add the alias: RETURN myCursor.PeriodID Tamar I might understand: The getperiod- Method you create must have 'LParameters' as the 1st line: LParamete ...Show All
Kevin Stephens VFP 9.0 ReportListener Rendeing....
Hi All, Is there any other way to preview with out using a APP for the _reportpreivew system variable my reqiurement is like i should not have a seperate source for this APP line the ReportPreview. i have to have the source in my basic project and use reportlistener for previewing the reports. Kindly do the needful. Thanks in advance Venkatram Venkatram wrote: Sorry this didnt help me really. Drat. Anyone else have any good ideas Sorry this didnt help me really. Thanks Venkat Venkatram wrote: do (_reportpreview) with oPrevCont oRepListner = createobject("ReportListener") oRepListner.listenertype = 1 oRepListner.previewcontainer = oPr ...Show All
Loki70 visual foxpro 6.0 software
where can i find visual foxpro 6.0 software download for free Thanks for your help. but this site sells only to students of US. U Require a Student Autohrization. I tried both the links to buy VFP 9.0 Academic Version. but the form does not allow any body to buy outside US i think. i am from india and city bangalore. how can i buy the software. the form asks for state and country. and india is not at all their in combo box. can u just help me by telling me how to buy this academic version in india i.e. bangalore city. thanks and regards (Lakshminarayana R) Lakshminarayana, There is an academic version available. Here are the first couple of sites that came up in a Google search http://www ...Show All
Beast Forever building AJAX web apps in VFP
Hi, I was wondering if there were any tutorials, books, websites or any other form of literature/info out there about the creation of AJAX web applications in VFP. I’m particularly interested in source code examples etc. I’ve searched almost everywhere but couldn’t find anything. Also are there any useful VFP books for a beginner Regards, David Becks >> Also are there any useful VFP books for a beginner Probably the best is still: "Fundamentals: Building Visual Studio Applications on a Visual FoxPro 6.0 Foundation" by Whil Hentzen. Get it here: http://www.hentzenwerke.com/catalog/fund6.htm Although it was written for VFP 6.0 the basic tools and principle ...Show All
Darrin Turner drop-down combobox problem
Hi I'm still struck with the combo drop-down part problem for nearly 2 weeks and need help from you. When the values of these 2 textboxes match with each other, the list of employee is able to display on the combo drop-down. But I have one problem :- The list of employee on the combo drop-down repeat unnecessary (even a few blanks) when i changes the values of textboxes. How to refresh the combo drop-down once the values of textbox changes Thank you. Millbear, It's not clear what you"re trying to do, what those 2 textboxes are about. I assume you put values like 'A' and 'B' in those textboxes and expect combo to show Employees whose firstName start with 'A' and lastName starts with 'B' If so then the ideal ...Show All
