The problem is this procedure :

procedure getNextRec;
var currID: Integer;
begin
with mySingleQuery do
begin
currID := FieldByName ( 'ItemNo' ).AsInteger;
ParamByName := currID + 1; <============================== + 1
doesn't always work
// with RefreshOnParamChange set to TRUE that should be all
end;
end;

Nico

-----Oorspronkelijk bericht-----
Van: Lucas Franzen [mailto:luc@...]
Verzonden: vrijdag 1 juni 2001 9:42
Aan: ib-support@yahoogroups.com
Onderwerp: Re: [ib-support] Query question




Nico Callewaert schrieb:

>
> Thanks Lucas,
>
> But the problem is, the next ItemNo is not always CurrItemNo +

1....

Yes, I know and what?

Have a look at the sql again:

SELECT xxxxxxx FROM xxxxxxx
WHERE ItemNo > :qItemNo
ORDER BY ItemNo

If you have records like:
ItemNo.
--------
100
104
108
109
255
256

when your current record is 100 and you want to get the next one it will
be 104, then 108, then 109 and so on.

So where's the problem?

Luc.

To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/