Tim

Are there any nasty consequences of editing/updating the Information.Function table?

eg If I wanted to add an extra parameter to a function

FUNCTION "TEXTSEARCH" (IN "SearchFor" VARCHAR(512) COLLATE ANSI, IN "SearchIn" CLOB COLLATE ANSI)
RETURNS BOOLEAN
EXTERNAL NAME "nlhEDBFuncs"

becoming

FUNCTION "TEXTSEARCH" (IN "SearchFor" VARCHAR(512) COLLATE ANSI, IN "SearchIn" CLOB COLLATE ANSI, IN "MatchCase" BOOLEAN)
RETURNS BOOLEAN
EXTERNAL NAME "nlhEDBFuncs"

can I just edit the definition (and FunctionParams - not bothered about FunctionPriviledges - they're fine) or do I have to drop and redo it?

Roy Lambert

PS When time permits it would be nice to diagram the tables / relationships in the Information database an annotate what we are and aren't allowed to do things with.

Roy,

<< Are there any nasty consequences of editing/updating the
Information.Function table? >>

You can't update any of the Information schema or Configuration database
tables.  They are all read-only.  You have to use DDL statements to affect
these tables.

<< PS When time permits it would be nice to diagram the tables /
relationships in the Information database an annotate what we are and aren't
allowed to do things with. >>

There's a whole section of the manual already dedicated to that:

http://www.elevatesoft.com/edb1sql_system_information.htm

Each table has a listing of the DDL statements that affect their contents.

--
Tim Young
Elevate Software
www.elevatesoft.com