>Working on app in vfp8 that needs to open 6-10 sql tables at start of app and keep open for use in multiple screens and programs.
>What is best to use for this?
>Thanks Doug.
Depends. Are these lookup [static] tables? Will users be adding, editing and/or deleting data? How many records are in these tables? Do your users really need to bring in ALL the records for all the tables when the app starts? etc., etc....
Mark McCasland
Midlothian, TX USA