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,
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
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
