Jul 17
Peter D Bethke Filemaker range search
Jul 17, 2015; 11:04
Peter D Bethke
Filemaker range search
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>
Jul 17
Peter D Bethke Re: Filemaker range search
Jul 17, 2015; 11:12
Peter D Bethke
Re: Filemaker range search
Jul 17
Mason Miller Re: Filemaker range search
Jul 17, 2015; 11:17
Mason Miller
Re: Filemaker range search
Jul 17
Tami Williams Re: Filemaker range search
Jul 17, 2015; 14:08
Tami Williams
Re: Filemaker range search
Jul 19
Maxwell Klein Re: Filemaker range search
Jul 19, 2015; 03:44
Maxwell Klein
Re: Filemaker range search
Aug 02
Johan Solve Re: Filemaker range search
Aug 02, 2015; 23:40
Johan Solve
Re: Filemaker range search