Hello

I get error "#700 generated column expression The function ... does not exist",
when executing the script.

I have a function defined, which is used by a generated column.
I think the procedure and function definitions should be at first in the generated script.

Thanks
Matthias

> I have a function defined, which is used by a generated column.
> I think the procedure and function definitions should be at first in the
> generated script.

But what if a procedure or function refers to a table that is not yet
created?  And procedures can call other procedures, so you have to order
them correctly.

It's best to use the Reverse Engineer features as a starting point and
customize your own script from there.  That's what I had to do.

In your case, you might have to move the definition for that one function up
above the table creation statements, or leave that part out of the table and
do an ALTER TABLE later to add the generated column in.

--
David Cornelius
Cornelius Concepts

"David Cornelius" wrote:


> But what if a procedure or function refers to a table that is not yet
> created?  And procedures can call other procedures, so you have to order
> them correctly.

Yes thats indeed a point!

Thanks
Matthias

Matthias,

<< I get error "#700 generated column expression The function ... does not
exist", when executing the script. >>

This is something that will be addressed soon (2.04), but for now you have
to manually edit the generated script so that the function is created first.

--
Tim Young
Elevate Software
www.elevatesoft.com