PDA

View Full Version : Generate automatically the number of Primary key


Jamal Larhzal-Gramberg
01-16-2004, 01:31 AM
Hi everybody,

Any suggestion how I generate automatically the number of Primary key
(number (22))
by Enterprise Manager.

Thanks a lot.

Guido Konsolke
01-16-2004, 04:19 AM
"Jamal Larhzal-Gramberg" wrote... Hi everybody, Any suggestion how I generate automatically the number of Primary
key (number (22)) by Enterprise Manager. Thanks a lot.
Hi,

try to search for 'nextval' or simply look up 'sequences' in the
documentation.

hth,
Guido

Jarmo
01-16-2004, 11:35 AM
"Jamal Larhzal-Gramberg" <jamal.larhzal-gramberg@plath.de> wrote in message
news:bu8b29$f1kqj$1@ID-171145.news.uni-berlin.de... Hi everybody, Any suggestion how I generate automatically the number of Primary key (number (22)) by Enterprise Manager. Thanks a lot.

See http://jen.fluxcapacitor.net/geek/autoincr.html

Jamal Larhzal-Gramberg
01-19-2004, 03:11 AM
Hi,

Thanks very much for your helpfull suggestion.
It works very well with (sequence and trigger) as
as mentioned in the web-site.

Jamal

---------------------------------------------------------------
"Jarmo" <jarmo@jarmo.com> schrieb im Newsbeitrag
news:40083d12$0$9388$ed9e5944@reading.news.pipex.net... "Jamal Larhzal-Gramberg" <jamal.larhzal-gramberg@plath.de> wrote in
message news:bu8b29$f1kqj$1@ID-171145.news.uni-berlin.de... Hi everybody, Any suggestion how I generate automatically the number of Primary key (number (22)) by Enterprise Manager. Thanks a lot. See http://jen.fluxcapacitor.net/geek/autoincr.html


MyLounge.com Site Map
Forum: Cars, Cell Phone, Database, Games, Home Improvement, IT, Music, School, Sports, Web Design, Web Server, Weight Loss

The MyLounge.com forum is intended for informational use only and should not be relied upon and is not a substitute for any advice. The information contained on MyLounge.com are opinions and suggestions of members and is not a representation of the opinions of MyLounge.com. MyLounge.com does not warrant or vouch for the accuracy, completeness or usefulness of any postings or the qualifications of any person responding. Please consult a expert or seek the services of an attorney in your area for more accuracy on your specific situation. Please note that our forums also serve as mirrors to Usenet newsgroups. Many posts you see on our forums are made by newsgroup users who may not be members of MyLounge.com Term of Service