>I have a SQL doing a UNION. The first part of the SQL is including a Url field which is a memo field. The second part of the SQL takes its data from another table where the Url is a character field. Now, that one field has been changed to a memo field, this SQL doesn't work. How can I make this SQL works?
UNION in VFP8 has been enchanced so it can imlicitly convert field types to make SELECT's UNION-compatible. This works in VFP8.
Create Table c:\temp\table_memo ( mField m )
Create Table c:\temp\table_char ( cField c(50) )
Select mField As cResult ;
From Table_Memo ;
Union ALL ;
Select cField ;
From Table_Char
--sb--