Subject | Re: [IBO] DSQL changes are not inserted into the DB |
---|---|
Author | Christian Gütter |
Post date | 2003-02-26T11:31:48Z |
Hi Helen and Svein,
I've found the error in my code.
I looked at RowsAffected as suggested by Svein and it
was zero - so I took a closer look at my params.
When assigning the params, I was using:
ParamByName('PP').AsString := QuotedStr(DeletePKs[Ctr]);
Of course, the use of QuotedStr is wrong and resulted in two
quotation marks around the param:
were result of such a dumb mistake.
Thanks for your help!
Christian
I've found the error in my code.
I looked at RowsAffected as suggested by Svein and it
was zero - so I took a closer look at my params.
When assigning the params, I was using:
ParamByName('PP').AsString := QuotedStr(DeletePKs[Ctr]);
Of course, the use of QuotedStr is wrong and resulted in two
quotation marks around the param:
> PARAMS = [ Version 1 SQLd 1 SQLn 1My excuses for wasting your time with questions which
> [PP] = ''POW-00033'' ]
were result of such a dumb mistake.
Thanks for your help!
Christian