At 03:48 AM 21/09/2003 +0000, you wrote:

>Thanks for the help - it sort of works as a select (not a stored
>proc), but has the unfortunate side effect of invoking the generator
>(or the proc - I can't tell which) twice! So every call to the proc
>effectively increments the step by two. Wierd.

Not here it doesn't. And there is nothing in the code that would make that
occur by magic on a different box. How/where are you using it? For
example, are you passing the value to a table with a Before Insert trigger
which invokes the same generator without checking whether NEW.ThatValue is
NULL?

>Also, I can remove the single quotes from the stored proc - no harm no
>foul. But the other quotes were placed there by IBOConsole, not the
>author.

Single quotes? You need those on strings...
What tool did you use to create the database and its
objects? Exactly. Did you configure some other tool into IBOConsole for
building scripts...or did you maybe use a metadata extract utility to get
your schema from another database...?

heLen