my guess is that the JDBC ( or ODBC ) *driver* for FileMaker as a source is
what limits the case.
These docs might be helpful to those using FMS13:
<https://fmhelp.filemaker.com/docs/13/en/fm13_odbc_jdbc_guide.pdf>
<https://fmhelp.filemaker.com/docs/13/en/fm13_sql_reference.pdf>
And remember that FMS can output XML (various grammars), should that prove to
be an option. Sometimes I've had to use xDBC and XML to get the optimum with
FMS as source. You are not required to use the FM API for PHP, but simply make
XML the queries:
<https://fmhelp.filemaker.com/docs/13/en/fms13_cwp_xml.pdf>
Beverly
On Nov 3, 2014, at 7:14 PM, Robert Shubert <rshub...@tronics.com> wrote:
> Wayne,
>
> Case sensitivity in SQL comparisons is a function of the database server. As
> far as I know, FileMaker does not have an option for case insensitive
> matching when doing comparisons via ODBC/JDBC.
>
> About the best thing I can offer from TeraScript’s perspective (and this
> would be a helpful option for any case sensitive database) is to simplify the
> ability to lower case a column by making it a simple checkbox option in the
> where clause.
>
> To extend that thought, a small menu to apply simple functions to columns
> (upper(), lower(), trim(), etc) might be convenient.
>
> Robert
>
> From: Wayne Irvine [mailto:wa...@byteserve.com.au]
> Sent: Monday, November 03, 2014 6:53 PM
> To: TeraScript-Talk@terascript.com
> Subject: TeraScript-Talk: Case
>
> A lot of my code was written for Witango/FileMaker which is not case
> sensitive. These days we are using Terascript and Filemaker via JDBC. It's
> case sensitive.
>
> The way we've been handling it is by using a calculation field in the table
> to calculate the lowercase of the entered string, then when a string from
> Terascript is compared against it we use the <@LOWER> tag. Works, but is a
> lot of work to set up.
>
> I'm thinking there might be a built in method to switch or handle case
> sensitivity. Or is everybody doing it like this?
>
> Wayne Irvine
> w: http://www.byteserve.com.au/
> p: +61 2 9960 6099
> m: 0409 960 609
>
>
> To unsubscribe from this list, please send an email to
> lists...@terascript.com with "unsubscribe terascript-talk" in the body.
>
> To unsubscribe from this list, please send an email to
> lists...@terascript.com with "unsubscribe terascript-talk" in the body.
----------------------------------------
To unsubscribe from this list, please send an email to lists...@terascript.com
with "unsubscribe terascript-talk" in the body.
