🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: borland.public.cppbuilder.database.multi-tier
Article #1542

Sybase SQL anywhere - autoincrement field

#1542
From: Anne Faveur
Date: Mon, 27 Sep 1999 00:00
17 lines
1312 bytes
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)
Technical Details
Message-ID: <37EF787A.2FB15059@erd.advantest.de>
Path: arc1-ca.pugleaf.net!unknown!not-for-mail

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: fcd2b,2f85643b4a33fdea,start
X-Google-Attributes: gidfcd2b,public
From: Anne Faveur <a.faveur@erd.advantest.de>
Subject: Sybase SQL anywhere - autoincrement field
Date: 1999/09/27
Message-ID: <37EF787A.2FB15059@erd.advantest.de>
X-Deja-AN: 529873968
Content-Transfer-Encoding: 7bit
Organization: Advantest Europe R&D
Content-Type: text/plain; charset=us-ascii
Mime-Version: 1.0
Newsgroups: borland.public.cppbuilder.database.multi-tier