Hi Jennifer, You might try adding t1 in front of the names without a table designation as in: Update clients set t1.status = t2.status, t1.casemanager = t2.casemanager
Bernie Lis ----- Original Message ----- From: Roberts, Jennifer To: RBASE-L Mailing List Sent: Friday, November 28, 2008 3:10 PM Subject: [RBASE-L] - RE: Advice please... I have tried working this out when by using a temp table and then once confirmed all the data is there that is required, I want to now update the permanent table. Everything works great until the update. Are there any restrictions on updating from a temp table? These tables have a lot of information. My syntax looks like this, except for I'm updating every column instead of just two: Update clients set status = t2.status, casemanager = t2.casemanager + From clients t1, tclients t2 + Where t2.client# = t1.client# Thanks. From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Dan Goldberg Sent: Wednesday, November 26, 2008 5:02 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Advice please... You could hide the tab until all the fields are filled in. PROPERTY <ComponentID> TABVISIBLE 'FALSE' Dan Goldberg ------------------------------------------------------------------------------ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Roberts, Jennifer Sent: Wednesday, November 26, 2008 11:29 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Advice please... Hello all, I am working with Rbase version 7.6.5.3.1125, and I have a form with an enhanced tab control. The first tab shows client information, and one of the fields pertaining to a client is their status. I want to force the user to have to fill in other fields if the status is active, however I don't want the user to have to fill in those other fields if the status is monitor, inquiry or close. I would normally check for these things through an eep on a push button. However, when the user switches to another tab, the record saves. I have tried to create a trigger, but it rolls back all the changes and I haven't been able to stop it from going to the next tab before checking. The eep on the tab change only fires when going back to the tab and not when leaving the tab, so that doesn't work. Should I try a rule in the table? I was not able to find much information on rules to know whether this would work. Or should I recreate this form and not use the enhanced tab control. Any ideas??? Thank you and wishing all of you a Happy Thanksgiving. J Jennifer Roberts Business Applications Specialist Ohio Masonic Home 937.525.3080 x5788 This electronic message contains information from The Ohio Masonic Home, its operating subsidiaries or affiliates. The information may be confidential, privileged or otherwise protected from disclosure. The information is intended to be received solely by [email protected], for use as designated in the message. If you are not the designated recipient, you are instructed not to review, disclose, copy, distribute or otherwise use of this transmission or its contents. If you have received this transmission in error, please notify The Ohio Masonic Home immediately at [EMAIL PROTECTED]; in addition, please delete your record of transmission. Sending, receiving, downloading, displaying, printing material that is harassing, fraudulent, offensive, intimidating, defamatory, or otherwise unlawful or inappropriate is strictly prohibited by The Ohio Masonic Home. This electronic message contains information from The Ohio Masonic Home, its operating subsidiaries or affiliates. The information may be confidential, privileged or otherwise protected from disclosure. The information is intended to be received solely by [email protected], for use as designated in the message. If you are not the designated recipient, you are instructed not to review, disclose, copy, distribute or otherwise use of this transmission or its contents. If you have received this transmission in error, please notify The Ohio Masonic Home immediately at [EMAIL PROTECTED]; in addition, please delete your record of transmission. Sending, receiving, downloading, displaying, printing material that is harassing, fraudulent, offensive, intimidating, defamatory, or otherwise unlawful or inappropriate is strictly prohibited by The Ohio Masonic Home.
