David I seem to recall someone at the conference that was using & instead of . in front of there vars in the property command. I would hurt to try anyway. Its either going to work or not.
On 4 Jan 2005 at 14:01, David M. Blocker wrote: > Victor > > You're right- that's a typo in the email, not the program. This part of the > program works FINE - its the PROPERTY componentid TEXTVALUE .varname part > that's failing. > > David Blocker > [EMAIL PROTECTED] > 781-784-1919 > Fax: 781-784-1860 > Cell: 339-206-0261 > ----- Original Message ----- > From: "Victor Timmons" <[EMAIL PROTECTED]> > To: "RBG7-L Mailing List" <[email protected]> > Sent: Tuesday, January 04, 2005 12:00 PM > Subject: [RBG7-L] - Re: PROPERTY ComponentID TEXTVALUE .varname problems > > > On 4 Jan 2005 at 8:48, David M. Blocker wrote: > I think > GETPROPERTY CustState TEXTVALUE 'eCustState' > GETPROPERTY ModLevel TEXTVALUE 'eModLeve'l > should be > GETPROPERTY CustState TEXTVALUE eCustState > GETPROPERTY ModLevel TEXTVALUE eModLevel > > > > > > > > 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 > > > > > > > > Victor Timmons > Tiz's Door Sales, Inc > 425-258-2391 > > Victor Timmons Tiz's Door Sales, Inc 425-258-2391
