PPC Question - dBforums

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

> PPC Question

Reply

#1 (permalink)

Old

01-29-09, 15:34

darrellj

darrellj is offline

Registered User

Join Date: Jan 2007

Posts: 7

PPC Question

In the PPC, I am creating some new tables. How can I create a primary key that auto increments? I am using v10.

Thanks in advance.

Reply With Quote

#2 (permalink)

Old

01-29-09, 16:24

darrellj

darrellj is offline

Registered User

Join Date: Jan 2007

Posts: 7

Red face

Nevermind, I found the IDENTITY data type. Doesn't Pervasive have an AUTO_INCREMENT command when creating/altering a table?

Reply With Quote

#3 (permalink)

Old

01-29-09, 16:31

mirtheil

mirtheil is offline

Registered User

Join Date: Dec 2001

Posts: 1,015

No. Pervasive doesn't have the AUTO_INCREMENT command. You need to use the IDENTITY field type.

__________________
Mirtheil Software
Certified Pervasive Developer
Certified Pervasive Technician
Custom Btrieve/VB development
http://www.mirtheil.com
I do not answer questions by email. Please post on the forum.

Reply With Quote

Reply

« Previous Thread | Next Thread »

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On Forum Rules