Hi Nadya

Are you using multiple databases?

CLOSE TABLES ALL closes tables without closing the database.

SET DATA TO de-SELECTS the current database. It does not close it.

Maybe if you could explain why you need to close the database I could try to give you another way around.

Oscar


>Hi Oscar,
>
> I a little misunderstand you. Do you mean that the database remains open, as I noticed? Where (in which method, I mean) I need to put CLOSE DATA [ALL]? I've tried in DE.Destroy() but nothing happens. May be I need to put it in my form methods. I just ask - where?
>
> Thanks,
> Nadya
>
>
>>>> I have another simple question. If we have tables in form DE which are in DBC container does it mean that after form closes this DataBase remains open? It seems to me like this... Do I need to provide an additional code to close it, where?
>>>>
>>>> Thanks in advance
>>>>
>>
>>Interested on new technologies for database development. Specially Visual FoxPro.
>>Closing the tables dose not mean that you are closing the database. You can switch to another datbase without closing the previous one (SET DATA TO). So, if you want to explicitly close CLOSE DATA [ALL] any time is useful for you.
>>
>>Regards
>>
>>Oscar Corte