James,
I just sent some docs to RBTI to look at . One way or another I will post this within a few days. If they come up with the solution, I will share, If not, I'm hoping someone on the list can give me some clues as to where to look.
Thanks
BobC
| James Bentley <[EMAIL PROTECTED]>
Sent by: [email protected] 06/27/2005 03:58 PM
|
|
Bob,
There is no firm rule about posting HTML messages.
You are encourage not to but aren't forbidden.
I say post away.
JimBentley
American Celiac Society
--- Bob Castanaro <[EMAIL PROTECTED]> wrote:
> 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
> Please respond to
> [email protected]
>
>
> To
> [email protected] (RBG7-L Mailing List)
> cc
>
> Subject
> [RBG7-L] - Re: What form object to use?
>
>
>
>
>
>
> 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:
>
=== message truncated ===
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
