From: Juanma f. <pa...@ho...> - 2006-09-08 08:22:00
|
<html><div style='background-color:'><DIV class=RTE>I am executing the follow query:</DIV> <DIV class=RTE> </DIV> <DIV class=RTE>SELECT * FROM HISTPRECONTA <BR>WHERE (FECHALTA IS NULL OR FECHALTA='') <BR>OR FECHALTA IN('20060907') <BR>AND NUMEMP=2<BR>AND CODEMPRESA=1</DIV> <DIV class=RTE> </DIV> <DIV class=RTE>When I do the query with SQL Manager 2005 Lite for Interbase and Firebird, it go well. But when I execute the query from this C# code, the dataset never is filled, and the program execution is locked, in other words, the method adapter.Fill(ds) never terminates</DIV><FONT size=2> <P class=RTE>adapter.SelectCommand=command; <BR>command.CommandText = <BR>"SELECT * FROM HISTPRECONTA <BR>WHERE (FECHALTA IS NULL OR FECHALTA='') <BR>OR FECHALTA IN('20060907') <BR>AND NUMEMP=2<BR>AND CODEMPRESA=1"<BR>ds = new DataSet();<BR>adapter.Fill(ds); //Here the program is locked and the method never returns, no exception is throwed</P> <P class=RTE>I'm sure that the C# code is ok, I have execute the query with other data and it go ok.</P> <P class=RTE>I'm using Firebird Server 1.5 and Firebird Net Provider 1.6</FONT><FONT size=2></P></FONT></div></html> |