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
---
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) //
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
3 matches
Mail list logo