Advertisement

02.14.2007 at 08:30AM PST, ID: 22388825
[x]
Attachment Details

Auto Increment primary key field in a sql database when adding a new record on a delphi form

Asked by Paulstott in Delphi Database, Delphi Programming

Tags: sql, auto, increment, key, primary

Hi EE

I have a customer table in sql with a customerid field that I have set as the primary key. What i want is when I add a new record using the Delhi DBNavigator it autoincrements that field.

There is also another field customerref that I want to take some of the information from the primary key. I want the customerref to be OTY\0001 where 1 would be the primary id and so on. Is there a way of doing this?Start Free Trial
 
Keywords: Auto Increment primary key field in a s…
Title
1 AutoIncrement max+1 wont work
2 Update of Primary Key oft times not su…
3 Autoincrement
4 Autoincrement of primary key?
5 AutoIncrement
6 Auto Increment - how to add a 2nd c…
 
Loading Advertisement...
 
[+][-]02.14.2007 at 11:00AM PST, ID: 18534181

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: Delphi Database, Delphi Programming
Tags: sql, auto, increment, key, primary
Sign Up Now!
Solution Provided By: mikelittlewood
Participating Experts: 5
Solution Grade: A
 
 
[+][-]02.14.2007 at 12:53PM PST, ID: 18535339

Assisted solutions are selected by the member who asked the question as a comment that contributed to their question's solution.

Start your 7-day free trial to view this Assisted Solution or ask the Experts your question.

 
[+][-]02.15.2007 at 12:42AM PST, ID: 18538646

Assisted solutions are selected by the member who asked the question as a comment that contributed to their question's solution.

Start your 7-day free trial to view this Assisted Solution or ask the Experts your question.

 
[+][-]02.15.2007 at 12:51AM PST, ID: 18538676

Assisted solutions are selected by the member who asked the question as a comment that contributed to their question's solution.

Start your 7-day free trial to view this Assisted Solution or ask the Experts your question.

 
[+][-]02.15.2007 at 01:11AM PST, ID: 18538769

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]02.15.2007 at 08:55AM PST, ID: 18541730

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]02.15.2007 at 08:58AM PST, ID: 18541768

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]02.15.2007 at 11:27AM PST, ID: 18543101

Assisted solutions are selected by the member who asked the question as a comment that contributed to their question's solution.

Start your 7-day free trial to view this Assisted Solution or ask the Experts your question.

 
[+][-]02.16.2007 at 12:55AM PST, ID: 18546929

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]06.18.2007 at 02:26PM PDT, ID: 19310861

Experts Exchange has a courteous staff of administrators who help members get the most out of the website by means of administrative comments like this one.

Start your 7-day free trial to view this Administrative Comment or ask the Experts your question.

 
[+][-]06.29.2007 at 02:25AM PDT, ID: 19387572

Experts Exchange has a courteous staff of administrators who help members get the most out of the website by means of administrative comments like this one.

Start your 7-day free trial to view this Administrative Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32