Subject | Newbie on RDB$DB_KEY |
---|---|
Author | desmondtay88 |
Post date | 2003-04-29T13:08:25Z |
Hi,
I need some help on using RDB$DB_KEY to update specific records in
the db. I'm using Perl and I need to retrieve a set of records,
which after the perl code does some computation will update back to
the same records identified by RDB$DB_KEY.
There seems to be alittle problem here, cause the RDB$DB_KEY column I
understand is a 8 byte data type. In this case, I'm not quite sure
how I can specify the RDB$DB_KEY value in the update statement if it
is a raw byte value. I've read some good examples from Claudio on
RDB$DB_KEY. Unfortunantely, all examples shown assigns the selected
RDB$DB_KEY value in a variable and access them within the same
procedure call. When I extend the logic to the perl codes, I keep
getting the invalid token error from the sql parser.
Any help is much appreciated.
Rgds,
Desmond
I need some help on using RDB$DB_KEY to update specific records in
the db. I'm using Perl and I need to retrieve a set of records,
which after the perl code does some computation will update back to
the same records identified by RDB$DB_KEY.
There seems to be alittle problem here, cause the RDB$DB_KEY column I
understand is a 8 byte data type. In this case, I'm not quite sure
how I can specify the RDB$DB_KEY value in the update statement if it
is a raw byte value. I've read some good examples from Claudio on
RDB$DB_KEY. Unfortunantely, all examples shown assigns the selected
RDB$DB_KEY value in a variable and access them within the same
procedure call. When I extend the logic to the perl codes, I keep
getting the invalid token error from the sql parser.
Any help is much appreciated.
Rgds,
Desmond