>Hi Cetin
>
>Sorry for replying late as I was out of town. Thanks for the idea.
>
>>If ansi is off :
>>myField = ?cValue && would return all for m.cValue = ''
>
>I had no real experience with characters and I keep ANSI default ie. OFF
>
>>between ?nVal1 and ?nVal2
>
>Actually the requirement arose from numeric
>
>>and put possible lowest/highest values for all.
>
>but do I have to type in these nos. (from the help)
>-2147483647 to 2147483647 or there is some shortcut to simulate these numbers something like GOMONTH(DATE(), 1) - 1
What I do is something like this :
m.lnMin = iif(empty(m.tnID),0,m.tnID)
m.lnMax = iif(empty(m.tnID),0x7FFFFFFF,m.tnID)
and query looks like :
.... myID between ?m.lnMin and ?m.lnMax
Cetin