Victor, At the R> do List view viewName
The Definition may give you a clue. Ben Petersen On 6 Apr 2002, at 11:17, Victor Leach wrote: > Hi All > > I am not sure if this related , I am running 6.0a as a doctors surgery > and I have a table call "waiting" , this table is populated by the front > counter > receptionist and in the the doctors room on his PC he can click of the > waiting list table and choose the next patient that comes into his room, > this then brings up the patients file with all their details, > pathology reports, letters , doctors hand written notes, demographic > data etc. > Occasionally , the table gets converted to a view by R:BASE. Its very > infrequent but it > does happen. I can see nothing in my code to make this happen. Its not > a major problem > I just delete the view and load the table back in but it bugs me as I > cannot see what is > going wrong. Maybe the table name waiting is a problem as the word waiting > could be a reserve word in the underlining R:BASE C code. > > Regards > > Victor > > > > > -----Original Message----- > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On > > Behalf Of Bill Downall > > Sent: Friday, 5 April 2002 8:35 AM > > To: [EMAIL PROTECTED] > > Subject: Re: Bug? > > > > > > Stephen, > > > > To explicitly "declare" a data type for an expression in a view > > definition, > > you can use a trick selecting no rows from an unrelated table, then > > selecting the expressions you really want from the real table. > > > > Say you want to define COL1 as a column of type DOUBLE. Look > > around your database for another DOUBLE column. If column frodo in > > table baggins is a type DOUBLE, you could then do this to force the > > column COL1 to have the datatype you desire: > > > > CREATE VIEW viewname (COL1) as + > > SELECT frodo FROM baggins WHERE count = 0 + > > UNION ALL + > > select (FLOAT(textcolname)) FROM tablename > > > > In a series of SELECT queries in a SELECT ... UNION SELECT ... > > series, R:Base uses the first SELECT to determine all datatypes that > > must match in the following queries. > > > > Bill > > > > On Thu, 04 Apr 2002 16:27:08 -0500, James (Jim) Bentley wrote: > > > > > > >Stephen, > > > > > >Strange as it may seem "COL1" may not be what you think it > > >is. If you defined the view: > > >CREATE VIEW viewname (COL1) as select (FLOAT(textcolname)) > > >FROM tablename > > > > > >Rbase may think the column type for COL1 is NOTE. When you > > >create views with columns that have an expression many times > > >rbase will record that datatype as NOTE. > > > > > >-- > > >Jim Bentley > > >American Celiac Society > > >[EMAIL PROTECTED] - email > > >(973) 325-8837 voice > > >(973) 669-8808 Fax > > > > > > > > >---- "Stephen Markson" <[EMAIL PROTECTED]> wrote: > > >> Before I report this to RDCC can someone please help to > > >> verify the > > >> following bug(?): > > >> > > >> A view column, Col1, is defined as FLOAT() of a TEXT table > > >> column. > > >> Pressing F3 and checking the columns in the view reveals > > >> that Col1 is of > > >> type DOUBLE, as it should be. > > >> > > >> However, when Col1 is used in an expression such as SELECT > > >> (Col1 - 0.0) > > >> FROM ViewName, error message #2151 appears: -ERROR- TEXT > > >> cannot be > > >> subtracted by DOUBLE. > > >> > > >> In other words, RBase still thinks col1 is a TEXT type, > > >> even though it > > >> lists as and displays floating point values. > > >> > > >> Try this: > > >> > > >> CREATE TEMPORARY TABLE temp (col1 TEXT 8) > > >> LOAD temp > > >> NONUM > > >> '123456' > > >> '234567' > > >> '345678' > > >> '123' > > >> '322' > > >> '52' > > >> '622' > > >> '67222' > > >> END > > >> CREATE TEMPORARY VIEW tempv (col1) AS SELECT (FLOAT > > (col1)) > > >> FROM temp > > >> SELECT col1 FROM tempv > > >> SELECT (col1-0.7) FROM tempv > > >> > > >> The first SELECT lists all the values with their decimal > > >> points. > > >> > > >> The second SELECT generates the error. > > >> > > >> Does anyone else get the error? > > >> > > >> NOTE: the problem does NOT occur with the INT function > > >> in the view. > > >> > > >> Workaround appears to be to not use FLOAT in view definitions. > > >> Use FLOAT > > >> in the subsequent expressions. For example, if you wanted > > >> to parse out a > > >> REAL value from a text column, the view definition would > > >> do the parsing, > > >> but the FLOAT should be done when it's needed: > > >> > > >> CREATE TEMPORARY VIEW tempv (col1) AS SELECT (SGET > > (col1,2,1)) > > >> FROM temp > > >> SELECT (FLOAT(col1)-0.7)) FROM tempv > > >> > > >> That works. > > >> > > >> Thanks for your assistance. > > >> > > >> > > >> Regards, > > >> > > >> Stephen Markson > > >> ForenSys The Forensic Systems Group > > >> www.ForensicSystemsGroup.com > > >> 416 482 2140 > > >> > > >> > > >> ================================================ > > >> TO SEE MESSAGE POSTING GUIDELINES: > > >> Send a plain text email to [EMAIL PROTECTED] > > >> In the message body, put just two words: INTRO rbase-l > > >> ================================================ > > >> TO UNSUBSCRIBE: send a plain text email to > > [EMAIL PROTECTED] > > >> In the message body, put just two words: UNSUBSCRIBE rbase-l > > >> ================================================ > > >> TO SEARCH ARCHIVES: > > >> http://www.mail-archive.com/rbase-l%40sonetmail.com/ > > >> > > >================================================ > > >TO SEE MESSAGE POSTING GUIDELINES: > > >Send a plain text email to [EMAIL PROTECTED] > > >In the message body, put just two words: INTRO rbase-l > > >================================================ > > >TO UNSUBSCRIBE: send a plain text email to > > [EMAIL PROTECTED] > > >In the message body, put just two words: UNSUBSCRIBE rbase-l > > >================================================ > > >TO SEARCH ARCHIVES: > > >http://www.mail-archive.com/rbase-l%40sonetmail.com/ > > > > > > > > > > > > > ================================================ > > TO SEE MESSAGE POSTING GUIDELINES: > > Send a plain text email to [EMAIL PROTECTED] > > In the message body, put just two words: INTRO rbase-l > > ================================================ > > TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] > > In the message body, put just two words: UNSUBSCRIBE rbase-l > > ================================================ > > TO SEARCH ARCHIVES: > > http://www.mail-archive.com/rbase-l%40sonetmail.com/ > > > > ================================================ > TO SEE MESSAGE POSTING GUIDELINES: > Send a plain text email to [EMAIL PROTECTED] > In the message body, put just two words: INTRO rbase-l > ================================================ > TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] > In the message body, put just two words: UNSUBSCRIBE rbase-l > ================================================ > TO SEARCH ARCHIVES: > http://www.mail-archive.com/rbase-l%40sonetmail.com/ > ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
