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!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. trideryck

    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...
  2. trideryck

    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...
  3. trideryck

    Invalid FAT or FAT32 partition problems

    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...
  4. trideryck

    Invalid FAT or FAT32 partition problems

    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...
  5. trideryck

    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...
  6. trideryck

    Updating a table from a free table

    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...
  7. trideryck

    Updating a table from a free table

    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...
  8. trideryck

    Updating a table from a free table

    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...
  9. trideryck

    Updating a table from a free table

    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?
  10. trideryck

    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...

Part and Inventory Search

Back
Top