Jdbc

[KumbhaniMehul]

I hava a table
Structure is (Item_ID varchar(10),....)

now i want to access the last record value and i want to increment the value of Item_ID field.

Please remember Item_ID is text(varchar) type.

please give me complete Query.

[Eranga]

Please do not post the same question in multiple sub-forums. I've already give you the solution.

[KumbhaniMehul]

ID is varchar type

[Eranga]

Is that the only data column you have? If so it's not possible to do that in anyways of I've explain earlier. You must have int value to do that. Just think about, you cannot take a top value by ordering a text data, otherwise not in a sequence. It's really hard to guess that we have such a sequence in text data. So you have to introduce an IDENTITY column. Since your table is record transaction data you MUST those valued data like IDENTITY number, date, etc.