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.Cl ear() ' where ds is the application DataSet
ds.Tables("tabl e1").Clear()

but I get the exception:

"An unhandled exception of type 'System.Argumen tException' 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.C lear() ' where ds is the application DataSet
ds.Tables("tab le1").Clear()

but I get the exception:

"An unhandled exception of type 'System.Argumen tException' occurred in
system.data.dl l
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.Cl ear() ' where ds is the application DataSet
ds.Tables("tabl e1").Clear()

but I get the exception:

"An unhandled exception of type 'System.Argumen tException' 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*******@gmai l.comwrote in message
news:c7******** *************** ***@news.micros oft.com...

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.C lear() ' where ds is the application DataSet
ds.Tables("tab le1").Clear()

but I get the exception:

"An unhandled exception of type 'System.Argumen tException' occurred in
system.data.dl l
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**@technetce nter.comwrote in message
news:oO******** *********@bigne ws4.bellsouth.n et...

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("ta ble1").Clear()

but I get the exception:

"An unhandled exception of type 'System.Argumen tException' occurred in
system.data.d ll
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("Tabl e1").Constraint s.Clear()

Thanks in advance

Geoff

"G .Net" <no********@ema il.comwrote in message
news:hp******** *************** *******@pipex.n et...

Hi T

Could you tell me how to remove the indexes?

Geoff

"tomb" <to**@technetce nter.comwrote in message
news:oO******** *********@bigne ws4.bellsouth.n et...

>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("t able1").Clear()

but I get the exception:

"An unhandled exception of type 'System.Argumen tException' 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