@johnskywalker i found the error actually method calling path is wrong.
1 Like
@johnskywalker let’s say i have 10 records and i’m using this value as unique. assume i created new record with auto increment field as 10 because i have 10 entries.
what if i deleted one record in between and try to add new record ? already entry with field value as 10 is there. It will try to save number as 10 again right ? So how can i overcome this issue ??
Rather than using select “count(*)”, you can use “select MAXNO(fieldname)” in order to overcome this scenario.