I have a simple (and crude, I know) query that had been working for many years on my webpage that recently "broke". It searches my database based on country, state, and county. Can someone lend their thoughts and suggestions? I've listed the form and result html with the coldfusion pages below...
I am using VFP 6.0 and I am trying to put together a simple SQL statement that will count how many occurences of each distinct record I have in my database. Here is a sample of my data:
First Last City State Zip
John Adams Midland Texas 79703
John Adams Midland Texas 79707...
After running FDisk, and rebooting, I cannot format drive C because "Format not supported on Drive C" - drive C is instead defined as a RAMDRIVE by the win98se bootdisk.
I've been looking for a more recent version of Fdisk - the one that was on the win98se boot disk was from 1999. I used a...
1. When I run FDisk and choose #4, it tells me No partitions defined. This happens even after I've run through FDISK. It's just like it isn't saving the partitions anywhere. Is there a way to reboot that I am missing - I've tried both power on/off and typing restart at the a:\ after exiting...
I am trying to salvage a SONY Vaio (PCG-F560) laptop whose original hard drive died. I have since replaced the hard drive and am trying to get up and going with Windows 98SE (because anything more than that wouldn't run on this poor old laptops max 256MB memory).
I have tried to install Windows...
Heh. I recreated everything from scratch and it worked for me too. The problem was that my initial database was not in the default path as my VFP98 program.
It worked when I moved everything to my default path:
C:\Program Files\Microsoft Visual Studio\Vfp98
So...I guess my question now is how...
Well, when both tables weren't in the database, I was getting "VARIABLE parnum not found', and I wasn't sure how to fix that.
As for my tables, they have identical fields and lengths.
both original and newdata tables only contain fields:
partnum (integer, index ascending)
price (character...
Okay, initially I had the table 'original' in my database, and the table 'newdata' as a free table in my database. Both have partnum as a field. I went ahead and added newdata as a table versus a free table. Doing that gives rid of the variable not found. However, now...
When I run the code...
When I add either approached into a program and run it, VFP cannount find the variable 'partnum'. Where and how do I declare this in either of the examples?
I am using a VFP 6.0 I inherited with the job and am having a little trouble updating it.
The table I want to update has over 100,000 records and uses the primary key partnum. I only want to update one field in the table (i.e. price), and only for those records where partnum matches partnum in...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.