Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 1 to 4 of 4 total |
Suppressing Autoinc Values in TEDBTable |
Wed, Apr 25 2007 9:42 AM | Permanent Link |
Peter Thorne | This property (available in DBISAM 4's TDBISAMTable) does not appear to have made the leap to ElevateDB. Is there an alternative, simple way of achieving this. I was assuming that using the "by default only" setting in Manager would
allow this but I don't seem to be able to generate columns using this option anyway (they revert to "always") when saved. |
Wed, Apr 25 2007 10:54 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Peter,
<< This property (available in DBISAM 4's TDBISAMTable) does not appear to have made the leap to ElevateDB. Is there an alternative, simple way of achieving this. I was assuming that using the "by default only" setting in Manager would allow this but I don't seem to be able to generate columns using this option anyway (they revert to "always") when saved. >> You're on the right path. There is a bug in the EDB Manager SQL generation for the BY DEFAULT option. If you create the table in the manager, click on the database name in the treeview on the left after the table has been created. Then click on the SQL tab on the right-hand side of the manager. You should see the CREATE TABLE SQL code for creating the table. If you change the ALWAYS to BY DEFAULT for the desired column, drop the existing table, and then run the changed SQL code, you should get the desired result. -- Tim Young Elevate Software www.elevatesoft.com |
Wed, Apr 25 2007 1:01 PM | Permanent Link |
Peter Thorne | Thanks Tim. The new product looks great by the way.
|
Fri, Apr 27 2007 9:21 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Peter,
<< Thanks Tim. The new product looks great by the way. >> Thanks very much. -- Tim Young Elevate Software www.elevatesoft.com |
This web page was last updated on Saturday, April 27, 2024 at 08:52 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |