Select Max

[Spanish beginne]

Hi all!

Well, Im working on a personal application to manage one of my personals Access databases.

In particular, the problem Im having is related to a SELEC MAX. I need to do this in order to add 1 and have the index of the row I want to insert. But I do not know how to perform this in Visual Basic.Net

Does anybody knows how to handle this situation? Is that possible to have two diferent "statements" in the same form to the same table (one for the MAX statement and another for selecting/updating/deleting rows)?

Thanks to all and greetings from Spain!

 

[Robby]

I would place them into two different functions, and make them very generic so that you can use them troughout the application.

 

[Nerseus]

Is it possible to use Accesss AutoNumber column type? It would work pretty much the same but you wouldnt have to run a separate query to generate the next number (which might also have issues with timing).

-Nerseus