Message
From
27/07/2003 11:43:00
Mike Yearwood
Toronto, Ontario, Canada
Toronto, Ontario, Canada
To
27/07/2003 05:25:10
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Miscellaneous
Thread ID:
00813878
Message ID:
00813908
Views:
10
Hi Chaim
Make sure there is an index on tablename in tableids like this...
INDEX ON PADR(ALLTRIM(tablename),10) tag tablname
This would be faster...
Make sure there is an index on tablename in tableids like this...
INDEX ON PADR(ALLTRIM(tablename),10) tag tablname
This would be faster...
function addtableid lparameter ctablename SEEK padr(alltrim(cTableName),10) in tableids iid=tableids.tableid replace tableid with tableid+1 in tableids return iid endfunc