I have a House keeping form and a button that runs this SET VAR vmax INTEGER = NULL SET VAR vmaxcust INTEGER = NULL SELECT MAX(custnum) INTO vmax FROM ptinfo SET VAR vmaxcust = .vmax + 1 AUTONUM custnum IN ptinfo USING .vmaxcust 1 NONUM
Marc ----- Original Message ----- From: Steve Breen To: RBASE-L Mailing List Sent: Thursday, November 20, 2008 9:44 AM Subject: [RBASE-L] - Auto number reset I have a auto number in a column in a table but there are occasions where we start to add a row to the table and then we do not add the new row, but the auto number has already been sequenced in the table. Is there any way of resetting this. Steve
