Problem generating DataSets with PgSqlDataAdapter
Posted: 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
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