I only use the native stuff and no cached updates. But I had the same
problem when one of the key fields was "translated" with GetText
events. If you have an GetText event (for one of the PK columns)
installed it will translate the "code" to user visible text (if thats
what it's for in the first place) even "inside" IBO. But, if you edit
the the PK fields as-is this is not the source of your problem.

/Dany

--- In IBObjects@yahoogroups.com, Johannes Pretorius <johannes@p...>
wrote:

> Sorry for asking this again, but can somebody please see if than

give us any ideas on how to fix this

>
> Thanks
>
> 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 .
>
> IBObjects 4.5 Ai
>
> 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
>
> Ekstra information regarding this.
>
> KeyLinks :
>
> MEDICAL_AID.CODE
> MEDICAL_AID.RATE_CODE
>
> Scenario
>
> WE Edit a Record. Do a post and then a Database.ApplyUpdates([Query]);
>
> 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.5/110 - Release Date:

22/09/2005

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