Search results for query: *

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

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

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

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

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?

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

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