Thanks I thought I saw something like this on the list but could not find it.
Dan -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Walker, Buddy Sent: Wednesday, July 21, 2004 11:45 AM To: RBG7-L Mailing List Subject: [RBG7-L] - RE: combining two text fields in a view problem Dan Here is a solution Bill Downall posted a few days ago. Buddy ********************************** 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? ******************************************** -----Original Message----- From: Dan Goldberg [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 21, 2004 2:24 PM To: RBG7-L Mailing List Subject: [RBG7-L] - combining two text fields in a view problem I am trying to combine two text fields in a view and have a problem. I have an expression: (partnum & descript) Both optcode and descript are text fields. But when I combine them and view it, it makes a note field. I need the field to be a text field. Has anybody found a workaround for this?? Dan Goldberg MIS Manager Lance Camper Mfg Corp (661)949-3322 Ext 252
