>I have a form that builds a query that is fed to sqlexec which gets the data from an Oracle table. I am passing a name to sqlexec so that the resulting cursor is named. If I do a browse after the execution of the sqlexec statement I see my data, however if I try to use the cursor as the source for a grid in another form which is fired by doform('mylistfrm') I am told the table does not exist.
>
>Using dbf() and alias() in the debug window of the init event of the new form, shows no tables open???? Does doform close all cursors? I have tried numerous workarounds, selecting from the coursor into a table and then using that in the grid but that also fails.
Your form probably has a Private Datasession, hence, it sees no open tables.
Change it's .DataSessionID to 1 for default.