Thank kurt,

that give me a idea.


=EXECSCRIPT("CREATE SQL VIEW COMPAN REMOTE CONNECT 'AmlineBobConnection' AS SELECT * FROM " + cFolderData + ' ' + cFolderData )

bernhart

>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