TeraScript-Talk: OS X 10.10 issues?
Anyone having an issues with JDBC connections no longer working ibn the editor once updating to 10.10. I am on TS 7.01 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 Your time is limited, so don’t waste it living someone else’s life. Don’t be trapped by dogma — which is living with the results of other people’s thinking. Don’t let the noise of others’ opinions drown out your own inner voice. And most important, have the courage to follow your heart and intuition. They somehow already know what you truly want to become. Everything else is secondary. Steve Jobs. To unsubscribe from this list, please send an email to lists...@terascript.com with unsubscribe terascript-talk in the body.
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.
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.