make primary key using cpu() function ??

[powerbuilde]

I read article that discuss how to make primary key using Using Autoincrementing Columns from a PowerBuilder DataWindow

http://scn.sap.com/community/develo...enting-columns-from-a-powerbuilder-datawindow

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())

 

[mbalent]

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"

http://www.anvil-of-time.com