> I am looking for help with a firebird odbc error. We have Endicia client attempting to post back shipping data to Fishbowl Inventory;
>
> SQL Statement:
> INSERT INTO SHIPPINGIMPORT (ID,TRACKINGNUM,CARTONCOST,CARTONWEIGHT) VALUES (i49213,'9434610200883361052698',5.39,5.0)
> System.Data.Odbc.OdbcException: ERROR [HY000] [ODBC Firebird Driver][Firebird]Dynamic SQL Error
> SQL error code = -206
> Column unknown
> I49213
> At line 1, column 77
> at System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode)
> at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader, Object[] methodArguments, SQL_API odbcApiMethod)
> at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader)
> at System.Data.Odbc.OdbcCommand.ExecuteNonQuery()
> at Endicia.Galaxy.PostBackDataSource.ExecuteNonQuery(String command)
> at Endicia.Galaxy.PostBackDataSource.PostBackDazRecords(ArrayList& RecordList)
>

I guess I49213 should have been a string literal?


--
With regards,
Thomas Steinmaurer (^TS^)
Firebird Technology Evangelist

http://www.upscene.com/

Do you care about the future of Firebird? Join the Firebird Foundation:
http://www.firebirdsql.org/en/firebird-foundation/