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
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement