Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

autonumber 1

Status
Not open for further replies.

debbie14

Programmer
Apr 11, 2005
5
CY
Hi, everyone! I'm new in programming and I need all the help I can get. Here;s the problem. I'm doing an application and I need to enter an autonumber in a text box. I've managed to do that, but the thing is that each time I run the program the autonumber starts counting from 1 again. Any ideas how to solve it?
 
What does this have to do with Mercator / Ascential DataStage TX? If it does, then you need GETANDSET function.
BTW, if it is auto _number_, it would be better if it went into a numeric box, rather than text.

What language are you programming in?

BocaBurger
<===========================||////////////////|0
The pen is mightier than the sword, but the sword hurts more!
 
Whatever language, you need to store the last occurrence somewhere. eg Oracle use a sequence on a table. If it's a file you'll need to keep the last used value in another file or database.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top