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