David, if you create a temp table with the columns typed as you want,
but leave it empty, you can use it as the first table in the view, and
that will define the column types for you in your view. An example of
this is when you combine text columns in a view they usually come out as
NOTE.
CREATE VIEW empFullName (EmpID, FullName) AS +
SELECT EmpID, (fName & lName) from employees
To resolve this issue,
CREATE TEMP TABLE tmpFullName ( +
EmpID INTEGER, +
FullName TEXT (100) )
CREATE VIEW empFullName (EmpID, FullName) AS +
SELECT EmpID, FullName FROM tmpFullName +
UNION +
SELECT EmpID, (fName & lName) from employees
Albert
David Blocker wrote:
Alastair
An interesting idea. To do that however, I?d have to handle this with
a temporary table, right? Then insert the SELECT into the temp
table? Or is there a way in a VIEW definition to set column types
that I?m not aware of? I thought R:Base would normally follow the
column type of the original column.
David
--- RBASE-L
================================================
TO POST A MESSAGE TO ALL MEMBERS:
Send a plain text email to [email protected]
(Don't use any of these words as your Subject:
INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH,
REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP)
================================================
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: INTRO
================================================
TO UNSUBSCRIBE:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: UNSUBSCRIBE
================================================
TO SEARCH ARCHIVES:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: SEARCH-n
(where n is the number of days). In the message body,
place any
text to search for.
================================================
