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
