[RESOLVED] Secuencial Numbers

[ecabralrojas]

Hello

I have an application that when I open and "Order Number", I have to type the number.

How can I generate automatic secuencial number every time when open "Order Number"

I'll Appreciate you helps

Elvis Cabral

[ecabralrojas]

And I need to insert into a table that number in field "Order_Number"

[Hack]

Run a SELECT query against the field that has your order number

SELECT MAX(order_number) As NextNumber

Store the return in a variable and use that variable in your INSERT INTO query.

[ecabralrojas]

In VB6 How do I Generate Automatic Secuencial Numbers?

[ecabralrojas]

Please can you do an example please how is vb6

[Veritas2.0]

Hack pretty much gave you everything you need, but if you really need to be spoonfed basically do this.

Private Function GenerateNumber() As Integer
'This function, when called, will return the next number you should add to your database.
    Dim myRecordSet As adodb.Recordset
    
    Set myRecordSet = New adodb.Recordset
    myRecordSet.Open "SELECT MAX(order_num) AS next_num FROM TABLE", myConnection, adopenstatic, adlockoptimistic
    GenerateNumber = myRecordSet("next_num") + 1
    myRecordSet.Close
    Set myRecordSet = Nothing
    
End Function

Hopefully, you can figure the rest out on your own.

[ecabralrojas]

Thanks A lot Veritas

Now my application is generate the numbers

Elvis Cabral