Speedier Procedure
I have a procedure that will take the active field and then searches the entire database and finds all records that have the identical data.
I am running Mac OS Sierra, and Panorama 6 (transitioning to Pan X but the patch on my arm saying Panorama 6 is not always working). Mac Pro late 2013.
The database has a little over 14,130 records.
If I simply go to a field and do a simple menu Search Find/Search command it is basically instantaneous for the results.
However, if I run my Macro or Procedure it takes about 5 seconds.
I have not tried it yet in Pan X. Still adjusting.
Here is the Procedure:
;Named “FindSameContent” Will find all same fields as active one that are exactly the same
Local LContent
Copy
LContent=clipboard()
execute “Select «”+info(“fieldname”)+"»=clipboard()"
I had a similar issue for a Procedure called “ThisRecordOnly” which simply selects only the active record.
Original Procedure takes about 5 seconds.
noshow
Field “ID”
Copy
Select ID = Clipboard()
Endnoshow
Whereas this procedure is below basically instantaneous with over 14,000 records.
;This is called “This Record Only Speed”
noshow
Local LRecordID
LRecordID=ID
Select ID=LRecordID
endnoshow
What is the issue for the incredible differences in speed?
Is there lurking somewhere a “Select Active Record Only” function or command, just out of curiosity?
Regards,
George Beauchemin