Subject | Re: [IBO] Error updating TIBOTable |
---|---|
Author | Helen Borrie |
Post date | 2001-04-13T13:36Z |
At 01:17 PM 13-04-01 +0000, you wrote:
UPDATE ATable set AField = whatever
WHERE {KeyLinks Field} = :{value of current keylinks}
The likely cause for this error is that you have no KeyLinks defined. Rejection is occurring in the WHERE clause because an empty string is being passed in lieu of a KeyLinks column name.
Is this the case?
Regards,
Helen
InterBase Developer Initiative ยท http://www.interbase2000.org
_______________________________________________________
>Hi,Actually, with TIBOTable, you do use SQL. The TIB_Statement underlying the dataset is SELECT * FROM ATable. The automatically created update statement would be
>I got a TIBOTable defined in a datamodule.
>The datamodule is called U_DM
>The table is called T_Art
>In another module I have the following statements
>
>In Formcreate
> DM.T_Art.Close;
> DM.T_Art.Open;
>
>In Formactivate
> DM.T_Art.Edit;
> DM.T_ArtMENU.AsInteger := 120;
> DM.T_Art.Post;
>
>The database is fine, I put some breakpoints in the program and
>everything is fine up to the Post statement, I checked and he got the
>correct record, so the reading partion is fine.
>I got a error when executing the Post statement.
>The error is :
>
>raised exception class EIBO_ISCError with message
>'ISC ERROR CODE : 335544569'
>Dynamic SQL Error
>SQL error code = -104
>Token unknown line 6 char 5
>TIB_Statement '"'
>TIBOInternalDataset "T_Art.IBOqrT_Art"
>
>So I got a SQL error, but this is a TIBOTable, so I do not use SQL.
>What can be wrong, and how do I fix this ?
UPDATE ATable set AField = whatever
WHERE {KeyLinks Field} = :{value of current keylinks}
The likely cause for this error is that you have no KeyLinks defined. Rejection is occurring in the WHERE clause because an empty string is being passed in lieu of a KeyLinks column name.
Is this the case?
Regards,
Helen
>LeeAll for Open and Open for All
>
>
>
>
>
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
InterBase Developer Initiative ยท http://www.interbase2000.org
_______________________________________________________