INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

make primary key using cpu() function ??

make primary key using cpu() function ??

(OP)
I read article that discuss how to make primary key using Using Autoincrementing Columns from a PowerBuilder DataWindow
http://scn.sap.com/community/developer-center/powe...
can i use primary key that generate from function cpu()and to reduce confusion i use number(CONCATENATE(A1,B1)) where A1= string(max(number)+1) and B1 = string(cpu())

RE: make primary key using cpu() function ??

By definition an Autoincrementing column has its value assigned by the database when a record is inserted. Although you can control the starting value of this (in most databases), you cannot dictate the key value itself.

To use your method you would need to generate a key prior to inserting the record and then assign that key to the proper column so that it is inserted into the table. You would not use the autoincrementing feature at all.

Matt

"Nature forges everything on the anvil of time"
www.anvil-of-time.com

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close