I am trying to create a view by running the code below. Then I will use CREATE SQL VIEW AS &mysql to create the view.

mysql="SELECT X.oname,X.tblname,X.ftype,X.fwidth,X.fdecplaces,X.fnullvalues,X.fdefval,Y.objectname,Y.objecttype, ;
Y.fwidth, Y.fdecplaces, Y.fnullvalues, Y.fdefval FROM description X, metadescription Y where X.oname=Y.objectname ;
and X.objcateg=Y.objcateg and X.objcateg='Field'"

However, I am getting an error "Command contains unrecognized phrase/keyword" everytime I add the last condition which is "X.objcateg='Field'". If I remove it, VFP accepts the sttmt. Is there any limit with the number of characters that a temporary variable can hold in this case?

Thanks a lot for your help.

Nerissa