Dear Jason,

 

we finally upgrade from IBO 4.8 to IBO 5.9.9 in an two day coding session. At the tests bevor I get sometimes conversion errors from firebird which I can't explain. The only soluition I found was to set an explicit Update-Statement for the "Select x from Foo for Update".

 

Today I search again on another part of the project with a same problem and I was shocked to see this:

 

extract from the automatic created UpdateSQL:

    , D_PAT_PATIENT.D_PAT_RCFG_DIAGNOSE_SICHER_KZ = ?/* NEW.D_PAT_PATIENT.D_PAT_RCFG_DIAGNOSE_SICHER_KZ */

    , D_PAT_PATIENT.D_PAT_RCFG_DIAGNOSE_KLARTEXT_KZ = ?/* NEW.D_PAT_PATIENT.D_PAT_RCFG_DIAGNOSE_KLARTEXT_KZ */

    , D_PAT_PATIENT.D_PAT_RCFG_BETRIFFT_TYP = ?/* NEW.D_PAT_PATIENT.D_PAT_RCFG_BETRIFFT_TYP */

    , D_PAT_PATIENT.D_PAT_RCFG_STEUER_NR_KZ = ?/* NEW.D_PAT_PATIENT.D_PAT_RCFG_STEUER_NR_KZ */

    , D_PAT_PATIENT.D_PAT_RCFG_SONST_ADR_ID = ?/* NEW.D_PAT_PATIENT.D_PAT_RCFG_SONST_ADR_ID */

    , D_PAT_PATIENT.D_PAT_RCFG_ZWEITES_KONTO_KZ = ?/* NEW.D_PAT_PATIENT.D_PAT_RCFG_ZWEITES_KONTO_KZ */

    , D_PAT_PATIENT.D_PAT_RCFG_SONST_ANSP_ID = ?/* NEW.D_PAT_PATIENT.D_PAT_RCFG_SONST_ANSP_ID */

    , D_PAT_PATIENT.D_PAT_RCFG_BG_B = ?/* NEW.D_PAT_PATIENT.D_PAT_RCFG_BG_B */

 

and here the extract from parameters:

  D_PAT_PATIENT.D_PAT_RCFG_DIAGNOSE_SICHER_KZ = <NULL>    < TEXT SubType: 1557 Len: 1 Scale: 0 Data Offset: 3324 >

  D_PAT_PATIENT.D_PAT_RCFG_DIAGNOSE_KLARTEXT_KZ = <NULL>    < TEXT SubType: 1557 Len: 1 Scale: 0 Data Offset: 3327 >

  D_PAT_PATIENT.D_PAT_RCFG_STEUER_NR_KZ = <NULL>    < TEXT SubType: 1557 Len: 1 Scale: 0 Data Offset: 3330 >

  D_PAT_PATIENT.D_PAT_RCFG_ZWEITES_KONTO_KZ = <NULL>    < TEXT SubType: 1557 Len: 1 Scale: 0 Data Offset: 3333 >

  D_PAT_PATIENT.D_PAT_RCFG_SONST_ADR_ID = <NULL>    < LONG SubType: 0 Len: 4 Scale: 0 Data Offset: 3336 >

  D_PAT_PATIENT.D_PAT_RCFG_BETRIFFT_TYP = 1    < LONG SubType: 0 Len: 4 Scale: 0 Data Offset: 3342 >

  D_PAT_PATIENT.D_PAT_RCFG_SONST_ANSP_ID = <NULL>    < LONG SubType: 0 Len: 4 Scale: 0 Data Offset: 3348 >

  D_PAT_PATIENT.D_PAT_RCFG_BG_B = <NULL>    < TEXT SubType: 1557 Len: 1 Scale: 0 Data Offset: 3354 >

 

 

the bold fields are mixed - they are not in the same order. Have you any idea how this can happen? Can we force IBObjects to use DML SQLs with named parameters?

 

Freundliche Grüße

 

Wolfgang Lemmermeyer

--------------------------------------------

Psyprax GmbH

80687 München, Landsberger Str. 308, Germany

Fon: +49 89 546800 0 - Fax: +49 89 546800 29

Email: lemmermeyer@...

Web: www.psyprax.de

Geschäftsführung:

Thomas Flohrschütz, Dorothea Bergmann

HRB 155217, Amtsgericht München

UID: DE 240 463020

 

--------------------------------------------

 

Gemäß Artikel 13 und 14 EU DSGVO sind wir verpflichtet Ihnen mitzuteilen, wie wir Ihre personenbezogenen Daten verarbeiten.

Alle Informationen zu den einzelnen Verfahren können Sie über unsere Homepage einsehen, dazu rufen Sie bitte nachfolgenden Link auf: https://www.psyprax.de/datenschutz/