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) [Non-text portions of this message have been removed]
