Q: deleting relations

[G .Net]

Hi

I'm hoping that somebody can help me with a fairly puzzling problem.

I've created some DataTables which have relations between them e.g. one to
many. In the application, I want to remove entries from the table. To do
this I obviously need to temporarily switch off the relations. In order to
achieve this, I tried:

ds.Relations.Clear() ' where ds is the application DataSet
ds.Tables("table1").Clear()

but I get the exception:

"An unhandled exception of type 'System.ArgumentException' occurred in
system.data.dll
Additional information: Cannot remove unique constraint 'Constraint1'.
Remove foreign key constraint table1_table3' first."

What I don't understand is why the relations don't seem to have been
removed.

Can anybody point me in the right direction i.e. how do I switch off the
relations to allow the clearing of a table?

Many thanks in advance

Geoff

[tomb]

The exception is telling you to remove your indexes first - there is a
foreign key index from the child table to the parent. Remove that
first, then remove the relation.

T

G .Net wrote:

>Hi

I'm hoping that somebody can help me with a fairly puzzling problem.

I've created some DataTables which have relations between them e.g. one to
many. In the application, I want to remove entries from the table. To do
this I obviously need to temporarily switch off the relations. In order to
achieve this, I tried:

ds.Relations.Clear() ' where ds is the application DataSet
ds.Tables("table1").Clear()

but I get the exception:

"An unhandled exception of type 'System.ArgumentException' occurred in
system.data.dll
Additional information: Cannot remove unique constraint 'Constraint1'.
Remove foreign key constraint table1_table3' first."

What I don't understand is why the relations don't seem to have been
removed.

Can anybody point me in the right direction i.e. how do I switch off the
relations to allow the clearing of a table?

Many thanks in advance

Geoff

[GhostInAK]

Hello G .Net,

Goofball. The relationships are there for a reason. They define how you
are to interact with the data. Follow their rules.

-Boo

Hi

I'm hoping that somebody can help me with a fairly puzzling problem.

I've created some DataTables which have relations between them e.g.
one to many. In the application, I want to remove entries from the
table. To do this I obviously need to temporarily switch off the
relations. In order to achieve this, I tried:

ds.Relations.Clear() ' where ds is the application DataSet
ds.Tables("table1").Clear()

but I get the exception:

"An unhandled exception of type 'System.ArgumentException' occurred in
system.data.dll
Additional information: Cannot remove unique constraint 'Constraint1'.
Remove foreign key constraint table1_table3' first."
What I don't understand is why the relations don't seem to have been
removed.

Can anybody point me in the right direction i.e. how do I switch off
the relations to allow the clearing of a table?

Many thanks in advance

Geoff

[G .Net]

Err, yes I know they're there for a reason ;) but I have my reasons for
doing this!

Geoff

"GhostInAK" <gh*******@gmail.comwrote in message
news:c7**************************@news.microsoft.c om...

Hello G .Net,

Goofball. The relationships are there for a reason. They define how you
are to interact with the data. Follow their rules.

-Boo

>Hi

I'm hoping that somebody can help me with a fairly puzzling problem.

I've created some DataTables which have relations between them e.g.
one to many. In the application, I want to remove entries from the
table. To do this I obviously need to temporarily switch off the
relations. In order to achieve this, I tried:

ds.Relations.Clear() ' where ds is the application DataSet
ds.Tables("table1").Clear()

but I get the exception:

"An unhandled exception of type 'System.ArgumentException' occurred in
system.data.dll
Additional information: Cannot remove unique constraint 'Constraint1'.
Remove foreign key constraint table1_table3' first."
What I don't understand is why the relations don't seem to have been
removed.

Can anybody point me in the right direction i.e. how do I switch off
the relations to allow the clearing of a table?

Many thanks in advance

Geoff

[G .Net]

Hi T

Could you tell me how to remove the indexes?

Geoff

"tomb" <to**@technetcenter.comwrote in message
news:oO*****************@bignews4.bellsouth.net...

The exception is telling you to remove your indexes first - there is a
foreign key index from the child table to the parent. Remove that first,
then remove the relation.

T

G .Net wrote:

>>Hi

I'm hoping that somebody can help me with a fairly puzzling problem.

I've created some DataTables which have relations between them e.g. one to
many. In the application, I want to remove entries from the table. To do
this I obviously need to temporarily switch off the relations. In order to
achieve this, I tried:

ds.Relations.Clear() ' where ds is the application DataSet
ds.Tables("table1").Clear()

but I get the exception:

"An unhandled exception of type 'System.ArgumentException' occurred in
system.data.dll
Additional information: Cannot remove unique constraint 'Constraint1'.
Remove foreign key constraint table1_table3' first."

What I don't understand is why the relations don't seem to have been
removed.

Can anybody point me in the right direction i.e. how do I switch off the
relations to allow the clearing of a table?

Many thanks in advance

Geoff

[G .Net]

Basically, I need to know how to remove Unique and ForeignKey constraints.
The following line of code does not work:
ds.Tables("Table1").Constraints.Clear()

Thanks in advance

Geoff

"G .Net" <no********@email.comwrote in message
news:hp******************************@pipex.net...

Hi T

Could you tell me how to remove the indexes?

Geoff

"tomb" <to**@technetcenter.comwrote in message
news:oO*****************@bignews4.bellsouth.net...

>The exception is telling you to remove your indexes first - there is a
foreign key index from the child table to the parent. Remove that first,
then remove the relation.

T

G .Net wrote:

>>>Hi

I'm hoping that somebody can help me with a fairly puzzling problem.

I've created some DataTables which have relations between them e.g. one
to many. In the application, I want to remove entries from the table. To
do this I obviously need to temporarily switch off the relations. In
order to achieve this, I tried:

ds.Relations.Clear() ' where ds is the application DataSet
ds.Tables("table1").Clear()

but I get the exception:

"An unhandled exception of type 'System.ArgumentException' occurred in
system.data.dll
Additional information: Cannot remove unique constraint 'Constraint1'.
Remove foreign key constraint table1_table3' first."

What I don't understand is why the relations don't seem to have been
removed.

Can anybody point me in the right direction i.e. how do I switch off the
relations to allow the clearing of a table?

Many thanks in advance

Geoff