[RBG7-L] - Re: What form object to use?

[David M. Blocker]

Bob   I hope you'll share what you learn from this.  None of us like to see an unresolved issue!  I'm sure RBTI will be able to help you and if you share what you learn, we will all be helped in the long run.   David   David Blocker [EMAIL PROTECTED] 781-784-1919 Fax: 781-784-1860 Cell: 339-206-0261 ----- Original Message ----- From: Bob Castanaro To: RBG7-L Mailing List Sent: Saturday, June 25, 2005 11:50 PM Subject: [RBG7-L] - Re: What form object to use? Albert, I actually am getting this data from a view.  I just want to load specific rows into a cobo box or list box or some sort of object in a form where I can control the location.  I looked at the example Razzak directed me to but I couldn't make it work with my database.  So basically I am stuck using a choose from an eep in a form, which is OK for now.  Now I have a bigger problem.  The selection from that choose then triggers a temporary view.  This view is pretty exotic and contains some slick union operator and works well in DOS.  BUT......  Now I find when I write a choose for it and have the _expression_ with multiple LJS functions, It stars skipping lines in between data rows. Grrrr.  That darn Windows...  I have spent 3 hours on one choose command to no avail.  I'm going to have to send this toi RBTI for advice. thanks for responding BobC Albert Berry <[EMAIL PROTECTED]> Sent by: rbg7-l@rbase.com 06/25/2005 02:23 PM Please respond to rbg7-l@rbase.com To rbg7-l@rbase.com (RBG7-L Mailing List) cc Subject [RBG7-L] - Re: What form object to use? Bob, have you tried creating a view for this? I use views for choose commands all the time, with the view containing exactly two columns. A view for employees for example would be used as follows: SET VAR vCount INTEGER SET VAR vChoice TEXT SET VAR vEmpNo INTEGER SELECT COUNT(*) INTO vCount +  FROM sys_tables +  WHERE sys_table_name = 'vwmEmployees' IF vCount > 0 THEN    DROP VIEW vwmEmployees ENDIF CREATE TEMP VIEW vwmEmployees (Choice,EmpNo) AS +  SELECT (LJS.......),EmpNo FROM Employees +  WHERE someCol = someVar -- then the choose box reduces to this: CHOOSE vChoice FROM #VALUES FOR Choice,EmpNo FROM vwmEmployees --- Bob Castanaro <[EMAIL PROTECTED]> wrote: > Hello all, > > I am trying some experimenting with forms to take the place of a long pile > of code that executes in a specific sequence. > > I have an extravagant choose command that has a few fields and a few > calculations that is based on a view. > I can easily run this in an eep, but I want to display this in a box on > the form, that can change based on the value of a variable.  Tried some of > the variable list boxes and even a variable edit with _expression_. Nothing > seems to give me the desired result. > Here is the spaghetti.... >   > IF .VPROCTYPE = "PAIN MANAGEMENT" OR .VPROCTYPE = "WOUND MANAGEMENT" THEN >   CHOOSE VPROCDATE2 FROM #VALUES FOR + >   ((LJS(DOCTOR,16))+(LJS(OFFDAY,12))+(CTXT(PROCDATE))+" > "+(CTXT(PROCOUNT))),PROCDATE + >   FROM COFFVIEW WHERE PROCTYPE = .VPROCTYPE AND DOCTOR = .VDOCTOR + >   ORDER BY DOCTOR PROCDATE + >   TITLE "Choose Schedule Date, [ESC] for New Date" + >   CAPTION "Scheduled days" + >   LINES 20 FORMATTED OPTION TITLE_FONT_COLOR BLUE|TITLE_BOLD ON > > Any suggetions for the experts out ther??? > > TIA > Bob C. > > BTW, I see Razzak is busy tonight with RC2.  Heck of a way to spend Friday > night! > Albert Berry Management Consultant RR2 - 1252 Ponderosa Drive Sparwood BC, V0B 2G2 Canada (250) 425-5806 (250) 425-7259 (708) 575-3952 (fax) [EMAIL PROTECTED]