Albert,
Thanks, but I always use formatted. Its' really weird. I have another choose with lots of LJS from a temporary view and it works fine, but this one view has a UNION operator. I don't know what is going on, but It has me baffled. I did notice that it's ok with only ONE LJS. I can have all the RJS I want with no problem. For each additional LJS, I get an extra line where there is no data but from the union data (which are times - 7:00, 7:15, 7:30, etc.). I have worked this every which way and am totally frustrated, so I now have an "ugly" choose....maybe RBTI can help next week....
Thanks for responding , though,
Bob C
| Albert Berry <[EMAIL PROTECTED]>
Sent by: [email protected] 06/26/2005 02:29 AM
|
|
Bob, slip a FORMATTED into your CHOOSE command. That might get rid of the extra lines.
--- Bob Castanaro <[EMAIL PROTECTED]> wrote:
> 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: [email protected]
> 06/25/2005 02:23 PM
> Please respond to
> [email protected]
>
>
> To
> [email protected] (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]
>
>
>
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]
