SELECT MAX(VAL(id))+1 AS id FROM stock INTO DBF newid

[madurrani]

Example item list: 1100A, 1110U, 1112I

In foxpro & Visual Foxpro I used to issue following command to get new item id.

SELECT MAX(VAL(id))+1 AS id FROM stock INTO DBF temp\newid

How can i use this command in VB.NET/SQL

Thanks,

Aamir Durrani

 

[strongm]

Wrong forum. Try forum796 to start with