Submitted by: gregoryp (gregoryp)
Assigned to: @carlosga
SFID: 1017108#
Submitted By: gregoryp
I'm using the FbCommand.FillSchema to fill a dataset :
cmd.FillSchema ( dataset,SchemaType.Source, "TABLE" )
...
My query returns about 40 columns ( with lots of joins )
and i'm getting the following error :
System.Data.InvalidConstraintException: Cannot have
more than 32 columns. at
System.Data.DataKey.Create(DataColumn[] columns,
Int32[] sortOrders) at
System.Data.UniqueConstraint.Create(String
constraintName, DataColumn[] columns) at
System.Data.UniqueConstraint..ctor(String name,
DataColumn[] columns) at
System.Data.Common.SchemaMapping.SetupSchemaWith
KeyInfo(MissingMappingAction mappingAction,
MissingSchemaAction schemaAction, Boolean
gettingData, DataColumn parentChapterColumn, Object
chapterValue) at
System.Data.Common.SchemaMapping.SetupSchema
(SchemaType schemaType, String sourceTableName,
Boolean gettingData, DataColumn parentChapterColumn,
Object parentChapterValue) at
System.Data.Common.DbDataAdapter.FillSchemaFromCom
mand(Object data, SchemaType schemaType,
IDbCommand command, String srcTable,
CommandBehavior behavior) at
System.Data.Common.DbDataAdapter.FillSchema
(DataSet dataSet, SchemaType schemaType,
IDbCommand command, String srcTable,
CommandBehavior behavior) at
System.Data.Common.DbDataAdapter.FillSchema
(DataSet dataSet, SchemaType schemaType, String
srcTable) at
MyQuery.exec()
-------
It seems that it is trying to create a PrimaryKey with all
the columns on the table... thats is very wierd ...