Hi,

I am a new guy in MySQL, i can connect the Database-Table as below:

Con = SQLCONNECT('yourDSNName','yourusername','youruserpass')

And now, can you tell me some change in :---

**** in .dbf
Question 1
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 2
After i can set the order as 'set order to p_code'
How can i coding as 'skip 1', 'skip -1', EOF, BOF

Question 3
How can i coding as 'Flock', 'Rlock', 'Unlock'

Question 4
In my old program, i can to brow a .dbf file (it is oepned at begining program) to get my existing records in it.
Do i need to run the "Select * from Product_file" to get existing records every time. If turn, that will make the system slow ???

****