Jan,
You are a very patient man. I have sooo much to learn and thing I am learning more than anything else is that I get so close to the answer and miss it by the simple things. I had the variable vpartchoice set in the On Before Design but failed to put it in the On Before Start EEP. Plus I did not have it equal NULL. Once I followed your specific instructions, BINGO! It worked! Thank you very much. I sometimes make things more complicated than they need to be. Really, I think the real problem is my logic is leaking out the grey hairs on my head. Jim ________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of jan johansen Sent: Friday, August 21, 2009 11:36 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: CALCULATIONS WITH VARIABLE LISTVIEW Jim, Normally you would assign a variable for the listview to work with. I normally do this in the form OnBeforeStart eep such as SET VARIABLE vPartChoice TEXT = NULL Then define your listview and make sure it is associated to the variable vPartChoice (you can use listviews without variables but you need to be very familiar with PROPERTY commands). So now if you want to do something with vPartChoice you place in your OnClick eep (or whichever eep you wish) IF vPartChoice IS NOT NULL THEN do what I want here ENDIF This is important because if you don't set up the dimensions on your list view correctly you can clik in a white space in the listview which will fire your eep but the variable is not set. I use listviews every where to do multi-selects, use right click options, display images, etc. They are one the best tools that Razzak and RBTI have given us. Jan -----Original Message----- From: "Jim Belisle" <[email protected]> To: [email protected] (RBASE-L Mailing List) Date: Fri, 21 Aug 2009 11:20:19 -0500 Subject: [RBASE-L] - Re: CALCULATIONS WITH VARIABLE LISTVIEW Karen, I am very unfamiliar with using listviews. I have some working but for some reason I have problems with getting the On Click EEPs to work. Maybe someone can help me understand how the LISTVIEWS work. I name the listview vPartChoice. The primary field is Partnum and the table is Inv_all_open. Does the listview (vPartChoice) take on the value of Partnum? If not then how do I associate to the Partnum field within the Listview (the one that my cursor is on)? If I need to learn the Property or the Get Property commands, then I want to do that. Jim I have looked on the examples in RRBYW14 and have copied them to my system, adapted them and some work. I still need to understand why they work! Jim A lot to learn. ________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of [email protected] Sent: Friday, August 21, 2009 10:33 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: CALCULATIONS WITH VARIABLE LISTVIEW Jim: The following line is invalid syntax. EDIT USING KPRAssyPartGrid WHERE Assembly# = (SELECT Partnum FROM .vPartchoice) ORDER BY Assembly# The problem is what's in your parenthesis. Don't know what your tablename is, but it should be something like this: (SELECT assembly# FROM yourtablename WHERE partnum = .vpartchoice) Are you comparing Assembly# in one table to the same column name in the other table? And the "order by assembly#" seems superfluous since your "edit using" is only going to return one single assembly#. Karen I was thinking along the same line. I could do this by creating a temp table, updating it with the calculated info and then that table would show up on the second form (the first form would be a simple two field form just for the model &quantity). Next I want to have the option for the user to click on the listview row that contains an assembly so they can see the parts that make up the assembly. I have RDOCs but I still am not sure how to use all functions. This listview is called vPartChoice that is based on a table INV_ALL_OPEN. The primary field is Partnum. On right click the EEP states: SET VAR VFormMode = 'EDIT' EDIT USING KPRAssyPartGrid WHERE Assembly# = (SELECT Partnum FROM .vPartchoice) + ORDER BY Assembly# RETURN
