Gossamer Forum
Home : Products : DBMan SQL : Discussion :

Re: [jean] "Owner" select field can only be changed to self

Quote Reply
Re: [jean] "Owner" select field can only be changed to self In reply to
Hi Jean,

Here are the conditions for the "owner" field and when it can or cannot be modified:

- if "owner" field modified to "Username" then OKAY

- if "owner" field modified to anything other than "Username" then ERROR MESSAGE

- if "owner" field not modified and is set to something other than "Username" then okay.



I think the last case is the most complicated because if the "owner" field is not modified and is set to soething othe than the "Username" then an error message should NOT be displayed. But how can the database tell if the "owner" field has been modified or not? I tried the code that you gave me, but it didn't do anything. I was still able to transfer ownership to another user. Any help would be great Unsure
Reena
Subject Author Views Date
Thread "Owner" select field can only be changed to self Reena0330 3173 Aug 8, 2002, 3:28 PM
Thread Re: [Reena0330] "Owner" select field can only be changed to self
jean 3063 Aug 12, 2002, 11:57 AM
Post Re: [jean] "Owner" select field can only be changed to self
Reena0330 3064 Aug 12, 2002, 1:29 PM
Post Re: [jean] "Owner" select field can only be changed to self
Reena0330 3050 Aug 13, 2002, 1:10 PM
Thread Re: [Reena0330] "Owner" select field can only be changed to self
604 3043 Aug 13, 2002, 3:47 PM
Post Re: [TheStone] "Owner" select field can only be changed to self
Reena0330 3029 Aug 15, 2002, 1:03 PM