Welcome! Log In Create A New Profile

Advanced

Usign a filter with a set of values

Posted by Gus 
Gus
Usign a filter with a set of values
April 27, 2009 05:07AM
Hi All:

I'm browsing a table using:

FOR EACH Order WHERE OrderID >= 100
TableAdd(.......)
END

and this works fine. When I use the filter with a set of values, like:

FOR EACH Order WHERE OrderID = 100 TO 200
TableAdd(.......)
END

I get the following error: "Error initializing filter. Unexpected word: TO".
However, according to the help, this should work.

Any idea?
Thanks;
Gus
Gus
Re: Usign a filter with a set of values
April 27, 2009 06:16AM
Ok. Now it's working..
I was using a string variable to dynamically create the filter expression.
In the case of set of values, the TO word should not be included into that string.

Gus
Author:

Your Email:


Subject:


Spam prevention:
Please, enter the code that you see below in the input field. This is for blocking bots that try to post this form automatically. If the code is hard to read, then just try to guess it right. If you enter the wrong code, a new image is created and you get another chance to enter it right.
Message: