Wayne,
Am I correct assume this is all on a MacOS server?
If so, which version of OS and FileMaker are you using?
- Steve K
On 7/10/2019 7:18 PM, ubs...@uw.edu wrote:
> Wayne,
>
> I recall needing to adjust datatype(s) in FM databases to work
> correctly with Wtango and JDBC/ODBC.
>
> Perhaps a test FM db with only integer columns.
>
> - Steve K
>
>
> On 7/10/19 7:06 PM, ubslab wrote:
>> Wayne,
>>
>> Are you able to connect to FM table.columns in the Terascribe editor
>> JDBC/ODBC panel?
>>
>> - Steve K
>>
>> On 7/10/19 6:45 PM, Wayne Irvine wrote:
>>>> On 11 Jul 2019, at 12:38 am, Robert Shubert <rshub...@tronics.com>
>>>> wrote:
>>>>
>>>> Wayne,
>>>>
>>>> First do a simple query like "SELECT 1" just to double check the DBMS.
>>> I tried:
>>> SELECT 1
>>> SELECT 1 FROM Packages
>>>
>>> both gave an error.
>>>> Then try grabbing just one row "SELECT packagename FROM Packages
>>>> WHERE packagename = '{known name}’"
>>> SELECT packagename FROM Packages WHERE packagename = 'Kessell Run’
>>>
>>> Error
>>>> If that works, then we may be looking for a bug dealing with
>>>> non-value. Try "SELECT packagename FROM Packages WHERE packagename
>>>> IS NOT NULL”
>>> SELECT packagename FROM Packages WHERE packagename IS NOT NULL
>>>
>>> Error
>>>> What version of TS are you running? There was a JDBC fix in 7.1.1
>>>> and I have another fix (which may be your problem) coming in 7.1.5.
>>> 7.1.3.1
>>>
>>> Wayne
>>>
>>> Byteserve Pty Ltd
>>> w: http://www.byteserve.com.au/
>>> e: i...@byteserve.com.au
>>> p: +61 02 9960 6099
>>> m: 0409 960 609
>>> f: +61 02 9960 6088
>>>
>>>
>>>
>>>
>>> ----------------------------------------
>>>
>>> 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.
