General information
Category:
Coding, syntax & commands
>>>>>Perhaps with the selfsame command, but adding an index on the key expression - an index on dtos(dTraBan) + cRefBan..., especially in the historical file.
>>>>
>>>>Thanks Hilmar. Tried and didn't seem to help much.
>>>>
>>>>Alex
>>>
>>>Other options include an outer join, and doing a SET RELATION to the history table (copy those that have something like eof("HistoryTable")). I am not sure whether any of these options would be faster.
>>
>>Hilmar and Naomi,
>>
>>I am going to add a column with a hash of the others and compare the hashes. Looking for hash function...
>>
>>Alex
>
>May be you can use CHECKSUM() function? Have you tried my other suggestion, BTW?
I tried your other suggestion, including making fields all caps, but didn't work.
Creating an extra field filled with SYS(2017) and then comparing that field seems to work. I am double checking. Will let you know results.
Thanks Naomi and Hilmar,
Alex
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