Subject | Invalid column reference |
---|---|
Author | s.beames@mailbox.gu.edu.au |
Post date | 2001-02-08T20:39:36Z |
G'day,
when I use the nifty new SQL editor to enter a TIB_Query custom
EditSQL statement like:
EXECUTE PROCEDURE CHANGE_CAT2(
:CATEGORY2.OLD_CAT2,
:CATEGORY2.CAT2)
I get an error message of "Invalid custom DML column reference:
CATEGORY2.OLD_CAT2" when executing my app.
If I remove the table name thus:
:CATEGORY2.OLD_CAT2, -----> :OLD_CAT2,
it appears happy.
I've noticed this 'feature' before when following some of the GSG
examples. Am I missing something?
Using BCB5, 3.6.Ce TEST3, Firebird WI-T0.9.4.41, Win98SE
Thank you,
Steve Beames
when I use the nifty new SQL editor to enter a TIB_Query custom
EditSQL statement like:
EXECUTE PROCEDURE CHANGE_CAT2(
:CATEGORY2.OLD_CAT2,
:CATEGORY2.CAT2)
I get an error message of "Invalid custom DML column reference:
CATEGORY2.OLD_CAT2" when executing my app.
If I remove the table name thus:
:CATEGORY2.OLD_CAT2, -----> :OLD_CAT2,
it appears happy.
I've noticed this 'feature' before when following some of the GSG
examples. Am I missing something?
Using BCB5, 3.6.Ce TEST3, Firebird WI-T0.9.4.41, Win98SE
Thank you,
Steve Beames