I am executing the follow query:
SELECT * FROM HISTPRECONTA
WHERE (FECHALTA IS NULL OR FECHALTA='')
OR FECHALTA IN('20060907')
AND NUMEMP=2
AND CODEMPRESA=1
WHERE (FECHALTA IS NULL OR FECHALTA='')
OR FECHALTA IN('20060907')
AND NUMEMP=2
AND CODEMPRESA=1
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
adapter.SelectCommand=command;
command.CommandText =
"SELECT * FROM HISTPRECONTA
WHERE (FECHALTA IS NULL OR FECHALTA='')
OR FECHALTA IN('20060907')
AND NUMEMP=2
AND CODEMPRESA=1"
ds = new DataSet();
adapter.Fill(ds); //Here the program is locked and the method never returns, no exception is throwed
I'm sure that the C# code is ok, I have execute the query with other data and it go ok.
I'm using Firebird Server 1.5 and Firebird Net Provider 1.6
------------------------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________ Firebird-net-provider mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
