September 25th, 2003, 04:02 PM
|
|
Contributing User
|
|
Join Date: Sep 2003
Location: Montreal, Canada
Posts: 486
Time spent in forums: 3 h 52 m 20 sec
Reputation Power: 10
|
|
Deleting an adress in a table ?
Hi,
Can someone help me here ! I want to delete a row in a table.
The table have 2 primary key. I mean it's 2 foreign key that make 1 primary. I hope you understand what I mean. It's a combination of 2 property to make a primary.
It's a program in Vb.Net where I need to delete one row in this table. I am using a SQL request to do it
Code:
Delete adresse where (norue = '" + _
OleDataR.Item("norue") + "' and (noreleve = " + _
"(select noreleve from releve where codeprojet = '" + _
NoReleve + "'))
but it's not working ! It's telling me that I can't delete a row by doing a AND ! why ? is there anyother way to do it? I can't delete it by using only 1 property, cause more then 1 row can have the same property. That's why I use 2 foreign key to make the primary key.
Can someone help me ?
thank you
__________________
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
