I'm getting some strange results working with a REALSQLdatabase, and I wonder if I'm doing something wrong.
This is happening in a set of report generating classes and windows in an application I'm developing. I query the database to get a recordset for a default report and then display the results in a report window. If a user modifies the columns to show in the report, I go back to the same class that created the original query and rewrite the query (e.g. add a column selector to the SELECT statement). In my tests the first query works fine, but when I try to query the database a second time with a modified SELECT statement I get back a recordset with 0 records. If I use the same modified query in a database tester on the same database file, I get the results I expect. Do I need to do something in between the two queries to make this work correctly? _______________________________________________ Unsubscribe or switch delivery mode: <http://www.realsoftware.com/support/listmanager/> Search the archives: <http://support.realsoftware.com/listarchives/lists.html>
