Invalid Cursor State By SELECT after INSERT
"John Mazza" <[email protected]>
| Newsgroups | gmane.comp.db.tds.freetds |
|---|---|
| Message-ID | <[email protected]> |
I'm seeing a problem with 0.82 (daily, 2007-07-22) where a SELECT following an INSERT will cause an Invalid Cursor State error to occur. =================== INSERT INTO FaxJob (FaxDeptID, FaxSendToNo, FSID, FaxResultID, FaxSendTries,recip_id,SendImmediate, FaxEmployeeID, FaxCreate) VALUES( -8151396, '4123880569', 5,0,0,0,0,0,'2008-07-22 22:36:24') SELECT FaxJob.FaxJobID FROM FaxJob WHERE FaxJob.FaxDeptID = -8151396 RESULT: [FreeTDS][SQL Server]Invalid cursor state; Record 2: SqlState: 24000; NativeError: 0; Message: [FreeTDS][SQL Server]Invalid cursor state; ==================== Does anyone have any ideas on how to solve this one? Thanks!!!