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.
