Thanks for response. Still fails with casting. This error may only be a FB2.0.6 deal - because this query works in FB 2.5.
On 11/04/12 16:06, Charlie Xiong wrote: > select h.h_JobNumber, c.c_LastName, c.c_FirstName , case s.s_value > when 'Y' then COALESCE(h.h_servicetech, '') else > COALESCE(h.h_representative,'') end as H_BTech, s.s_value, v.v_year > from Header h left join systemsetting s on s.s_system_id = 999 and > s.s_shopid = h.h_shopid left outer join Customer c on c.c_Customer_Id > = h.h_CustomerId left outer join vehicle v on v.v_vehicle_id = > h.h_vehicleid where (h.h_ShopId = 100) > > > Error: :Error querying database > FirebirdSql.Data.FirebirdClient.FbException (0x80004005): arithmetic > exception, numeric overflow, or string truncation ---> arithmetic > exception, numeric overflow, or string truncation at > FirebirdSql.Data.FirebirdClient.FbCommand.Fetch() in > C:\VSNET\FB_Provider_265\FirebirdSql\Data\FirebirdClient\FbCommand.cs: > line > 689 at FirebirdSql.Data.FirebirdClient.FbDataReader.Read() in > C:\VSNET\FB_Provider_265\FirebirdSql\Data\FirebirdClient\FbDataReader.cs:line > 242 at System.Data.Common.DataAdapter.FillLoadDataRow(SchemaMapping > mapping) at System.Data.Common.DataAdapter.FillFromReader(DataSet > dataset, DataTable datatable, String srcTable, DataReaderContainer > dataReader, Int32 startRecord, Int32 maxRecords, DataColumn > parentChapterColumn, Object parentChapterValue) Possibly related to: http://tracker.firebirdsql.org/browse/DNET-420 Where driver is misidentifying the column type/size. Can you wrap the CASE in a CAST? Scott ------------------------------------------------------------------------------ Better than sec? Nothing is better than sec when it comes to monitoring Big Data applications. Try Boundary one-second resolution app monitoring today. Free. http://p.sf.net/sfu/Boundary-dev2dev _______________________________________________ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider ------------------------------------------------------------------------------ Better than sec? Nothing is better than sec when it comes to monitoring Big Data applications. Try Boundary one-second resolution app monitoring today. Free. http://p.sf.net/sfu/Boundary-dev2dev _______________________________________________ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
