Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
How to resolve an ODBC Error Code = 07001 in my query?
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... -
How to write an SQL statement for counting distinct
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...- trideryck
- Thread
- Replies: 1
- Forum: Microsoft: FoxPro
-
Invalid FAT or FAT32 partition problems
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...- trideryck
- Thread
- Replies: 9
- Forum: Microsoft: Windows
-
Updating a table from a free table
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...- trideryck
- Thread
- Replies: 10
- Forum: Microsoft: FoxPro
