hellow, im trying to reset the ticket number following this emre method:
but…it doesnt reset the number generator…im using sambapos in spanish…i have also try to set the "where name = " to my column table name that is is spanish but it also doesnt work…any idea why?
Or any other method please
Yes you can use database tools.
- Create a new file and name it as
[CBL]Reset Ticket Number Generator.sql. Be sure it’s extension is
- Edit that file with a text editor (notepad) add that script and save it.
Update Numerators set Number = 29119 where Name = 'Ticket Number Generator'
- When you open database tools you should see your script listed here. Be sure Task Type is
Click on that task and click
With that method you can run any sql snippet we release here.
Note: For anyone interested
Logout and you can execute tasks with
Execute Database Taskaction.