Re: TeraScript-Talk: Case

2014-11-04 Thread Dan Stein
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 If evolution really works, how come mothers onl

Re: TeraScript-Talk: Case

2014-11-04 Thread BEVERLY VOTH
e 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@

RE: TeraScript-Talk: Case

2014-11-03 Thread Robert Shubert
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

TeraScript-Talk: Case

2014-11-03 Thread Wayne Irvine
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