Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB Enhancement Requests and Suggestions » View Thread |
Messages 1 to 2 of 2 total |
Minor Bug in v2.11 b1 when dropping a table column that references itself |
Sat, Nov 17 2012 5:27 PM | Permanent Link |
Barry | In table MyTable I have a column called CompanyId that is a GUID and its default is set to:
Default: IFNULL(CompanyId,fcn_GetActiveCompanyId(),CompanyId); Basically this default value will update CompanyId with the active company id (set in another table) when the MyTable row is added. (Yes, I could have used a trigger for this, but I wanted this value defined prior to the post event in Delphi). If I later decide to use EDBMgr to drop the column CompanyId from table MyTable, it complains CompanyId is referenced by CompanyId. Here is the error message: ElevateDb Error #201 The column CompanyId in the table MyTable cannot be dropped because it is still referenced by the column CompanyId in the table MyTable. So when dropping an object like a column, EDB should ignore any references that point to itself. I haven't tried this will v2.11 b2. I also don't know if this same effect exists in other objects like tables or views. Barry |
Wed, Jan 2 2013 5:41 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Barry,
<< So when dropping an object like a column, EDB should ignore any references that point to itself. I haven't tried this will v2.11 b2. I also don't know if this same effect exists in other objects like tables or views. >> I'll check this out, thanks. Tim Young Elevate Software www.elevatesoft.com |
This web page was last updated on Monday, April 22, 2024 at 04:13 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |