Article View: borland.public.cppbuilder.database.multi-tier
Article #1543Re: Sybase SQL anywhere - autoincrement field
From: Ingo Oellers
Date: Mon, 27 Sep 1999 00:00
Date: Mon, 27 Sep 1999 00:00
32 lines
1750 bytes
1750 bytes
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
Technical Details
Message-ID:
<37EF7AE8.FA52DC1F@plum.de>Path:
arc1-ca.pugleaf.net!unknown!not-for-mailReferences:
<37EF787A.2FB15059@erd.advantest.de>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: fcd2b,2f85643b4a33fdea X-Google-Attributes: gidfcd2b,public From: Ingo Oellers <io@plum.de> Subject: Re: Sybase SQL anywhere - autoincrement field Date: 1999/09/27 Message-ID: <37EF7AE8.FA52DC1F@plum.de> X-Deja-AN: 529876489 Content-Transfer-Encoding: 7bit References: <37EF787A.2FB15059@erd.advantest.de> To: Anne Faveur <a.faveur@erd.advantest.de> X-Accept-Language: de Content-Type: text/plain; charset=us-ascii Organization: Another Netscape Collabra Server User Mime-Version: 1.0 Newsgroups: borland.public.cppbuilder.database.multi-tier