Sounds like it is possibly a problem with your join statement and your getting a cartesian join.
-myron kirby-
myronk@flash.net
---------------------------------------------------------------
>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.