G
Guest
Hi,
I've created a relational group of tables using the designer for the Data
Adapter. It decided to cross join all the tables, so I manually did it using
Inner joins, nothing special just PK to FK.
When I click preview data, then try to fill a dataset created by the
Generate Dataset button of the DataAdapter, I get the following error:
"The data adapter could not return the data from the data source."
"Syntax error converting the varchar value 'myStringValue' to a column of
data type int".
When I look at the schema of the Dataset, all the columns are varchar.
Why is it doing this?
Any suggestions/past experiences very welcome & thanks in advance.
Ant
I've created a relational group of tables using the designer for the Data
Adapter. It decided to cross join all the tables, so I manually did it using
Inner joins, nothing special just PK to FK.
When I click preview data, then try to fill a dataset created by the
Generate Dataset button of the DataAdapter, I get the following error:
"The data adapter could not return the data from the data source."
"Syntax error converting the varchar value 'myStringValue' to a column of
data type int".
When I look at the schema of the Dataset, all the columns are varchar.
Why is it doing this?
Any suggestions/past experiences very welcome & thanks in advance.
Ant