Answer Questions

• SIDR No changes apply after build exe

  I have add in new form, make amendment to the menu for existing project. Then I rebuild the project and rebuild the exe file. However no changes seems to apply in exe when i run the exe file in live environment. I make all the changes in my test environment, when I run the exe in my test environment the changes apply. When I put it in live environment no changes apply. I wonder what's wrong with my step on building the exe. Please guide me on how to add in new form in the existing project, make changes and generate menu, plus building project and exe file in visual foxpro 6. Thanks. put set step on in the menu item where u are calling the form and run the app or prg. if u go to trace mode and the form u h ...Show All

• Pedro A. G. Carvalho Linking a DB from Access 2003 to a ForPro application

  Hello all, I am new using FoxPro, actually I have never used FoxPro. My company have a FoxPro application (VFP Version: Visual FoxPro 08.00.0000.3117 EXE Support Library for Windows [Sep 25 2003 20:47:46]). I am currently creating some forms using InfoPath. This forms are linked to an Access db. I am using Access 2003. What I would like to do is, past that information from my Access db and link it to the information in the FoxPro application. This application has been in production for the last 2 years. Is this a simple procedure Can somebody give me some suggestions or something. Thanks in advance Erick, It's hard to guide someone who has never used VFP before. Unlike Access, VFP is geared towards programmers. Anyway this might ...Show All

• dbldown768 why dos cant print chinese character

  hi all, i using foxpro to print my report but the alignment is not correct. therefore i use another way round using foxpro call run textfile.txt >LPT1 then the printing alignment is solved. But another problem is it cant print chinese characters. Wat i shud do Thanks in advance. It should not a vfp problem, try quit vfp and run c:\>type mytext.txt > lpt1 at dos prompt to see if any Chinese characters. It should only work if your printer has build-in BIG5 character ROM. oooo ic ya i have even type cmdat dos prompt echo test >lpt1 but cant show the chinese characters. thanks FYI. ...Show All

• PsychUK VFP 3.0 on XP

  I need VFP for a small project, and I don't want to spend USD 600 for a new version (is there a beta version still available ) Is it ok to install VFP 3.0 on Win XP Thank you, Tor Henrik i'm currently using vfp 6.0 for almost 4 months. So far, it does not give any problem. What's the difference between vfp 6.0 and 7.0 Ken, I like the hammer vs nail gun analogy!!! Lamon Beta is not available anymore. In any case you should not deliver software based on a Beta version as it is bound to be slow and buggy. That's why it's in Beta. VFP 3 will install but you are talking of the oldest, buggiest, less-capable VFP version. I would reconsider. ...Show All

• Amos Soma should I uninstall vfp6 before I install vfp9?

  hiya, I have vfp6 (as part of visual studio install) Should I uninstall it before I install vfp9 cheers, yogi yogiberr wrote: I have vfp6 (as part of visual studio install) Should I uninstall it before I install vfp9 Only if you want to for some reason. They co-exist very happily on the same machine. I have both versions on my machine. thanks folks, it's now successfully installed.. yogi No need to. You can have all versions installed in the same PC as long as you install them in different folders. Be aware that the Windows association will go to the last installed version. (i.e. if you click on Explorer in a V ...Show All

• Amos Soma Merge 2 text file

  Hi... I have to text file. Can anyone advise how to combine 2 text file into one file using Visual Foxpro 6.0. Thank you. You're not really combining 2 txt files but 2 sets of data. If you were combining 2 text files then it'd be as simple as: strtofile(filetostr('destination.txt'),'product.txt',.t.) This appends destination.txt content to product.txt. You could get the data into cursors and then join and write them back to a 'merged' text file. However there is no relation in your data sample for a join so I don't know what is the logic behind making "penang" as destination for product A01. If you mean it's simply a line to line match:   lcProductTemplate = "product id  &nb ...Show All

• dn8 Wrangling a Grid

  I know that this is bucking the norm, but I am trying to use a grid to edit data in a cursor that I have created from a local table. The problem I am having is that the columns containing numeracle values or integers, the control becomes readonly. I have the grid on a form, and I am assigning the recordsource and controlsource programmatically after creating the cursor in the Init method of the form. Thanks in Advance - Any help would be appreciated. Probably you're causing it to be readonly unintentionally somewhere. Otherwise it works w/o problems. ie: PUBLIC oForm oForm = CREATEOBJECT ("myForm") oForm. Show DEFINE CLASS myForm as Form datasession = 2 ADD OBJECT m ...Show All

