--- Ivan Prenosil <Ivan.Prenosil@...> wrote:

> If you do not mind using UDFs, then just write one
> function
> to generate GUID in binary form, another to convert
> it
> to some nicer, binary-zero-free, printable format.
> Do you need anything else ?

Actually, this is probably the best suggestion anyone
has made so far. I guess UDFs would work nicely
because:
* I can generate the GUID in Delphi code.
* I can store the UDF in a key field in 16 bytes.
Only drawbacks:
* I'll just have to use the UDF in all the queries I
write, but this isn't too bad because I can still use
the full GUID - even when use SQL at the command
prompt.
* Performance of the UDF may slow down inserts and
updates a bit?

Of course, the icing on the cake would be direct,
native GUID type support in Firebird. :-) I was
really hoping someone would say that this is planned
for a future release of Firebid!

Cheers,
Kevin.




__________________________________
Do you Yahoo!?
Yahoo! Small Business - Try our new resources site!
http://smallbusiness.yahoo.com/resources/