Hi Marc Benedict!

I don't know if I've ever used a UDF (I've certainly never written
anyone), so if I'm right, you've done a very basic mistake:

I don't think parenthesis are optional when using UDFs. Hence, try

SQL> select GUID_OCTETS() from rdb$database;

and

SQL> insert into GUID_TEST (BIN_GUID)
CON> values(GUID_OCTETS());

HTH,
Set

--- In firebird-support@yahoogroups.com, "vogonjeltzprostetnic" wrote:
> Queries don't work, though:
>
> SQL> select GUID_OCTETS from rdb$database;
> Statement failed, SQLCODE = -206
>
> SQL> insert into GUID_TEST (BIN_GUID)
> CON> values(GUID_OCTETS);
> Statement failed, SQLCODE = -206
>
> Although I've been a developer for a number of years now, I'm kind
> of a newbie to Firebird (and it's not as though I've written an
> enormous number of dll's, either). So if I've made a laughable
> blunder (or two), please be gentle. :-)
>
> -Marc Benedict