Ok, Thank you,

Nico

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




Nico Callewaert schrieb:

>
> 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;

Okay, this procedure was just a quick and dirty example.

If your SQL has a > (greater) in the comparison then the new Param
should just be the current ItemNo, not current ItemNo + 1....

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/