Subject RE: [firebird-support] Re: Updating with rdb$db_key
Author Louis Werth
Dear Bupp

--Bupp Said:
--Gee, you guys make a mountain out of a mole hill about everything.
--Stop reading so much into every post and just answer the question if you
--know the answer.

I suggest you have a drastic attitude change and maybe people will be more
helpful towards you. Please remember that this is a free service and being
demanding in the way you are, won't help.

I am of the opinion that the responses you received is very relevant. The
people suggests that you should not use the rdb$db_key in the manner you
want to use it. So rather than expecting the world to change to fit in with
your ideas, maybe change your way so that it fits in with the awesome free
functionality you use.

Regards
Louis


-----Original Message-----
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of buppcpp@...
Sent: 13 July 2005 01:13 PM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Re: Updating with rdb$db_key

> I mean that tables without primary keys must die! It is well known
> mantra in RU.DELPHI.DB: "table must have a primary key".

What are you talking about??
My tables have primary keys. Using RDB$DB_KEY is suppose to be the fast way
to update a row, so that what I trying to do.

Where did you hear me say that I had no primary keys?


> >You can't format it as hex or a char representation?
>
> You can format DB_KEY as whatever you wish. You can't do reverse
> conversion: interprete anything as RDB$DB_KEY. BTW, do you know that
> size of RDB$DB_KEY is not fixed?
> --
Yes, of course I know that. And that it has a size of 8 bytes and it's 8
bytes * number of tables for views.
I know all of that, I just had a simple question of how to format the value
into a literal string, so that I can update my records.

Gee, you guys make a mountain out of a mole hill about everything.
Stop reading so much into every post and just answer the question if you
know the answer.

Thanks for your answer...

Bupp



++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://firebird.sourceforge.net and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !

Also search the knowledgebases at http://www.ibphoenix.com

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Yahoo! Groups Links