Vb(foxpro)

[qassim]

Hello,
i am using dao and connected with foxpro2.6
i have indexed in foxpro but how to do index on
vb because the form is showing record scatter
can any one tell me to do the index or sort
with vb(foxpro)
thank you

[Clunietp]

if you want the records to be in some sort of order, you'll have to specify the record order in your SQL statement or use the SORT function (I'm not sure if a DAO recordset has a sort function.....)

[Glen_Kruse]

After you set the db, use the index property:

Set rs = db.OpenRecordset("tblMaster", dbOpenTable)
rs.Index = "PrimaryKey"

Note:
You must open as a table (not a recordset) to use Index.
Replace "PrimaryKey" with your index name from FoxPro.