Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 1 to 4 of 4 total |
Reverse-Engeneer Database fails |
Sat, Apr 10 2010 3:26 PM | Permanent Link |
MatthiasThaler | 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 |
Sat, Apr 10 2010 11:16 PM | Permanent Link |
David Cornelius Cornelius Concepts | > 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 |
Sun, Apr 11 2010 6:03 AM | Permanent Link |
MatthiasThaler | "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 |
Mon, Apr 12 2010 5:59 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | 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 |
This web page was last updated on Wednesday, August 14, 2024 at 03:12 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |