| Subject | Re: [IBO] Problem with TClientDataSet and TIBOQuery |
|---|---|
| Author | Paulo Henrique Albanez |
| Post date | 2002-01-08T17:33:06Z |
Yes. This mistake occurs with TClientDataSet only, IBO is not using the correct value of the argument.
That it can be observed in SQL's Text monitor.
When it changes the value of the primary key IBO does not update the record.
Example:
I modify the field CODCLI from 10 to 1 and apply to update.
SQL's Text Monitor:
/*---
[ 08/01/2002 10:03:07 ]
PREPARE STATEMENT
TR_HANDLE = 14893916
STMT_HANDLE = 14893988
UPDATE CADCLI
SET CODEMP = ? /* CODEMP */
, CODCLI = ? /* CODCLI */
, NOMCLI = ? /* NOMCLI */
, DATA = ? /* DATA */
, CODGRU = ? /* CODGRU */
WHERE CADCLI.CODCLI = ? /* OLD.CODCLI */
AND CADCLI.CODEMP = ? /* OLD.CODEMP */
PLAN (CADCLI INDEX (RDB$PRIMARY29))
/*---
[ 08/01/2002 10:03:10 ]
EXECUTE STATEMENT
TR_HANDLE = 14893916
STMT_HANDLE = 14893988
PARAMS = [ Version 1 SQLd 7 SQLn 7
[CODEMP] = 4
[CODCLI] = 1
[NOMCLI] = 'Teste'
[DATA] = <NULL>
[CODGRU] = <NULL>
OLD.[CODCLI] = 1 =====> It should be 10 and not 1, OldValue is 10.
OLD.[CODEMP] = 4 ]
----*/
/*---
IBO 4.2.Fn
Delphi 6
Windows 2000 Professional
FireBird Beta2
PHA
Nova Odessa / SP - Brazil
That it can be observed in SQL's Text monitor.
When it changes the value of the primary key IBO does not update the record.
Example:
I modify the field CODCLI from 10 to 1 and apply to update.
SQL's Text Monitor:
/*---
[ 08/01/2002 10:03:07 ]
PREPARE STATEMENT
TR_HANDLE = 14893916
STMT_HANDLE = 14893988
UPDATE CADCLI
SET CODEMP = ? /* CODEMP */
, CODCLI = ? /* CODCLI */
, NOMCLI = ? /* NOMCLI */
, DATA = ? /* DATA */
, CODGRU = ? /* CODGRU */
WHERE CADCLI.CODCLI = ? /* OLD.CODCLI */
AND CADCLI.CODEMP = ? /* OLD.CODEMP */
PLAN (CADCLI INDEX (RDB$PRIMARY29))
/*---
[ 08/01/2002 10:03:10 ]
EXECUTE STATEMENT
TR_HANDLE = 14893916
STMT_HANDLE = 14893988
PARAMS = [ Version 1 SQLd 7 SQLn 7
[CODEMP] = 4
[CODCLI] = 1
[NOMCLI] = 'Teste'
[DATA] = <NULL>
[CODGRU] = <NULL>
OLD.[CODCLI] = 1 =====> It should be 10 and not 1, OldValue is 10.
OLD.[CODEMP] = 4 ]
----*/
/*---
IBO 4.2.Fn
Delphi 6
Windows 2000 Professional
FireBird Beta2
PHA
Nova Odessa / SP - Brazil
----- Original Message -----
From: "Helen Borrie (TeamIBO)" <helebor@...>
To: <IBObjects@yahoogroups.com>
Sent: Tuesday, January 08, 2002 11:53 AM
Subject: Re: [IBO] Problem with TClientDataSet and TIBOQuery
> At 10:10 AM 08-01-02 -0300, you wrote:
> >When it changes the value of the primary key IBO does not update the record.
>
> Do you have the KeyLinks correctly set? This will be essential if you are changing the value of the primary key.
>
>
> regards,
> Helen Borrie (TeamIBO Support)
>
> ** Please don't email your support questions privately **
> Ask on the list and everyone benefits
> Don't forget the IB Objects online FAQ - link from any page at www.ibobjects.com
>
>
>
> ___________________________________________________________________________
> 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 !
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>
>
[Non-text portions of this message have been removed]