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