>Hi Sir,
>
>I normally have the CLOSE DATABASES ALL in the last part of my program after SQLDISCONNECT. Do I need to include CLOSE TABLES ALL as well?
>
>
>SQLDISCONNECT(lnConnHandle)
>CLOSE DATABASES ALL
>CLOSE TABLES ALL
>
>
>Thanks,
>Sam
No, CLOSE DATABASES ALL closes everything (except for currently selected databases in other data sessions or databases and their tables that are open in other data sessions).
Edward Pikman
Independent Consultant