[RBG7-L] - Re: How to force a text expression to be type TEXT in a view

[Bill Downall]

Larry,

R:Base determines the data type from the first SELECT in the view definition, so do 
this:

CREATE VIEW LarrysView +
(PartInfo) +
AS +
SELECT Sys_Table_Name FROM Sys_Tables +
  WHERE SYS_TABLE_ID = -10 +
UNION ALL SELECT +
(PartID + '-' + PartCode) +
FROM LarrysTable 

Bill

On 13 Jul 2004 at 13:54, Lawrence Lustig wrote:

> I have a view that includes the expression 
> (PartID + '-' + PartCode) AS PartInfo 
> 
> in it.  This results in a NOTE type field in the
> resulting view.  I want the field to be of type TEXT. 
> I've tried applying CTXT, LJS, and SGET to the
> expression, as well as establishing another table with
> the field PartInfo created as type TEXT(11).  In every
> case, my view still creates a NOTE field.
> 
> Does anyone know a way to force R:Base to see that
> field as TEXT?
> --
> Larry