Search results

HI all, I'm trying to assign a sequence number to certain rows in a table - only those where the Migrate? field a mapping table is marked as True. Can't get it to work. I get 'Invalid use of property' on the strsql at the start of the sql statement: sub testit() 'Now add the sequence number...

JHB spot on, works fine. Thank you

Hi all, first post so be kind :-) I am looping through a series of tables deleting the data in them. That's the easy part and works fine. Now the bit I'm struggling with. Each and every table has a field called ID. If the value in this field is 1, I don't want those rows to be deleted...