Subject | Updating with rdb$db_key |
---|---|
Author | buppcpp@yahoo.com |
Post date | 2005-07-13T06:04:04Z |
Since the DB_KEY is binary/hex values how do you update a row by using a
literal string?
The following examples don't work:
"UPDATE mytable set qty = 5 where rdb$db_key = '0000022600000001'"
"UPDATE mytable set qty = 5 where rdb$db_key = 0x0000022600000001" (this one
works in SQL Server)
Thanks
Bupp
literal string?
The following examples don't work:
"UPDATE mytable set qty = 5 where rdb$db_key = '0000022600000001'"
"UPDATE mytable set qty = 5 where rdb$db_key = 0x0000022600000001" (this one
works in SQL Server)
Thanks
Bupp