Have a normal file keyed by one column.
It is not an option to change this column to auto increment...
I can add single records with insert statement where the key field is
"max(field) + 1" -
In the values
(select keyfld = max(keyfld) + 1), itemName,itemType.
But if I do an insert that has selected multiple records - I get an error
the keyfld not unique
Insert into itemMast
(keyfld, itemName, itemType, qtyOH, Location)
Select (select keyfld = max(keyfld) +1), itemName, 'A', 0, Location
Where itemType = 'B'
Is there a way to do this without altering the definition of the file
We need to duplicate a large number of records, but with unique keys.
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
Please contact support@xxxxxxxxxxxx for any subscription related
Help support midrange.com by shopping at amazon.com with our affiliate