>I have a form with 2 tables (one remote view and one table, both in the database and data environment), 2 pages on a pageform, a grid on each page (one for each table). With AutoOpenTables .t., I find that the view and the table are opened and another instance of the table (alias "C") which is being accessed when I select the second grid.
>If I turn off AutoOpenTables and use the tables in the form init method, the second grid accesses the table properly without the extra instance. ????? Any ideas why this extra instane appears?
>
>Also, I want to copy records that the user selects from the remote view to the table. I am doing:
>get criteria for selected records
>select table
>append from dbf('view') for criteria
>
>Is there a more direct method? I am used to using
but this isn't supported in FP.
Wouldn't it be nice if more standard SQL were supported in VFP? What I sometimes do is:
Select * from Table1 where some_criteria into array aTemp
Insert into Table2 from array aTemp
As for the second instance of the table, is it possible you may have used a grid builder and now have a 2nd instance of the table in the DE? This happens to me frequently. Also, if you are not using a private DataSession, you are opening tables/views in a default DS where other tables may already be open.
Mark McCasland
Midlothian, TX USA