Post reply

how to do this => SET a row by default

  • May 20, 2010 at 2:49 am

    #156970

    Hi all,

    i have a simple table with this field :

    - nomFR => varchar(200)

    - nomEN => varchar(200)

    - default => bit

    people can add, edit and delete rows

    the problem is follow :

    i must to have every time a row set to true

    if people enter the first row and defaut is 0 => defaut must be 1

    if people enter other row and set to defaut 1 => i must to reset other to 0

    if people delete a row who is set to defaut => i must to set defaut the old row

    i'm a beginner how to do that !?

    thanks for your comment and suffestion and sample !

    Thanks for all

    Christophe

  • May 20, 2010 at 3:55 am

    #1169967

    Is there any userID so that you can identify which user is adding/updating/Deleting a row from his/her own pool? I think it should be done on the basis of atleast one column. If No, then how will you identify who is adding/deleting/updating?

    ----------------------------------------------------------------------------------------------------------------------------------------------------------------------
    Sometimes, winning is not an issue but trying.
    You can check my BLOG     [font="Arial Black"]here[/font][/url][/right]

  • May 20, 2010 at 6:03 am

    #1170035

    Sorry, can not help here.

    Please provide create table and data insert script plus better explanation of expected results (as list of desired data in the table after the insert/update/delete action)

    Cheers

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply