Re: Resetting the table sequence number

2018-10-15 Thread Chuck Miller via 4D_Tech
You could also do this c_longint($Variable_L) begin sql select MAX([table]ID_Field) from [table] into :$Variable_L; end sql or query by sql([table];max([table]ID_Field) into :$Variable_L) I am not sue query by sql will work Regards Chuck ---

Re: Resetting the table sequence number

2018-10-15 Thread Chip Scheide via 4D_Tech
dded some code to check and - supposedly - fix it by > resetting the table sequence number, but it doesn't seem to work. > > This is what I'm doing: > > $Sequence:=*Sequence number*(*Table*($iTableNumber)->) > > *If* (*Find in field*(*$1*->;$Sequence)>-1) //

Resetting the table sequence number

2018-10-15 Thread Pat Bensky via 4D_Tech
I have a method that creates record numbers using the Sequence number. I'm running into a situation where I am getting duplicate record numbers for some reason. So I added some code to check and - supposedly - fix it by resetting the table sequence number, but it doesn't seem to work