Adding Records
I have a question regarding CRecordsets. Here's the situation:
1) If I have an empty table, I can insert as many records as I want w/o a
problem.
2) If the table is not empty, trying to add a record with the same routine
fails. The failure is caused by an active hStmt.
From what I can gather, when I call Open() on the record set, I am essentially
doing a SELECT * w/ no criteria. If there are records present, I am actually
processing a query. This seems very awkward. What if my table is large? Then if
I simply want to do an update, I'm processing the million or so records in the
table?!?
We solved the problem by creating a nogus filter before opening the record set.
If there a way to open the table w/o actually firing a query to the server?
BTW: We are using SQL Server as the implementation database.
Thanks,
Alex Harvey
Crowe Chizek