Hudi

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

 

Thanks

Outcomes