Gossamer Forum
(Advanced Search)
for
Home : Products : DBMan SQL : Discussion :

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

Aug 13, 2002, 1:10 PM
Reena0330
User (106 posts)
Aug 13, 2002, 1:10 PM
Views: 4651
Shortcut
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 4819 Aug 8, 2002, 3:28 PM
Thread Re: [Reena0330] "Owner" select field can only be changed to self 		jean 4652 Aug 12, 2002, 11:57 AM
Post Re: [jean] "Owner" select field can only be changed to self 		Reena0330 4652 Aug 12, 2002, 1:29 PM
Post Re: [jean] "Owner" select field can only be changed to self 		Reena0330 4651 Aug 13, 2002, 1:10 PM
Thread Re: [Reena0330] "Owner" select field can only be changed to self 		604 4649 Aug 13, 2002, 3:47 PM
Post Re: [TheStone] "Owner" select field can only be changed to self 		Reena0330 4634 Aug 15, 2002, 1:03 PM