how to do this => SET a row by default

• bernardchristophe

  Old Hand

  Points: 366

  More actions

  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

• Atif-ullah Sheikh

  SSChampion

  Points: 12495

  More actions

  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]

• Eugene Elutin

  SSC Guru

  Points: 59322

  More actions

  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]