G'day Charlie,
Interesting that you should post this today as last night
Robert and I were working on views with alias names.
I see that your problem has been addressed already but
the following may be useful.
Using the same syntax as you, VB (through Oterro) displays
the column name as a number and R:BASE sees the column name
as the alias.
Here was Robert's equivalent of yours:
CREATE View VW_DriverList AS +
SELECT PS.PersNumb,P.Salutatn,P.Surname, +
P.Salutatn + ' ' + P.Surname AS FullName,P.EntityIDPrsn +
FROM Personnel PS, +
Persons P +
WHERE P.PerState IN(15,16,17) +
AND PS.PersonId = P.PersonId
Here is the syntax (different view) based on the R:BASE
on-line help:
CREATE VIEW `VW_JobDtlSumCCDR` +
(CostCentre,PeriodQty,PeriodCharges) +
AS SELECT CostCentre,SUM(UnitQty),SUM(ExtCrGross) +
FROM `JobDetails` +
WHERE (JobID = (.vJobID) +
AND TranDate BETWEEN (.PRwhval1) AND (.PRwhval2)) +
GROUP BY CostCentre
Note the brackets around the alias names.
Are you are trying to get it to work with Oterro?
If you use the R:BASE on-line syntax VB\Oterro will see
the alias column names as names not numbers.
At 14:06 18/07/02 -0500, you wrote:
>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
Warmest regards,
Tom Grimshaw
coy: Just For You Software
tel: 612 9552 3311
fax: 612 9566 2164
mobile: 0414 675 903
post: PO Box 470 Glebe NSW 2037 Australia
street: 3/66 Wentworth Park Rd Glebe NSW 2037
email: [EMAIL PROTECTED]
web: www.just4usoftware.com.au
"... the control of impulse -- is the first principle of civilization."--
Will Durant,
Pulitzer Prize winning philosopher, writer and historian
the most needed product in the world can be found at
www.thewaytohappiness.org
This email and any files transmitted with it are confidential to the
intended recipient and may be privileged. If you have received this email
inadvertently or you are not the intended recipient, you may not
disseminate, distribute, copy or in any way rely on it. Further, you should
notify the sender immediately and delete the email from your computer.
Whilst we have taken precautions to alert us to the presence of computer
viruses, we cannot guarantee that this email and any files transmitted with
it are free from such viruses.
================================================
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/
