Good day All
-=00-=-0=-0=

WE are havbing a problem where we use IBOQuery where Cached Updates are ON.
We use a normal TDataSet and a Normal TDBGrid and normal
TDBEdit .

Delphi version : 3
(We want to convert all db access to IBO before converting over to D5 or D2005)

The Interbase version is 5.6

The funny part is that when the error pops up (Record was not located to update)
the DBGrid that we have in the background has MULTIPLES of only ONE entry over and over again.
When we click okay the Grid displays normal again.

We have narrowed the problem down to the procedure in IBODataset

procedure TIBOUpdateSQL.ExecSQL

The following information is for the Query Component that we use to update and display on grid.

//============ QUERY ==================
SELECT
CODE
, NAME
, RATE_CODE
, ADMINISTRATOR_NAME
, CPT4
, PERCENTAGE
, PATIENT_PERCENTAGE
, REFERENCE_VALIDATION
, REFERENCE
, EMPLOYER
, MESSAGE_NUMBER
, DATE_ENTERED
, MASK
, OLD_CODE
, ELIG_ENABLED
, CLAIMS_ENABLED
, EDI_TEMPLATE
, CLAIMBEFOREEXPORT
, CLAIMS_ADDR
, ELIG_ADDR
, CLAIM_PART_ADDR
, NOTE
, ENABLED
, VERSTEK
, BTW_NOMMER
FROM MEDICAL_AID

//================ END QUERY ==================\
//================= UPDATE ==================
UPDATE MEDICAL_AID SET
CODE = :CODE, /*PK*/
RATE_CODE = :RATE_CODE, /*PK*/
NAME = :NAME,
ADMINISTRATOR_NAME = :ADMINISTRATOR_NAME,
CPT4 = :CPT4,
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,
NOTE = :NOTE,
ENABLED = :ENABLED,
VERSTEK = :VERSTEK,
BTW_NOMMER = :BTW_NOMMER
WHERE
CODE = :OLD_CODE AND
RATE_CODE = :OLD_RATE_CODE

//============== END UPDATE==================

Any help will be appreciated.

Thanks in Advance


Johannes Pretorius
(Programeerings Departement- Promed)

Tel : +27 11 607-3300
Faks : +27 11 622-6939
webtuiste : http://www.promed.co.za

This email and any files transmitted with it are confidential and intended
solely for the use of the individual or entity to whom they are addressed.
If you are not the intended recipient, any review, re transmission,
disclosure, copying, modification or other use of this email message or
attachments is strictly forbidden. If you receive this email message in
error, please contact the author and delete the message and any
associated files from your computer. Also the contents of this e-mail
is considered confidential.
Thank you

----------



No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.344 / Virus Database: 267.11.3/107 - Release Date: 20/09/2005


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