Answer Questions

• Crobat Problem Installing VFP 9.0

  When I try to install VFP 9.0 by clicking the link on the auto run page that appears when you insert the disk, I get the message "Please go to the control panel and add or configure windows components" If I run from the add programs in the control panel I get the setup screen and click Prerequisites and get the same message. What needs to be installed or configured I am  up to date on all updates and I have every windows component installe ...Show All

• liffey I have a corrupted table. Is there a simple, FREE way of repairing or recovering the data?

  I have a corrupted table. Is there a simple, FREE way of repairing or recovering the data Thanks, Jim Sure it does ... Try this one . Run the following command from the command window: Set table validation to 0 Now open your table, add a new record, delete it and pack the table. Works in most cases !!! Jim, (Make sure you have adequ ...Show All

• Mumshelp Using Browse command in VFP9

  I used FPW2.6 untill a month ago , since then I convert most of my old programs to VFP9 , all is working fine except one major problem I have , the Browse command is not working in an stand alone EXE program , I know I can use the grid option but still the browse command was an easy way to display records in a file, is there a way to use the browse command in an EXE file Thank's for help What, exactly, "doesn ...Show All

• Kijju Input mask for a spinner

  I've defined an input mask for a spinner as $$99999.99 It displays the value $ 855.09 as $ 955.9 What am I doing wrong Thanks. >> ... but I could not find any way to ADD a method at runtime. That was my issue. Perhaps you know how it can be done The short answer is that it can't be done directly. There are two possible solutions to this requirement depending on the nature of the code required: The first ...Show All

• slarin Grid objects problems/questions

  Hi everyone. I've just started using Grids in VFP9. I am trying to setup a grid which will collect info about an order. The record source of the grid changes depending on the user. I use the temporary table in the users 'home' folder in order not to conflict with other users. Here are my questions: - First, what is the best way to have a temporary file used in my form: Do I add the table to the dataenvironment at runtime Do I issue 'USE' comm ...Show All

• Stuart Campbell error registrated COM object as MULTI-THREADED COM SERVER DLL

  Hi! on Visual FoxPro 6.0 I created COM object (my_com.dll) as MULTI-THREADED COM SERVER DLL. but when I try registrated COM object I got the error regsvr32 my_com.dll "DllRegisterServer in my_com.dll failed. Return Code was: 0x80004005" Why Hi.  First of all, you should be on VFP6SP5.  I'm assuming it works on the machine you compiled on(it gets registered when you compile it) and you're now distributing to another mac ...Show All

• Andy Sloan VFP free tables in compressed folders

  Will Visual FoxPro free tables work fine on compressed drives or in compressed folders I am talking about the NTFS compression found under advanced attributes. I have several folders with hundreds of .dbf files used in out VFP app. I would like to compress these folders to save disk space. Hi Dave If Bill is talking about the standard NTFS Compression option (which is what he said - you know, where the drive shows up blue in Windo ...Show All

• Sane VFP 9.0 SQL worthless under a non client server network?

  Hello everyone; I have posted this problem here and also on UT and no solution yet. I have a small network with a 2003 server, and XP pros. I am running vfp 9 select * from products where status = "S0000" takes apx 10 seconds when run over the network. When running this locally, it takes only a fraction of a second. The product table contains 100,000 records, and the result of the SQL command is just a few hundred rec ...Show All

• Rickard Magnusson empty field

  is there a better way of checking for empty fields than select *; from myTable; where field1 = " "; into cursor data1 i need to run a complete check on the database for empty records in every field. How would i check for a 'date' data field Mike Thanks Dave.. I appreciate all your help! mike It is a good point. How useful it for many eyes to view the same problem! I got used to using an intermediate memory variable but your idea i ...Show All

• Lars Brange simple report question

  I'm writing a report (.frx file) and from what i understand, all the fields that i want in the report need to be in the final cursor that I create. Is there a way to pull fields from another table and put them in the same report. I have a table with years and appropriate data per year, which all goes into the report no problem. I want to total all the data/year and put it at the bottom of the report. Now, I can total all the data in another tab ...Show All

• BallardGuy Why this SQL select command is not optimized?

  Hello. I have turned on rushmore level messages using sus(3054,1). I run the following from the command window: select * from ruginv where status = "ST000" ruginv does have an index tag on status. The response I am getting is that rushmore optimization level is NONE. I have set optimize on. Why is this query not optimized Thanks, Aleniko Tamar, Codepage ...Show All

• Remy Duchet Scan and replace

  i'm trying to replace all records from one table with records from another table. It stops after the first record is replaced. This is my code. USE invent06.dbf shared again IN 0 USE ptd.dbf shared again IN 0 SCAN ALL FOR invent06.code=ptd.code IF invent06.store=ptd.store replace invent06.cost WITH ptd.cost invent06.cost replace invent06.Ptdpurchq WITH ptd.Ptdpurchq replace invent06.Ptdpurchv WITH ptd.Ptdpurchv ENDIF endscan CLOSE al ...Show All

• Jags06 what is the maximum field VFP9 can handle

  Good day to everybody... just a little problem with my update at VFP interface with my back-end database I dont have this problem updating my employees table in SQL2000 with 35 columns at my VFP interface, but recently I add another 3 columns at my table, that's where I encounter this problem. Inserting a new record or deleting there's no problem, but when i edit a particular record then saved the changes,the update is OK.. but after I clo ...Show All

• B.H.V.Ramakrishna 2 more questions (VFP8)

  (1) I've made and deployed a simple app. with its own helpfile, but when deployed, nothing happens when I press F1. (It is not, that the app cannot locate the helpfile. If I rename it, I get an error when starting the program.). Any suggestions (2) The other problem is, that about one in every 4 times I close the program, the process keeps hanging and thus locking my datafiles. (When I kill the process, the datafiles are corrupted, when I start ...Show All

• CyberYodaCY Accessing FoxPro 2.x tables from VFP 9

  Hi, i have found, that VFP 9 cannot optimize selects / updates / deletes on FoxPro 2.0 tables - it does not use any indexes defined for these tables. When i was manipulating these tables from VFP 6, there has not been problems and all selects / updates were optimized. Can someone help me to find solution for this  Thanks in advance Actually, there are two different issues. One is a bug and the other is n ...Show All