I've made it a habit to never have a SQL statement open the tables. I always explicitly do it. To fix the problem, put the following line of code anyplace after the SELECT statement.

USE IN rtadrawdowns

>The following code is contained in a CON dll which is accessed via a web page.
>
>

>function  GetLastDrawdown(lcRTA_id)
>select * ,;
>	dtoc(fromdate) as fdate, ;
>	dtoc(todate) as tdate ;
>	from rta!rtadrawdowns ;
>	where rta_id == lcRTA_id ;
>	order by subdate ;
>	into cursor crsDrawdown
>go bott
>scatter name loDrawdown memo
>use in crsDrawdown
>return loDrawdown
>endfunc
>

>
>It seems that after the function is accessed, the rtadrawdowns table remains open even though the code closes the cursor. Perhaps this is because the object retains a reference to it??
>
>It seems to still be open because subsequent attempts to modi stru of the table meet with a file access denied error. How can I insure the table is closed so I can modify it?