RE: How do I add an index to a FoxPro table
From: Colin McLelland (colinj_mc_at_hotmail.com)
Date: 03/29/04
- Next message: nupur_at_asterx.com: "Populate a datagrid in vb6 with values from a .dbf file"
- Previous message: Dave: "How do I add an index to a FoxPro table"
- In reply to: Dave: "How do I add an index to a FoxPro table"
- Next in thread: Dave: "RE: How do I add an index to a FoxPro table"
- Reply: Dave: "RE: How do I add an index to a FoxPro table"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 29 Mar 2004 15:21:08 -0800
Hi Dave,
if it is just for the duration of the program execution I have found the following works for dbf files...
Dim f_rsIdx As ADODB.Field
rs.CursorLocation = adUseClient ' without double checking I think this is vital
'
' Open database here
'
'Create the recordset
rs.Open ......
'Index on field called Author
Set f_rsIdx = rs.Fields("Author")
f_rsIdx.Properties("Optimize") = True
Hope this does the trick for you.
Colin
- Next message: nupur_at_asterx.com: "Populate a datagrid in vb6 with values from a .dbf file"
- Previous message: Dave: "How do I add an index to a FoxPro table"
- In reply to: Dave: "How do I add an index to a FoxPro table"
- Next in thread: Dave: "RE: How do I add an index to a FoxPro table"
- Reply: Dave: "RE: How do I add an index to a FoxPro table"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
|
