Search results for query: *

Thank you Olaf! It worked like a charm... [smile]

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

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

Thank you guys! Ricks solution did work, although I will try Olaf's as well.

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

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

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