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 Chriss Miller 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: *

  • Users: DiGi2
  • Order by date
  1. DiGi2

    Select statement field length Last name

    I have a table that has Last name and first name in 1 field seperated with a comma. Example : GUTIERREZ, MERCEDES If I issue the command line ?left(customer,At(",",customer)-1) I get GUTIERREZ however when I do a select statement and try to do all the records, they are all truncated. No...
  2. DiGi2

    Update a table with another table

    Thanks for your help I did get it to work with this code. Not artful but effective. It updated about 75,000 records in less than a second USE CP1231 IN 0 USE JAN2REPORT IN 0 select JAN2REPORT && values come FROM this table scan update cp1231 ; set inspector = JAN2REPORT.column1 ...
  3. DiGi2

    Update a table with another table

    I also tried it Dan's way with some test data but I got "unrecognized phrase or keyword" Use jan2report order column2 in 0 Use cp1231 Order wordnumb in 0 Select cp1231 Set Relation to wordnumb into jan2report Replace all (cp1231.inspector with jan2report.column1) Use in cp1231 Use in jan2report...
  4. DiGi2

    Update a table with another table

    I did try it and it didnt work. Does the sytax look ok ? 2 tables jan2report (column2 is field name and has control #) cp1231 ( wordnumb is control #) Update CP1231 Set inspector = jan2report.column1 From jan2report Where Jan2report.column2 = Cp1231.wordnumb I get an error unrecognized command
  5. DiGi2

    Update a table with another table

    Thanks Olaf Is that feature not available in VFP 8.0 ? I had never used Dan's way either. I will give his a try if I cant update to VFP 9. I will have to research the replace all command Can you even buy VFP 9 anymore?
  6. DiGi2

    Update a table with another table

    I had an old Visual Foxpro book and I remember seein g a program that did this. Unfortunatley I dont have the book anymore. I used to keep a library of code snippets that did certain tasks. The one I had went something like this Use inspections in 0 use CP order orderno in 1 sele inspections...
  7. DiGi2

    Update a table with another table

    Thank you in advance for any help. I have not used foxpro since the mid 80s. I have not even programmed in over 10 years but I have a problem and want to use VFP. I have 2 tables with different structures; CP and Inspections. Both have an orderno. I want to use table CP and loop through it If...

Part and Inventory Search

Back
Top