Problem generating DataSets with PgSqlDataAdapter

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for PostgreSQL
Post Reply
gabriel

Problem generating DataSets with PgSqlDataAdapter

Post by gabriel » Fri 22 Apr 2005 20:09

Hello,

I configured a PgSqlDataAdapter instance with the following SelectCommand

SELECT users.code, users.firstname, users.lastname, userprofiles.name
FROM users
INNER JOIN userprofiles ON userprofiles.id = users.userprofileid

When using the preview feature of the adapter all works fine and all rows are returned correctly. However, when I try to generate a DataSet from the adapter I get the following error

'Field with index 4 does not exist'

I tried playing around a little bit by adding and removing columns but I keep getting the same error with the index number increasing and decreasing respectively.

Any clues?

Thanks,

Gabriel

Yuri
Posts: 140
Joined: Mon 08 Nov 2004 12:07

Problem generating DataSets with PgSqlDataAdapter

Post by Yuri » Thu 28 Apr 2005 14:04

We reproduced your problem and fixed it. This fix will be included in the next PostgreSQLDirect .NETbuild.

Post Reply