If the expected result set is in the range of "[Array:553x36]" I would
suspect characters that the ODBC/JDBC connector can't pass or parse.
Is it reasonable to refill the database with values not containing
special, symbol, or punctuation characters to diagnose?
Had a similar issue with a FM Wita
Wayne,
First do a simple query like "SELECT 1" just to double check the DBMS.
Then try grabbing just one row "SELECT packagename FROM Packages WHERE
packagename = '{known name}'"
If that works, then we may be looking for a bug dealing with non-value. Try
"SELECT packagename FROM Packages WHERE
I hadn’t noticed the user vars previously. They are left over from previous
searches with the Search action. I added a Purge as the first action and they
no longer appear.
I also changed the Select to retrieve a field that is not user generated, so
more predictable and alphanumeric.
Still give
> On 11 Jul 2019, at 12:38 am, Robert Shubert 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 = '{
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 wrote:
>>
>> Wayne,
>>
>> First do a simple query like "SELECT 1" just to double check the DBMS.
> I trie
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 p