>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.


if you choose to use sql you can make it read-write with this:

select * from MyTable into cursor Temp_Table
use dbf("Temp_Table") alias cur_Table again in 0
use in Temp_Table
select cur_Table