For Wizard2 - Need clarification re: SQLExec(), etc.
Posted on 1998-07-23
I apologize, as re-reading my question and your answer leads me to believe I didn't phrase the question right. I appear to be able to successfully connect to the database, and have set up the SQLCmd() and SQLExec appropriately. I just can't figure out how to deal with the query results.
Previously, I'd been able to route all the results of the query into the new recordset by setting the database and then using that database as part of the definition for the new recordset. (' Set db = (....)', and then 'Set gSrchSet = db.OpenRecordset(....)')
How do I do that now? In all the examples in the books, it seems to only reference 'results%' which is an integer, not a database or a recordset. (Plus they don't seem to ever show examples of what to do with any data that's returned, but that's another story!) Is it that I can no longer 'set' the database? If I can't do that, how do I define the recordset to hold the results of the query?
I'm just really stuck. I do appreciate your original answer, and I'm hoping you understand why I'm still stuck. Sorry if this isn't the right way to contact you, but I didn't see anywhere in the grading sheet where I could reply to the expert.