add item to a list and check that it's not on list

[rollypac]

I have a file with an id# and table id#.
I used seek to check if the id# is there. How do I get it to look at all instances of that id# and check if the table id# is there or not, and add if not?

 

[TamarGranor]

You have lots of choices here. I'll assume you don't have an index tag on the combination of ID and TableID, but do have indexes on each of them separately. If so, your best bet is probably code like this:

SELECT YourTable
LOCATE FOR ID = m.nID and TableID = m.nTableID
IF NOT FOUND()
   INSERT INTO YourTable ;
     (ID, TableID) ;
     VALUES (m.nID, m.nTableID)
ENDIF

Tamar

 

[rollypac]

Thanks Tamar. It worked like a charm.