>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               && Do I need this here?
>

>
>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).