Answer Questions

• Tdar my SQL passthrough problem

  Good day to all, could i ask where i got wrong with this code , because when i run the .prg for this code, at first try it won't work, then the second time around it works, as if no error. Like when you open VFP, then at the command window you execute the do command, it won't work, but at the second or 3rd try it works. Please help...thanks in advance LOCAL lcConnect STORE 0 TO lcConnect STORE SQLCONNECT ('My SQL Server C ...Show All

• Giovanni Costagliola newbee - does VFP9 have a runtime engine?

  In a former life I programmed in dBase/Clipper/FoxBase and other extinct languages.  An old Clipper application from 1987 needs updating and they do not have a Clipper compiler.  My thought is to rewrite the app in Visual FoxPro 9, which I will order next week.  I need to figure out how many copies of VFP9 to purchase.  One copy for me, one at the client location...  Is there a runtime engine in VFP9 Do I need a so ...Show All

• king kailas Using a Lan Connection on Visual FoxPro 9

  hi guys...im just new here on this forum...i am about to work on my thesis and i chose visual foxpro 9 as my software development tool..im planning to create an enrollment system for a certain school..im just wondering that if im going to create this type of system, i need to make LAN connections because enrollement system includes sectioning,assessment and payment. actually, i dont have any idea of how LAN works on visual foxpro and the things ...Show All

• Alan Stevens weird IIF output. Help!

  I was using IIF to perform simple calculation: I have a data base field "case" if the case = 0, I want to display 1, otherwise, show the database data I use SELECT IIF(case > 0, case, 1) FROM table However, the result is very weird. If the case < 10 (1 digit), the result is correct If the case > 10 (2 or more digits), the result shows "**", When I try to display it with strings IIF(case > ...Show All

• gaxtell How using barcode in VFP?

  Hi! Help me use barcode in VFP use ActiveX controls Where download it Thanks! Hi!    No programming done for you to capture a barcode no., what you will do is just to connect the barcode reader device to the CPU on the keyboard port and look for the manual attached to trigger the device. -Dodo Roa- Hi, Actually when you read a barcode, its just like typing the serial number e ...Show All

• Sagan33 Report

  Instead of have to hacking the visual foxpro report table and erase the paper information from the table, Is there anyways that not to save the paper information i know that by turning of save printer infomation, vfp would not save the printer information. I want to give the users being able to change paper info including the orieantaion information on printing the report Thanks for the reply. I am using ...Show All

• Christopher J. Cooper Memory acces error

  I need some help... When closing our application we are getting the error message "The instruction at "0x02245e30" referenced memory at "0x02245e30". The memory could not be "read"". We don't know what is wrong... any suggestions on how to fix this Any input would be really appreciated. >> Where do I type this "Set to null" instruction ...Show All

• Andy-J VFP to show UPS tracking info.

  Hi; I have a place in my app where I populate a grid with various info including a txtbox that stores a UPS tracking #. I'd like to make this 'clickable' so it opens up a web browser to show the ups tracking info from the UPS site. I would need to do the same for fedex. I have no idea where to begin. Any pointers and ideas would be greatly apreciated. Aleniko. Here’s the Shell Execute, it wi ...Show All

• arun_84 toolbox trouble

  All of a sudden, out of the blue I got a problem with the toolbox. When I click the button on the bar to invoke the dropdown menu with the controls depicted I get an error message instead. Program error File 'aclsids.prg' does not exist When I click suspend, the debugger appears at this position: Object: _activexcategory IF EMPTY(aCLSIDs[1]) IF oReg.EnumOptions(@aCLSIDs,m.cActiveXKey,m.cHKey,.T.)#0 RETURN .F. ENDIF ENDIF The arrow ...Show All

• Triskell2k1 Launching Adobe Reader Programatically

  Is there a way to launch Adobe Reader with a file name from within VFP90   I want my users to be able to print PDF files without having to search for the files - the search would be done through the GUI. Thank you, Thank you, I will try it.  I knew there had to be a way. Wow, thank you very much. FUNCTION ShellExec LPARAMETER lcLink, lcAction, lcParms   lcAction = IIF(EMPTY(lcAction), "Open", lcAction) lcP ...Show All

• Mulktide Overload possible

  I need a way to overload a fox function like Empty with a UDF of my own called Empty. Is this possible If Fox doesn't support overloading, is there a class I can inherit from and override the empty function I need help ASAP. Thanks, VFP is not case sensitive. I would not just blindly replace EMPTY with MyEmpty as it make maintenance difficult. Just call MyEmpty where you need it. Empty is already called many times through out the ...Show All

• bhowden Number of variables

  When I create a 200 x 200 array dimension MyArray(200,200) no problem, but when I try to create a 400 x 600 array, I get a "Too many variables" message. How could I make my application work Thank you for your help. Michel Cariotis I have never gotten this error nor can I replicate it, but ….. Prior to ver 9.0 Arrays where limited to 64,000 elements, yours has a whopping 240 ...Show All

• James Dean Cursoradapter error: Optional Feature Not Implemented

  Hi all, Am creating a cursoradapter connecting to an Access database, using ODBC and a DSN name. However, when I make changes to the cursor and issue a TABLEUPDATE, I get the error: [Microsoft][ODBC Microsoft Access Driver]Optional Feature not implemented. However, If I use ADO, and the same DSN, the Tableupdate is performed without errors. The problem with the ADO is that it pulls a OLE field from access as a Memo field into the cursor, but the ...Show All

• Scottzrn Link data base file

  Been trying to link, in access, a dfb, without corrupting the file to be used in other fox pro type software. Any idea's What do you mean by "link" If you want to read DBF data you can connect through an oleDB Provider. http://www.microsoft.com/downloads/details.aspx FamilyID=e1a87d8f-2d58-491f-a0fa-95a3289c5fd4&DisplayLang=en You can also use the old VFP ODBC Driver but that one is older ...Show All

• Jan Shao scroll bars in editboxes

  Somebody can tell me why scroll bars in editboxes disappear when I run an VFP 7 application . All seems work fine in the VFP environment, but when .exe runs, no more scroll bars. I have intented all, without success. Of course text is large enough to force VFP show scrollbars. I would appreciate any comments. Thank you. >> Somebody can tell me why scroll bars in editboxes disappear when I run an VFP 7 application This w ...Show All