jdbc input error

Discussion created by Hudi on May 10, 2013
Latest reply on May 13, 2013 by Hudi

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