• rodolfosp Not able to run foxpro exe file (urgent)

  Hi , I have a foxpro forms and reports. when i run from desktop . it is showing 'CANNOT LOCATE THE MICROSOFT VISUAL FOXPRO LIBRARY' I got these files from client. i have installed my visual studio in 'C:\Program Files\Microsoft Visual Studio' So I have to anything in my WZSETUP file , In this file they have mentioned everything. Like source and destination. i have dbf files and forms and reports in this folders. Now i am not able to my client exe file. Kindy anyone tell me the solution Thanx and Regards Selva.R >I opened the Login.Fxp file (i think that is first form of the project). >So i opened i started  studying the whole system. >FXP is nothing but a forms right. ...Show All

• fripper How can I check whether a cursor exists or not?

  That's the question. Thanks I'm not sure what do you mean, but I think a simple if used command should help. if used("curSomeCursor") wait "Cursor exists" wind endif Mmmh, it worked, that's weird because the first time I used "used" didn't work. ...Show All

• noob2vb Auto-updating application

  I have an applicaiton that needs to auto-update via the web, I have done this before so the web process is all sorted. However, this application is a sub-component of an existing app so I need to shut down the sub-component for update, but not the main application. I am not sure this is even possible, but any pointers would be great. Basically the file is in use - can't update etc. I have pulled the code back to it's barest minimum that fails: main exe calling a separate application with the following code only in startup: LOCAL loObject loObject = createobject("SomeClass") DEFINE CLASS SomeClass as Custom ENDDEFINE Basically the introduction of a class creation prevets me from then unloading the application. btw I have trie ...Show All

• Bartosz What comand to clear content of General field?

  - What comand to clear content of General field Now I only use menu Edit/Clear to clear content of General. I want use commad in program to clear it. - Why when cleaned content genefield but size of file .FPT too large ! Thanks! Hi, can you give the extract of the code you are using so that we can help you better... Markish Table customs.dbf has field CUST_BMP(G) ... 1 -Now I want clear content field CUST_BMP all Use customs share Scan for not empty(cust_bmp) Append general cust_bmp EndScan ... 2- Why when clear content of general is OK but size file.FPT too large Hi, Try USE mytable EXCL PACK MEMO HTH ...Show All

• Abhilash CR BUG: Microsoft Visual Fox Pro ODBC Driver (6.1.8630.1)

  The bug is: driver doesn't support autoincrement fields: while trying to use any table, contains autoincrement fileld, the exception "Not a table." is thrown. It is not a bug. ODBC driver is documented not to support versions later than VFP6 (and won't be updated - latest was MDAC2.5 or 2.6). Use VFPOLEDB driver instead. You may check to see if you have same problem like: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=1167816&SiteID=1 also you may update ODBC Driver from: http://www.microsoft.com/downloads/details.aspx familyid=e1a87d8f-2d58-491f-a0fa-95a3289c5fd4&displaylang=en >> The bug is: driver doesn't suppor ...Show All

• ZaaM IT 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. That is an amazing amount of work for nothing. Your searches should be on UPPER() anyway, trying to force caps lock is simply poor design and coding. Set your code up properly by coding for this, it takes much less time to Code properly. You have wasted much more time waiting for an answer about the wrong way. The original application (And also the VFP converted one) Assumes that all DATA is entered in upper case. Searching data when the data could ...Show All

• Kimmy program starting problem, grid problem

  Hi I have several beginner questions for VFP 8.0 1) Where should I put the READ EVENTS method so the main form will show itself instead of showing the fox pro main window 2) When executing SQL simple select statement for filling a grid, it fills the grid inside the form, but firstly it shows the result in a grid outside the main form. How to show result only in the grid placed on the form Denis, First where you go wrong: You're doing a "replace" after a select and go top. Replace have a default scope of "next 1". So you're only telling it to replace a single record. It should look like: select myCursor scan if seek(keyfield, 'tasks', 'keyfieldtag') replace ...Show All

• George2 Visual FOXPRO ODBC Drivers... still broken in Vista RC2

  Hi. Does any one knows where i can get the Visual FoxPro ODBC Drivers for Windows Vista Thanks. Helder Santos I don't think that the current download/install of VFPODBC (VFPODBC.MSI) hasn't ever worked on Vista, and I notice it's still broke in RC2. Is VFPODBC going to be supported in Vista ODBC Drivers are not Operating System specific, they are product specific. The last version of the VFP ODBC Driver was for Version 6.0 and you can get that from this location: http://msdn.microsoft.com/vfoxpro/downloads/updates/odbc/default.aspx (look for the "Download VFPODBC.MSM" link). This will work with later versions of Visual FoxPro providing that t ...Show All