Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Grids and Filters
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 8.1
Network:
Windows 2008 Server
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01625342
Message ID:
01625392
Views:
59
>Any help would be greatly appreciated.
>
>Brad

Set Key will be instantaneous compared to set filter

If your filter doesn't work with set key, then an updateable cursor adapter will be your friend

Query your data into a cursor first, then do something like

LOCAL lo as CursorAdapter
lo.AllowUpdate=.T.
lo.BufferModeOverride=3
lo.DataSourceType="NATIVE"
lo.KeyFieldList="tablepk"
lo.Tables="yourtable"
lo.UpdatableFieldList="comma_delimited_fieldlist"
lo.UpdateNameList="look this one up"
lo.WhereType= 3
lo.CursorAttach(lcCursor,.T.)
Brandon Harker
Sebae Data Solutions
Previous
Reply
Map
View

Click here to load this message in the networking platform