>I wrote a program which uses many SQL statements to gather multiple tables into one cursor structure I need to generate a report. I close the previously used cursor before I begin my new SQL statement, so I have at the most 2 cursors open at one time. When I run the programs from the command window, it runs fine. When I add the code to a procedure and initiate it from a form, I get an error There is not enough memory to complete this operation on a SQL which uses the LEFT OUTER JOIN to join two cursors. Can anyone tell me why this is happening.
If you post the SQL statement, we could tell you more, but my initial diagnosis agrees with Myron, Cartesian Join.
Erik Moore
Clientelligence