>I know. I know. Obsolete 'select' but here they are rearing their messy faces.
>question 1
>Is there a command i can use to find out if a database is open - not necessarily active at the moment of enquiry, but previously open.

?dbused('myDatabase')

>Question 2
>Can i close ONE selected database or is it all or nothing.?
>
>see ?? below.
>
>select 1
>use data1
>select 2
>use data2
>select 3
>use data3
>
>select 1
>?? is data4 already open
>?? if open - close data4
>
>
>thanks for your help
>
use in select('Data4') && closes only data4 table

Database is opened with
OPEN DATABASE myDatabase command

Table is opened with USE command (closed with use as well).
>k