Normal Topic Mass Update radio button (Read 1001 times)
obfusc88
Full Member
***
Offline


No personal text

Posts: 194
Joined: Dec 17th, 2005
Mass Update radio button
Mar 3rd, 2006 at 3:45pm
Print Post Print Post  
I created a Radio Button group with two buttons
Group name is CurrentData
One button name is "Q&A" and one is "SESAME" (without quotes)

Just imported 6000 Q&A records and want to Mass Update all these records to have "Q&A" value selected.

Did Mass Update in CurrentData element:
CurrentData = "Q&A"

Run Mass Update on 6000 records, but when all done, both choices are still inactive.

What did I forget to do?
  
Back to top
 
IP Logged
 
Ray the Reaper
Global Moderator
Members
Lantica Support
*****
Offline


The One & The Only

Posts: 2482
Joined: Aug 20th, 2003
Re: Mass Update radio button
Reply #1 - Mar 3rd, 2006 at 3:56pm
Print Post Print Post  
Hello,

The Mass Update has to set the value of CurrentData to the Label of the Radio Button you want selected.

If your Radio button Label shows up as "Q&A" then it's label is actually "Q&&A"

So your Mass Update would be

Code
Select All
CurrentData = "Q&&A" 



-Ray
  

Raymond Yoxall Consulting
ray.yoxall@gmail.com
ryoxall@lantica.com
Sesame Applications, Design and Support
Back to top
IP Logged
 
Bob_Hansen
Senior Member
Members
*****
Offline


WOW, They have the Internet
on computers now!

Posts: 1861
Location: Salem, NH
Joined: Nov 24th, 2002
Re: Mass Update radio button
Reply #2 - Mar 3rd, 2006 at 4:06pm
Print Post Print Post  
If your button name is "Q&A" then your label definition is probably "Q&&A".  Change the Mass Update spec to match the label definition, not the name.

Code
Select All
CurrentData = "Q&&A" 

  



Bob Hansen
Sesame Database Manager Professional
Sensible Solutions Inc.
Salem, NH
603-898-8223
Skype ID = sensiblesolutions
Back to top
IP Logged
 
Bob_Hansen
Senior Member
Members
*****
Offline


WOW, They have the Internet
on computers now!

Posts: 1861
Location: Salem, NH
Joined: Nov 24th, 2002
Re: Mass Update radio button
Reply #3 - Mar 3rd, 2006 at 4:09pm
Print Post Print Post  
Grin
Well Done Ray!

I was responding to obfusc88 and answered phone call.  That allowed you to jump in ahead of me with a great answer.  I guess I will need to turn off the phone to provide timely response.  Grin
  



Bob Hansen
Sesame Database Manager Professional
Sensible Solutions Inc.
Salem, NH
603-898-8223
Skype ID = sensiblesolutions
Back to top
IP Logged
 
obfusc88
Full Member
***
Offline


No personal text

Posts: 194
Joined: Dec 17th, 2005
Re: Mass Update radio button
Reply #4 - Mar 3rd, 2006 at 4:31pm
Print Post Print Post  
Wow..two identical responses in less than one half hour.  Support is terrific.

You were both correct, when I changed to "Q&&A" it worked.  Thanksalot.

But now I notice when i single step through the records using the mouse on navigation arrows, some records flicker on "Sesame" before settling on "Q&A"  There is no programming that affects the Radio Group, and value does settle on "Q&A". 

Quickly clicking makes it appear that some records have value of "Sesame", but really have "Q&A"  Is this normal, do I have to live with this?
  
Back to top
 
IP Logged
 
Ray the Reaper
Global Moderator
Members
Lantica Support
*****
Offline


The One & The Only

Posts: 2482
Joined: Aug 20th, 2003
Re: Mass Update radio button
Reply #5 - Mar 3rd, 2006 at 4:51pm
Print Post Print Post  
Hello,

Is the Initial Value of the Radio Button Group set to "Sesame"? That would cause this quick flash.

-Ray
  

Raymond Yoxall Consulting
ray.yoxall@gmail.com
ryoxall@lantica.com
Sesame Applications, Design and Support
Back to top
IP Logged
 
obfusc88
Full Member
***
Offline


No personal text

Posts: 194
Joined: Dec 17th, 2005
Re: Mass Update radio button
Reply #6 - Mar 3rd, 2006 at 6:57pm
Print Post Print Post  
Yes, initial Value is "Sesame".  But I need to keep that for new records.  Does that mean I should use programming to set CurrentData if @NEW instead of using Initial value?
  
Back to top
 
IP Logged
 
Ray the Reaper
Global Moderator
Members
Lantica Support
*****
Offline


The One & The Only

Posts: 2482
Joined: Aug 20th, 2003
Re: Mass Update radio button
Reply #7 - Mar 3rd, 2006 at 7:02pm
Print Post Print Post  
Hello,

If you do not want to see the quick flash of the Sesame Radio Button being set, then Yes you will want to program the CurrentData to be set using @IsNew() and remove the initial value.

-Ray
  

Raymond Yoxall Consulting
ray.yoxall@gmail.com
ryoxall@lantica.com
Sesame Applications, Design and Support
Back to top
IP Logged