Angela
In a SELECT .. UNION command if the two values selected in the same position
in the two selects are not identical, R:Base can't assign a name. You must
do it in the create view command:
> CREATE VIEW `tvqino` (QlNo) AS +
> SELECT T1.QINo as QINo, +
> T1.QIName as QIName FROM QICharter T1 +
> UNION SELECT (' '+qino), ' ' +
> FROM qicharter +
> WHERE qino = .vQINo
David Blocker
----- Original Message -----
From: "Angela Phillips" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, July 18, 2002 2:06 PM
Subject: Code Error
> When we try the following command the columns come up aliased as unnammed.
> What are we doing wrong?
>
> CREATE VIEW `tvqino` AS +
> SELECT T1.QINo as QINo, +
> T1.QIName as QIName FROM QICharter T1 +
> UNION SELECT (' '+qino), ' ' +
> FROM qicharter +
> WHERE qino = .vQINo
>
> Thanks,
> Charlie
> ================================================
> 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/
