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.