>Hi Guys,
>
>I have a table that stores the last no. generated by the previous transactions. Is it possible to get the next number then update the table with the new number using stored procedure?
>
>Can you please give me an example of how to do it properly.
>
>Thanks in advance...
What do you want to use it for - for primary keys? Just call a function that generates the sequential number, in a field's default value. The function can be included in the stored procedures.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)