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