I'm using Progress ODBC DataServer (v9.1D) with QODBC 7.00.00.207, with Quickbooks Enterprise 7 trial version.
When I iterate on the TRANSACTION table and lookup related ENTITY, there are some records in the sample database which have non-null transaction.EntityRefListID fields but no related ENTITY records. The read fails. Control flow should return to the program (with an error condition) so that I can handle it programmatically. I might want to create the missing record if not found.
However, when this happens, Progress stops as if a fatal error had occurred.
I experience the same problem whether I use Progress ABL code or SQL.
Any ideas? I noticed "continueonerror" in some of the traces I looked at. That's exactly what I want the driver and program to do!
Code is inserted below (Progress ABL/4GL which DataServer translates into SQL to pass to the driver)
TIA for any insight you might be able to provide.
Chris
=====================================
FOR EACH {&QB}.TRANSACTION_:
DISPLAY {&QB}.TRANSACTION_ EXCEPT memo
WITH 1 COLUMN
FRAME f-5A DOWN STREAM-IO WIDTH 500.
if {&QB}.transaction_.EntityRefListID <> ? THEN DO:
/* FOR FIRST */ FIND {&QB}.Entity
WHERE entity.listid = TRANSACTION_.EntityRefListId NO-LOCK NO-ERROR.
IF AVAIL ENTITY THEN DISPLAY entity
WITH 1 COLUMN FRAME f-5B STREAM-IO WIDTH 500.
/* END. /* for first */ */
END. /* if */
END.
| 
