Hi Jojo,

Thank you for your reply,

*****
SQLEXEC(Con, 'SELECT * FROM PRODUCTS','RV_PRODUCTS')
SELECT RV_PRODUCTS
INDEX ON PRO_CODE TAG P_CODE
INDEX ON PRO_NAME TAG P_NAME
INDEX ON SUBS(PRO_CODE,1,3) + STR(PBARCODE) TAG P_BARCODE
SET ORDER TO P_CODE
*****
Question 1.
Is it prossible to put different key(order) into 'PRODUCTS'.
It will make my system slow, if i need to load the data from MySQL, and make the index on it. ?


I reading some book about SQL, They said it is the fast way to seek record.
but i think that... it will make the system running slowly on data entries and user friendly.