HI,

I am Roby Eisenbraun Martins. I am a VC++, VB and NET developer.

I created a Dataset using the dataset designer and I added two tables on
it. This tables came from a SQL Server database and they have a relation ship
in the SQL Server. So a created the same relatio ship in the dataset designer.

Executing the Fill method from a data adapter I received this error
message "Failed to enabled constraints, .....". If I remove the relationship
it works.

How can that be possible if the database contain the same relation ship?

Thank you,
Roby Eisenbraun Martins

Hey,

I found out the problem. One record had got a null value in the field
related to the other table and Dataset thought that it should be treated an
error.
How can I change the relationship to accept null fields.

Client - Product
ID - ClientID
( this should accept NULL, if is null then there are no
client to this
product )

Thank you,
Roby Eisenbraun Martins

"Roby Eisenbraun Martins" wrote:

> HI,
>
> I am Roby Eisenbraun Martins. I am a VC++, VB and NET developer.
>
> I created a Dataset using the dataset designer and I added two tables on
> it. This tables came from a SQL Server database and they have a relation ship
> in the SQL Server. So a created the same relatio ship in the dataset designer.
>
> Executing the Fill method from a data adapter I received this error
> message "Failed to enabled constraints, .....". If I remove the relationship
> it works.
>
> How can that be possible if the database contain the same relation ship?
>
> Thank you,
> Roby Eisenbraun Martins

Hey Roby,

I believe you should be able to turn off constraints before you fill the
dataset...
"Roby Eisenbraun Martins" <(E-Mail Removed)>
wrote in message news:6B8146B9-076A-4E1F-9005-(E-Mail Removed)...
> Hey,
>
> I found out the problem. One record had got a null value in the field
> related to the other table and Dataset thought that it should be treated
> an
> error.
> How can I change the relationship to accept null fields.
>
> Client - Product
> ID - ClientID
> ( this should accept NULL, if is null then there are no
> client to this
> product )
>
> Thank you,
> Roby Eisenbraun Martins
>
> "Roby Eisenbraun Martins" wrote:
>
>> HI,
>>
>> I am Roby Eisenbraun Martins. I am a VC++, VB and NET developer.
>>
>> I created a Dataset using the dataset designer and I added two tables
>> on
>> it. This tables came from a SQL Server database and they have a relation
>> ship
>> in the SQL Server. So a created the same relatio ship in the dataset
>> designer.
>>
>> Executing the Fill method from a data adapter I received this error
>> message "Failed to enabled constraints, .....". If I remove the
>> relationship
>> it works.
>>
>> How can that be possible if the database contain the same relation
>> ship?
>>
>> Thank you,
>> Roby Eisenbraun Martins