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

Reply via email to