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 <[email protected]> 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: [email protected] >> p: +61 02 9960 6099 >> m: 0409 960 609 >> f: +61 02 9960 6088 >> >> >> >> >> ---------------------------------------- >> >> To unsubscribe from this list, please send an email to >> [email protected] with "unsubscribe terascript-talk" in the body. >> > > ---------------------------------------- > > To unsubscribe from this list, please send an email to > [email protected] with "unsubscribe terascript-talk" in the body. > ---------------------------------------- To unsubscribe from this list, please send an email to [email protected] with "unsubscribe terascript-talk" in the body.
