Walter Meester
HoogkarspelNetherlands
General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Hi Nadya,
>>SCAN FOR !KEYMATCH(ProgID,nYourTagNo,"Table2")
>
>Great! With KeyMatch it took only 29,5sec. with set deleted on and 23,8 sec with set deleted off.
>Yes, you suggested the best method. The only little problem with deleted records, but I may add another condition in scan for!keymatch() and !deleted('PropMstr') It should not slow down the process.
Sorry to disappoint you but the DELETED() function is getting you nowhere here. Since the recordpointer in the second table is never moved there is no quick way to check if the related record in table2 is deleted, unless you'are sure that the index does not contain any nodes for deleted records. This can be done in two ways:
1. ensure that there are no deleted records in table2.
2. ensure that the index used in KEYMATCH is filtered with "FOR !DELETED().
Walter,
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only