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

[David M. Blocker]

We look forward to hearing from you, Bob   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: Monday, June 27, 2005 4:59 PM Subject: [RBG7-L] - Re: What form object to use? 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: rbg7-l@rbase.com 06/27/2005 03:58 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, 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: rbg7-l@rbase.com > 06/26/2005 02:52 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? > > > > > > > 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: rbg7-l@rbase.com > > 06/26/2005 02:29 AM > > 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, 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: 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: > === message truncated === __________________________________________________ Do You Yahoo!? Tired of spam?  Yahoo! Mail has the best spam protection around http://mail.yahoo.com