Good day ALL
-0-=-0=0-=-0=

Firstly I want to thanks EVERY Body for there help.

I just want to give some info back on the problem we had.

I have traced the problem
down to the function in IB_Components.pas

TIB_UpdateSQL.PrepareCustomDM

And here I noticed how the Parameters is used with the OLD_ prefix.
The problem was we ALSO had a OLD_CODE in our DATABASE. Thus the Parameters
conflicted.

LUCKY IBObecjts ALSO componsates for OLD. (fullstop)
And by changing the Update to be the following EVERTHING worked as normal again.

//============ NEW UPDATE STATEMENT =============
UPDATE MEDICAL_AID SET
CODE = :CODE, /*PK*/
RATE_CODE = :RATE_CODE, /*PK*/
CPT4 = :CPT4,
NAME = :NAME,
PERCENTAGE = :PERCENTAGE,
PATIENT_PERCENTAGE = :PATIENT_PERCENTAGE,
REFERENCE_VALIDATION = :REFERENCE_VALIDATION,
REFERENCE = :REFERENCE,
EMPLOYER = :EMPLOYER,
MESSAGE_NUMBER = :MESSAGE_NUMBER,
DATE_ENTERED = :DATE_ENTERED,
MASK = :MASK,
OLD_CODE = :OLD_CODE,
ELIG_ENABLED = :ELIG_ENABLED,
CLAIMS_ENABLED = :CLAIMS_ENABLED,
EDI_TEMPLATE = :EDI_TEMPLATE,
CLAIMBEFOREEXPORT = :CLAIMBEFOREEXPORT,
CLAIMS_ADDR = :CLAIMS_ADDR,
ELIG_ADDR = :ELIG_ADDR,
CLAIM_PART_ADDR = :CLAIM_PART_ADDR,
ADMINISTRATOR_NAME = :ADMINISTRATOR_NAME,
NOTE = :NOTE,
ENABLED = :ENABLED,
VERSTEK = :VERSTEK,
BTW_NOMMER = :BTW_NOMMER
WHERE
CODE = :OLD.CODE AND
RATE_CODE = :OLD.RATE_CODE
///================= END ===================

I hope this will help somebody else in the future.

Have a great day

Johannes Pretorius


----------



No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.344 / Virus Database: 267.11.4/109 - Release Date: 21/09/2005


[Non-text portions of this message have been removed]