Re: TeraScript-Talk: Case
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.
Re: TeraScript-Talk: Case
You could try changing the storage in filmmaker to unicode and see if that changes anything. I seem to remember doing that sometime ago and having it work. But I may not be remembering correctly. Dan Stein theste...@me.com mailto:theste...@me.com If evolution really works, how come mothers only have two hands? Milton Berle On Nov 3, 2014, at 6:52 PM, Wayne Irvine wa...@byteserve.com.au mailto:wa...@byteserve.com.au wrote: 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/ 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 mailto:lists...@terascript.com with unsubscribe terascript-talk in the body. -- Dan Stein MSN CPNP FileMaker Certified Developer Digital Software Solutions 303 W. Chestnut St Souderton PA 18964 Land: 215-799-0192 Cell: 610-256-2843 FMP, WiTango,MSSQL, MySQL,PHP d...@dss-db.com www.dss-db.com Men do not care how nobly they live, but only how long they live, although it is within the reach of every man to live nobly, but within no man's power to live long. Brian Haig Private Sector To unsubscribe from this list, please send an email to lists...@terascript.com with unsubscribe terascript-talk in the body.
RE: TeraScript-Talk: Case
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 mailto: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.