I'm getting this error when executing a select * from a filemaker table.
An error occurred when executing the SQL command:
Select * FROM Table
[FileMaker][FileMaker JDBC] For input string: "?": ? [SQL State=22003]
Execution time: 1.67s
1 statement(s) failed.
It works great when I select a field that I know has valid data. There is obviously some field somewhere in the table with a value (?) that jdbc is not able to read. Is this something standard when setting up a jdbc connection and does it mean that I must go through each field and ensure that they return no question marks?
Sure hope not