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
Problem generating DataSets with PgSqlDataAdapter
Problem generating DataSets with PgSqlDataAdapter
We reproduced your problem and fixed it. This fix will be included in the next PostgreSQLDirect .NETbuild.