Hello all,

I’ve worked with SQL so long now that going back to filemaker is seriously crazy-making when it comes to simple range searching.

I’m using FMP Adv. Server 14, Lasso 8.6. I just want to get a range between two numbers.

I _thought_ back in the day, this is how we did it. I can get the GTE part working - but when I add the second part, i get an FMP error.

What exactly am I doing wrong here? :)

Inline: -Database=‘mycatcatdb',
-Table='detail',
-inlinename='categories',
-oplogical='and',
-op='gte',
'catnum' = '3000',
-op='lte',
'catnum' = '9000',
-search,
-sortfield=‘category',
-maxrecords='all’;

/inline;

Best,

Peter Bethke

#############################################################

This message is sent to you because you are subscribed to
the mailing list Lasso Lasso@lists.lassosoft.com
Official list archives available at http://www.lassotalk.com
To unsubscribe, E-mail to: <Lasso-unsubscribe@lists.lassosoft.com>
Send administrative queries to <Lasso-request@lists.lassosoft.com>