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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by cacho1973
-
Search and replace comment field...
Thank you Olaf! It worked like a charm... [smile]- cacho1973
- Post #3
- Forum: Microsoft: FoxPro
-
Search and replace comment field...
Hello everyone! I have a VFP table with certain values. I need to replace, using a certain criteria, those values with 0. Example, if the field "type" is REPA, the "thickness" should be 0, but if the "comment" field start or contains the word "half" should not be modified... (e.g "half...- cacho1973
- Thread
- Replies: 2
- Forum: Microsoft: FoxPro
-
Two tables updating records
Olaf, thank you so much for the clarifications. I said I was a long time reader, but not a foxpro developer. This webpage has so many resources for many languages... Actually I am Visual Basic developer with experience in Access databases only, learning some Objective C, but now I have a new...- cacho1973
- Post #11
- Forum: Microsoft: FoxPro
-
Two tables updating records
Thank you guys! Ricks solution did work, although I will try Olaf's as well.- cacho1973
- Post #8
- Forum: Microsoft: FoxPro
-
Two tables updating records
CORRECTION TO LINE It is not working yet... CLOSE TABLES SET PATH TO c:\xxxxx select distance, time FROM Table2 *Choose your poison: index on distance tag main index on distance to table2.idx select * FROM Table1 *Choose your poison: index on distance tag main index on distance to...- cacho1973
- Post #5
- Forum: Microsoft: FoxPro
-
Two tables updating records
Rick, yes, I want table1's time to be table2's time for all records that match the table2 distance and time is not null, because time in table1 does not allow null values. The code I wrote using yours as base, did not work, and it shows "Cannot update the cursor QUERY since it is read only"...- cacho1973
- Post #3
- Forum: Microsoft: FoxPro
-
Two tables updating records
Hello everyone! First post here, long time reader. I have two FoxPro tables e.g. Table1.dbf and Table2.dbf Table1 with fields distance(numeric), time(character), type(char), address (char) Records=200 Table2 with fields distance(numeric), time(character) Records=25 If the distance in table2...- cacho1973
- Thread
- Replies: 11
- Forum: Microsoft: FoxPro
