Hi all, please tell me how to convert Varchar to double, Ex: I have a
variable X = THDH4545 --> 4545 in double.

Thanks



_____

From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Alan McDonald
Sent: Thursday, October 18, 2007 04:39
To: firebird-support@yahoogroups.com
Subject: RE: [firebird-support] GUID as PK

> I think I read somewhere that long strings such as GUIDs for PK's in
> Firebird were problematic. Is there any truth to this?
>
> Thanks,
>
> --
> Warm Regards,
>
> Lee

not probmelatic but to some degree, annoyance.
there's a UDF which generates UUID - better than GUID for FB indexing, so
use it and not GUID generation.
other annoyances,
more disk space (it's cheap)
impossible to humanly determine record creation sequence without additonaly
timestamp (more disk splace - it's cheap)
there are other ways to guarantee unique keys but using BIGINT instead.
more load on transport protocol when transferring data OTW
there may be others
Alan





[Non-text portions of this message have been removed]