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 >
