close all

>hey everyone,
>here's my situation. i have a program that runs on a scheduler. the program runs fine, but i cannot access one of the databases the program inserts into if the program is still on the scheduler. i can acces the database if the program is not still on the scheduler. that is if the scheduler is not running. i am pretty sure the problem is that the database still thinks that it is being held in the work area. my problem is that i open 2 databases in the work area at once. the following code resembles the problem:
>
> Use (example1.dbf) in 0 shared alias a_alias
> Use (example2.dbf) in 0 shared alias a_alias2
>
> select a_alias
> scan
>
> If a_alias->field > 0 .and. not empty(a_alias->field)
>
> Insert into a_alias2 ;
> ( a , ;
> b , ;
> c )
> Values (a_alias->x , ;
> a_alias->y, ;
> a_alias->z)
>
> endif
> endscan
>
>does anyone have any suggestions on how to close both work areas when i am done.
>i have a "use" command at the very end of the program but it doesn't seem to be closing this out. this statement is embedded in a nested if. any suggestions would be appreciated. thanks