>Hi Hilmar
>
SELECT IIF(not table='CUSTPAYMENT',999999999999,newid('CUSTPAYMENT')) as nextid ;
> FROM ids WHERE table='CUSTPAYMENT' INTO CURSOR tNextIdI don't know why the SP gets executed twice.
How about a two-step selection, would that solve the problem?
SELECT (fieldlist) from ids where WHERE table='CUSTPAYMENT';
INTO CURSOR tNextId nofilter
select *, IIF(not table='CUSTPAYMENT',999999999999,newid('CUSTPAYMENT')) as nextid;
from tNextId into cursor tNextId
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
