Dave: You have mail with good news... Javier, Javier Valencia, PE President Valencia Technology Group, L.L.C. 14315 S. Twilight Ln, Suite #14 Olathe, Kansas 66062-4578 Office (913)829-0888 Fax (913)649-2904 Cell (913)915-3137 ================================================ Attention: The information contained in this message and or attachments is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from all system and destroy all copies. ======================================================
-----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] Behalf Of David M. Blocker Sent: Tuesday, January 04, 2005 1:00 PM To: RBG7-L Mailing List Subject: [RBG7-L] - RE: PROPERTY ComponentID TEXTVALUE .varname problems Javier I did try your ideas right away - did not do the trick and were not necessary in the other case. If I don't get any ideas in a day I'll send it to you and to RBTI and see what we get! David David Blocker [EMAIL PROTECTED] 781-784-1919 Fax: 781-784-1860 Cell: 339-206-0261 ----- Original Message ----- From: "Javier Valencia" <[EMAIL PROTECTED]> To: "RBG7-L Mailing List" <[email protected]> Sent: Tuesday, January 04, 2005 11:40 AM Subject: [RBG7-L] - RE: PROPERTY ComponentID TEXTVALUE .varname problems > David: > When I modify the value of the current record, I use: > PROPERTY TABLE your_table_name 'REFRESH' > PROPERTY FORM your_form_name 'REFRESH' > You might want to give it a try and see if it works for you. If not, backup > the form and e-mail it to me with instructions and I will try to duplicate > it locally. > Javier, > > Javier Valencia, PE > President > Valencia Technology Group, L.L.C. > 14315 S. Twilight Ln, Suite #14 > Olathe, Kansas 66062-4578 > Office (913)829-0888 > Fax (913)649-2904 > Cell (913)915-3137 > ================================================ > Attention: > The information contained in this message and or attachments is intended > only for the person or entity to which it is addressed and may contain > confidential and/or privileged material. Any review, retransmission, > dissemination or other use of, or taking of any action in reliance upon, > this information by persons or entities other than the intended recipient > is prohibited. If you received this in error, please contact the sender and > delete the material from all system and destroy all copies. > ====================================================== > > -----Original Message----- > From: [email protected] [mailto:[EMAIL PROTECTED] Behalf Of David M. > Blocker > Sent: Tuesday, January 04, 2005 7:49 AM > To: RBG7-L Mailing List > Subject: [RBG7-L] - PROPERTY ComponentID TEXTVALUE .varname problems > > Hi R:Base buddies > > I posted this new year's day and have gotten no response- so I'm trying > again! There are some simple steps below to try with CONCOMP to confirm the > problem or show me what I'm mssing. > > I'm beginning to think I've gone a little mad here. I have a working example > in a database of using the PROPERTY component TEXTVALUE .varname command to > change the value of a column on entry. I can't for the life of me see what > 's different about that working example from the one I'm trying to create > other than one is run from a button and another from a DBEdit control "On > exit", but even if I try it from a button it won't go. > > The working example has this relevant set of code (form is called with > ENTER): > > SET NULL ' ' > PROPERTY TABLE Invoice 'EDIT' > PROPERTY PONO TEXTVALUE .fSearchFor > RECALC VARIABLES > > It works like a charm. Notice NO SAVEROW command is needed to make it work. > > Just in case it's some wierdness in my database, I'm trying first to get > this to work on CONCOMP and can't. I'd love it if someone can replicate this > for me to see if I'm dreaming. Try these steps (either build 78 or 79) > > 1. Modify form Concomp > 2. Create this custom EEP for field CustState ON EXIT: > > SET VAR eCustState TEXT = NULL > SET VAR eDefState TEXT = NULL > SET VAR eDefState = 'MA' > GETPROPERTY CustState TEXTVALUE 'eCustState' > IF eCustState IS NOT NULL THEN > GOTO BOTTOM > ENDIF > PROPERTY TABLE Customer 'EDIT' > PROPERTY CustState TEXTVALUE .eDefState > SAVEROW > LABEL BOTTOM > CLE VAR eCustState,eDefState > RETURN > > 3. And create this custom EEP for field ModLevel ON EXIT: > > SET VAR eModLevel INTEGER = NULL > SET VAR eDefMod INTEGER = NULL > SET VAR eDefMod = 1 > GETPROPERTY ModLevel TEXTVALUE 'eModLeve'l > IF eModLevel IS NOT NULL THEN > GOTO BOTTOM > ENDIF > PROPERTY TABLE Customer 'EDIT' > PROPERTY ModLevel TEXTVALUE .eDefMod > SAVEROW > LABEL BOTTOM > CLE VAR eModLevel,eDefMod > RETURN > > 4. Save the form > > 5. ENTER USING CustomerEnter > 6. Leave CustState blank - it does NOT change to MA > 7. Leave ModLevel blank - it does NOT change to 1 > > The NULL setting makes no difference. > > Change SAVEROW to RECALC VARIABLES - neither one makes a difference. > > My working example is an INTEGER column and variable, so I tried both here - > one text column and one integer. Makes no difference. The GETPROPERTY > commands are working fine - trace shows that. I get no error when tracing > the PROPERTY .. TEXTVALUE commands, but they don't work - no value appears > on the form or is saved in the row. > > I have the same problem using Build 78 or the beta of 79. It occurs on both > my portable and desktop, both running Windows XP. > > I added a lookup expression to the form from a new States table in the > hopes that that would force a recalc variables to work, but it did not help. > > Can anyone replicate this problem or show me the error of my ways? I'm > guessing it's a big DUH but I can't see it! > > David Blocker > [EMAIL PROTECTED] > 781-784-1919 > Fax: 781-784-1860 > Cell: 339-206-0261 >
