RE: Update field value

2009-03-30 Thread Jim Harvey
To: 'ProFox Email List' Subject: Update field value I'd like to update a field value by allowing the user to click a button that has a value as it's caption. There will be multiple buttons each with its own distinct value. I can put code in the click of each button knowing it's assigned value

Re: Update field value

2009-03-30 Thread Stephen Russell
On Mon, Mar 30, 2009 at 10:35 AM, Jim Harvey jhar...@hanoverpa.com wrote: I ended up creating a form property, and then in each button's click I assigned the value of the caption of each button and called the method. thisform.r_bid = VAL(This.Caption) thisform.m_bb In the method I used the

Update field value

2009-03-26 Thread Jim Harvey
I'd like to update a field value by allowing the user to click a button that has a value as it's caption. There will be multiple buttons each with its own distinct value. I can put code in the click of each button knowing it's assigned value, and that will do the job, but would rather use a form

Re: Update field value

2009-03-26 Thread Vince Teachout
Jim Harvey wrote: I'd like to update a field value by allowing the user to click a button that has a value as it's caption. There will be multiple buttons each with its own distinct value. I can put code in the click of each button knowing it's assigned value, and that will do the job,

Re: Update field value

2009-03-26 Thread Stephen Russell
On Thu, Mar 26, 2009 at 1:22 PM, Jim Harvey jhar...@hanoverpa.com wrote: I'd like to update a field value by allowing the user to click a button that has a value as it's caption. There will be multiple buttons each with its own distinct value. I can put code in the click of each button

Re: Update field value

2009-03-26 Thread MB Software Solutions General Account
Vince Teachout wrote: Jim Harvey wrote: I'd like to update a field value by allowing the user to click a button that has a value as it's caption. There will be multiple buttons each with its own distinct value. I can put code in the click of each button knowing it's assigned value, and

Re: Update field value

2009-03-26 Thread Vince Teachout
MB Software Solutions General Account wrote: Vince -- you meant ThisForm.MyMethod(this) (...not just the name attribute, but the actual object) right? No, in my example (again, assuming I understood the question) only a property that can be tested by a CASE statement needs to be passed. So

Re: Update field value

2009-03-26 Thread Fred Taylor
On Thu, Mar 26, 2009 at 12:29 PM, Vince Teachout tea...@taconic.net wrote: MB Software Solutions General Account wrote: Vince -- you meant ThisForm.MyMethod(this) (...not just the name attribute, but the actual object) right? No, in my example (again, assuming I understood the question)

Re: Update field value

2009-03-26 Thread MB Software Solutions General Account
Vince Teachout wrote: No, in my example (again, assuming I understood the question) only a property that can be tested by a CASE statement needs to be passed. So if the Button name was ButtVal1, the click method Thisform.MyMethod(this.name) would send the parm ButtVal1 to the method, and a

Re: Update field value

2009-03-26 Thread MB Software Solutions General Account
Fred Taylor wrote: So why not pass this? You can then reference the button.Caption (or any other property) directly and not need any CASE statement. -- Fred My point exactly. ___ Post Messages to: ProFox@leafe.com Subscription Maintenance:

Re: Update field value

2009-03-26 Thread Vince Teachout
Fred Taylor wrote: On Thu, Mar 26, 2009 at 12:29 PM, Vince Teachout tea...@taconic.net wrote: So why not pass this? You can then reference the button.Caption (or any other property) directly and not need any CASE statement. In this example, how does it eliminate the need for CASE? Again,

RE: Update field value

2009-03-26 Thread Tracy Pearson
Going back to the original request: I'd like to update a field value by allowing the user to click a button that has a value as it's caption. Would result with: UPDATE bidboard SET amount = val(oButton.Caption) -Original Message- From: Vince Teachout Sent: Thursday, March 26,

Re: Update field value

2009-03-26 Thread Vince Teachout
Tracy Pearson wrote: Going back to the original request: I'd like to update a field value by allowing the user to click a button that has a value as it's caption. Would result with: UPDATE bidboard SET amount = val(oButton.Caption) Or, again, within a form method, which was my

Re: Update field value

2009-03-26 Thread Vince Teachout
Tracy Pearson wrote: Going back to the original request: I'm going to chalk this one up to I rushed through original e-mail, didn't understand the actual problem, and don't care enough to look up the original on the archives. Especially since the actual problem seems to have been solved.

Re: Update field value

2009-03-26 Thread KAM.covad
buttons. No need to change click() Depending on your values, you could make that the caption and pass this.caption so you do not need to modify the button names - Original Message - From: Vince Teachout To: ProFox Email List Sent: Thursday, March 26, 2009 10:25 AM Subject: Re: Update field

RE: Update field value

2009-03-26 Thread Profox
Or tomayto Al -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of MB Software Solutions General Account Sent: 26 March 2009 21:37 To: profoxt...@leafe.com Subject: Re: Update field value Vince Teachout wrote: Tomato, TaMahto