Bernhart,

Store the sqlstatement to a string, I prefer to use the TEXTMERGE command for sqlcommands because it is easier to maintain, then use the EVAL() function to execute the text string.

cFolderData = "MYCUSTOMER"

TEXT TO lcSqlString TEXTMERGE NOSHOW
CREATE SQL VIEW COMPAN ;
  REMOTE CONNECTION "AmlineBobConnection"  AS SELECT * FROM <<cFolderData>>
ENDTEXT  

EVALUATE(lcSqlString)

Kurt
>Hi all,
>
>
>
>

>cFolderData = "MYCUSTOMER"
>CREATE SQL VIEW "COMPAN" ;
>  REMOTE CONNECT "AmlineBobConnection" AS SELECT * FROM ( cFolderData cFolderData  )
>

>
>I HAVEC a error...
>What is the good syntax ?
>
>Thank in advance for the answer...
>
>
>bernhart