Search results for query: *

Must have used the sql insert command thousands of times but clearly doing something silly. Inserting a record with 6 fields but the _tally kept showing 0. Decided to just add one field and still no luck. If I create a new table and use the same code it works fine. If I use the append blank...

Have been working on updating a system that has worked fine for years. Have recompiled my test app dozens if not hundreds of times over the past few months with no real glitches. This morning I recompiled and got an error message saying that my app is not a table. I removed the program that...

I've imported excel xls files dozens of times into vfp but for some reason having trouble. Doesn't matter if I use a wizard or just a command. Also is happening on two machines--one at work gets an error message saying it can't write to a temporary file. At home it just shuts VFP down saying...

Have a VFP9 exe with a handful of machines all running XP. No problems but will be adding some Vista machines. Are there any things to look out for when running the InstallShield routine for a mixed operating system environment? Any comments much appreciated rgw

Did some work last year converting credit card data into an encrypted field using the native VFP _crypt.vcx. Got sidetracked onto something else and have only just picked up the test data again. Have a file with thousands of cards and I've found that although the vast majority...

I've been trying out an encryption routine from an old Data Based Advisor article (using the foundation class in VFP). On a Windows 2000 machine running VFP9 seems to work fine--i encrypt the data and am able to bring it back as expected. Problem occurs when I run exactly the same routine on...

I have a form which works fine at the moment but I've been trying to reduce the amount of code. Depending upon the type of claim there can be many different types of input required. In the past I've caught the choices in code but I thought it would be easier maintenance- wise to put them in a...

Would appreciate a bit of help on the 'set key' command. I have a networked table of approximately 75,000 customers and use a select statement to bring in the appropriate records for the selected zip. The user clicks a check box in the zip grid. I was experementing with the 'set key'...

I've always used the filetostr() function to convert txt files to a dbf file. Never had to convert more than a thousand records and it only takes a few seconds. Results have always been as expected. May now have to do daily imports of fixed length text files--30,000 records and 10mb in size...

Have been running a VFP 6.0 under Windows 95 for years with minimal problems. Have finally got around to writing a replacement for Windows 2000 with VFP8. Problem is that I cannot seem to share files. The current system places the executable on a shared (but restricted) network drive. The...

Would appreciate any insight into a form which has suddenly stopped working. Form is based on a parameritized view of the zip code file with the user inputting a zip code. Once the zip has been selected it is shown in a grid and if correct the user confirms the single zip or selects the...

Would appreciate a bit of help with what is probably a simple one. In the de of a form I wish to remove a cursor but I can't find it in the visual representation of the de where a simple press of the 'delete' key normally does the trick. It certainly exists in the de because I can see it in...

I am rewriting a routine for showing the user information on transactions which result in the creation of a check. I have a sql select statement which shows the individual transactions with a calculated column which shows the amount of the check which may be made up of many individual...

My daughter's PC running ME now freezes when she tries to open a Word document (only happens in Word)--at the lower left of the screen she gets 'Requesting Virus Scan' and the hourglass. Only exit is a complete reboot. would appreciate any help. rgw

I've been rewriting an application to make greater use of views and so far so good until this morning. I'm working in vfp8 and have the user prompt for a value which then gets queried and shown in a grid on the form. This worked fine last night and when I ran the form this morning I get an...

My views work fine if I'm working with tables that don't have a one-to-many relationship but I run into trouble when I have the following: I have a check file (parent) which will have a single record for check '111111'. The child table may have several detail records. Different transactions...

I'm having a problem with an updatable view. It contains a view of fields from 4 different tables (3 in a .dbc and one free). If I code the sql myself joining the tables everything links together but when I try and duplicate the results in a view it gives me an error saying it can't find one...

I think I had this problem once years ago but cannot remember what I did to fix it. Have a simple report which may contain one or a few lines of payment data. Problem is that the first line repeats many times. Report was created with a wizard and subsequently modified. One would think it was...

Have an exe.based system which runs in our WIN95 network environment. New machines are WIN2000 professional so we are running a mixed system (perhaps for years). Will my exe. which was developed in 6.0 on 95 run on the 2000 machines?. When I run setup I'm being told that "Can't run...

My forms have always used table buffering (5) and updating or reverting have always worked fine. Thought I'd change them where applicable to row buffering (3) but I'm having a problem. If I write a small test program setting buffering to 3, append a record and then immediately issue a...