> 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/
