>Does anyone know a way so that after a SQL statment the tables involved are closed without further coding?

No.


>My problem is that after a SELECT-SQL the tables remain opened and have problems with some other forms which use the same tables in my application.

Look at AUSED() to find out open tables.

Call it before the SQL select, and again afterwards.

Compare the two arrays and anything that's open after and not before (that isn't the results you needed!) you can delete.