#1
  1. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Sep 2003
    Location
    Montreal, Canada
    Posts
    486
    Rep Power
    12

    Question 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
  2. #2
  3. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Sep 2003
    Location
    Brick City, NJ, USA
    Posts
    11
    Rep Power
    0
    Try deleteing using a sub query
  4. #3
  5. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Sep 2003
    Location
    Montreal, Canada
    Posts
    486
    Rep Power
    12
    what do you mean by a sub query ?

    I already have one query in another one ?
    Could you be a little bit more specific ?

    I really don't understand why it's not working.

    I have done some test and I can do a select on it but not a delete
    Code:
    select * from adresse where ( norue = '2777' ) and (noreleve = (select noreleve from releve where codeprojet = 't700'))
    might be the way I use it with vb.net I don't know ! it's just kinda weird.
  6. #4
  7. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Sep 2003
    Location
    Brick City, NJ, USA
    Posts
    11
    Rep Power
    0
    What SQL program are you using? Oracle right?

IMN logo majestic logo threadwatch logo seochat tools logo