Dataenvironment

[jrajesh]

Hi VFP-gurus,
I have an application which functions as a viewer (only).
The data for this application is imported on a daily basis.

The application checks for available import files in a particular folder, imports and updates various tables.

For importing, I want to open the database and tables in exclusive mode, import, close them and then reopen them in shared mode.

Could someone please guide me as to how to access the DE programmatically to do this?
Thanks and regards,
Rajesh

 

[DSummZZZ]

I'm not sure what you mean by accessing 'the DE programmatically to do this'. All you need to do is add your tables to your database as required, then from a Click event on an 'Import' button you can do something like:

OPEN DATABASE MyDB
IF FILE("ImpFile1&quot &&... add extension as needed
SELECT 0
USE ImpTable1 EXCLUSIVE
APPEND FROM ImpFile1 &&... SDF if needed
USE ImpTable1 SHARED
ENDIF

IF FILE("ImpFile2&quot &&... add extension as needed
SELECT 0
USE ImpTable2 EXCLUSIVE
APPEND FROM ImpFile2 &&... SDF if needed
USE ImpTable2 SHARED
ENDIF

And so on for the rest of the tables.

Dave S.