Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 4 of 4 total
Thread Suppressing Autoinc Values in TEDBTable
Wed, Apr 25 2007 9:42 AMPermanent 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 AMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email 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 PMPermanent Link

Peter Thorne
Thanks Tim. The new product looks great by the way.

Fri, Apr 27 2007 9:21 AMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Peter,

<< Thanks Tim. The new product looks great by the way. >>

Thanks very much.

--
Tim Young
Elevate Software
www.elevatesoft.com

Image