Client software vs cursor problem?
От | Richard Huxton |
---|---|
Тема | Client software vs cursor problem? |
Дата | |
Msg-id | 200306251140.06270.dev@archonet.com обсуждение исходный текст |
Список | pgsql-odbc |
I've got a client trying to access PG through ODBC from something called ENVOX (a telecomms IVR system). It lets you build control scripts visually by dragging/dropping boxes and setting some params. Now, if he uses a SELECT box to open a (static) cursor then an INSERT box to add a record it fails, but *only* if the select returns no records. If the INSERT box is replaced by a "RAWSQL" box he can successfully build his own insert statement and run it. He's happy enough with this workaround, but it'd be good if we can figure out what's happening. The error he gets is "row value out of range" which appears to be HY107 from googling. This suggests to me the INSERT box is trying to move to the first/last row or similar and failing because there are no rows. Unfortunately I'm no ODBC expert and can't see what code underlies the box. Two questions: 1. Does it sound like I'm on the right track? 2. Would getting him to turn on odbc-logging at his end help me to diagnose? (he's remote from me). Oh - we've tried variations on the cursor type and cursor-concurrency settings and they seem to make no difference. TIA -- Richard Huxton
В списке pgsql-odbc по дате отправления: