[Mono-devel-list] DbDataAdapter.Fill problems

[yoros at wanadoo.es]

On Fri, Feb 13, 2004 at 04:13:09PM +0100, Carlos Guzmán Álvarez wrote:
> Hello:
> 
> I'm having problems with the DbDataAdapter.Fill method, i'm running the 
> nunit test suite of the Firebird .NET Data Provider under Fedora Core 1 
> using latest mono CVS sources, the test cases that are giving problems 
> to me are mainly related to the DataAdapter ( but all of them are 
> running fine under Windows using .NET 1.0 ).
> 
> The problem is that DbDataAdapter.Fill seems to be no loading any rows, 
> in a little sample like this:
> 
> string sql = "select * from TEST where int_field = @int_field";
> FbCommand command = new FbCommand(sql, connection, transaction);
> FbDataAdapter adapter = new FbDataAdapter(command);
> 
> adapter.SelectCommand.Parameters.Add("@int_field", 
> FbDbType.Integer).Value = 1;		
> 
> DataSet ds = new DataSet();
> adapter.Fill(ds, "TEST");
> 
> It needs to load one row but it's loading none, i ave checked that the 
> command is correct and returns one row using a DataReader.
> 
> If needed i can fill a bug report at Bugzilla and provide a complete 
> test case.
> 

I noticed that if I use any "relation" or "constraint" the Fill method
doesn't fill all the data (maybe 1 or 2 records)...

You can try to turn off all constraints, unique and pkeys.

Regards,

    Pedro

-- 
Pedro Martínez Juliá
\  yoros at terra.es
)|    yoros at wanadoo.es
/        http://yoros.dyndns.org
Socio HispaLinux #311
Usuario Linux #275438 - http://counter.li.org
GnuPG public information:  pub  1024D/74F1D3AC
Key fingerprint = 8431 7B47 D2B4 5A46 5F8E  534F 588B E285 74F1 D3AC