Re: [Firebird-net-provider] DataTable.Columns[x].Unique not set ?

[Pierre A. <pie...@op...>]

On Friday, December 24, 2004 5:54 PM [GMT+1=3DCET],
Carlos Guzm=E1n =C1lvarez <car...@te...> wrote:

> Hello:
>
>> No, neither the "Domiciles", nor the "Personnes" DataTable shows
>> any PrimaryKey(s) :
>>
>> ? set.Tables["Personnes"].PrimaryKey
>> {Length=3D0}
>> ? set.Tables["Domiciles"].PrimaryKey
>> {Length=3D0}
>> ? set.Tables["Domiciles"].Columns[0].Unique
>> false
>> ? set.Tables["Personnes"].Columns[0].Unique
>> true
>
> Ok, i will try to review it as soon as possible.
>
> One more thing do get correct schema information in the
> FbDataReader.GetSchema method ??
>
> Could ypu try to Fill the DataSet setting the
> FbDataAdapter.MissingSchemaAction to
> *MissingSchemaAction.AddWithKey*

I changed this setting and now, indeed, the PrimaryKey and
Unique properties are loaded properly, as are also the nullable
constraints, etc.

Could you please explain to me the difference between the default
behaviour and the 'AddWithKey' behaviour ? Why isn't the default
behaviour consistent with respect to initializing (or not ini-
tializing) the constraints ?

Thanks a lot and a Happy Year 2005 to all !

Pierre

PS: I was off-line for a week -- sorry for the long delay.=20