Good day
=-00=--0=

Thanks for your feedback.

As far as I know we have successfully in other programs edited the primary keys.
We don't have GetText events. But THANKS for the tip as we might have spend
ours on it in the future if we going to use it.

Othwerise enjoy your day

Yours Sincerely

Johannes Pretorius


At 20:17 23/09/2005, you wrote:

>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]
>
>
>
>
>
>
>___________________________________________________________________________
>IB Objects - direct, complete, custom connectivity to Firebird or InterBase
> without the need for BDE, ODBC or any other layer.
>___________________________________________________________________________
>http://www.ibobjects.com - your IBO community resource for Tech Info papers,
>keyword-searchable FAQ, community code contributions and more !
>Yahoo! Groups Links
>
>
>
>
>
>
>
>
>
>--
>No virus found in this incoming message.
>Checked by AVG Anti-Virus.
>Version: 7.0.344 / Virus Database: 267.11.4/109 - Release Date: 21/09/2005

--
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