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
