🚀 go-pugleaf

Anne Faveur schrieb:
> 
> I have a sybase SQL anywhere database, with lots of table defined with
> an autoincrement field. When I connect to this database from BC++B4, the
> autoincrement primary key is not recognized either as a primary key nor
> as an autoincrement field.
> 
> With a navigator I am not allowed to refresh the data ("table does not
> support this operation because it is not uniquely indexed"). However I
> do have a unique index on my primary key (the SQL explorer does not see
> it either while Sybase SQL Central can see it ). And I can only insert
> rows by providing the primary key value by hand.
> 
> Certainly I did not understand something. Could anyone give me some
> hints, or direct me to some help or documentation I could read.
> 
> Thank you in advance for any help.
> 
> Anne Faveur (a.faveur@erd.advantest.de)

Hi,

set the Property "Read Only" in the fielddesigner for the
autoincrement-field on TRUE
Then the CPP-Builder post only the other fields to the database and
the autoincrement key will be computed by the ASA


Best regards

Ingo Oellers
ingo@oellers.de

Ingo Oellers wrote:

>
> set the Property "Read Only" in the fielddesigner for the
> autoincrement-field on TRUE
> Then the CPP-Builder post only the other fields to the database and
> the autoincrement key will be computed by the ASA

Hello,

First thank you for your answer. It works well.
Do you also know why BC++B does not recognize my primary keys and throws an
exception when I try to refresh. Should I redeclare all my primary keys within
BC++B?

Best Regards
Anne Faveur