Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Free tables
Message
From
19/12/2003 13:59:30
 
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
00860746
Message ID:
00860777
Views:
17
>I have a project that needs to integrate with older SBT accounting program that uses 2.X tables. It will be a totally separate program only accessing the data used by SBT. The advise I seek is what technique I should use to access the data for both read/write.
>
>Since VFP3 I try exclusively to use updateable views as data access on all my forms. But since I have to access the SBT data as free tables instead of adding it in the database, I can't create updateable local views (can I?). Thus, in displaying filtered data in something like a grid my only options are to:
>
>1. Use "SET FILTER" which is dog slow.
>2. SELECT-SQL but this creates read-only access.
>
>Any good solution to this problem I'm missing? TIA.

You can create views of free tables, only the views have to be part of a DBC.
Fred
Microsoft Visual FoxPro MVP

foxcentral.net
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform