James,
Hmmm...a NOTE data type. this may or may not be compunding the problem. I would like to post the code and graphic examples, but I don't know if we can post html on the list here.
All I know at this point is that my experimanting has indicated that LJS doesn't work right and RJS does. It doesn't make a lot of sense....
BobC
| James Bentley <[EMAIL PROTECTED]>
Sent by: [email protected] 06/26/2005 02:52 PM
|
|
BobC,
One of the quirks about using UNION in a view is that
the column data type is taken from the first select
statement. Also if you use any function on the column
selected RBase uses a NOTE data type. In many cases
the data type RBase selects is not what you expected.
Also you might want to make use of the FORMAT function
in lieu of LJS and CTXT functions.
If you post you code to the list perhaps one of us can
spot your problem. Also have you RSTYLED your created
code.
--- Bob Castanaro <[EMAIL PROTECTED]> wrote:
> 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
> Please respond to
> [email protected]
>
>
> To
> [email protected] (RBG7-L Mailing List)
> cc
>
> Subject
> [RBG7-L] - Re: What form object to use?
>
>
>
>
>
>
> 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]
> >
> >
> >
>
>
>
=== message truncated ===
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
