Hi Ben
Thats the strange thing there are no views bur R:BASE create one from a
table called
waiting.
Regards
Victor
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
> Behalf Of Ben Petersen
> Sent: Sunday, 7 April 2002 7:11 AM
> To: [EMAIL PROTECTED]
> Subject: RE: Bug?
>
>
> 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/
>
================================================
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/
