>What about using TRUNCATE?

cFolderData = "xxcompan'

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


DBSETPROP('COMPAN', 'View', 'UpdateType', 1)
DBSETPROP('COMPAN', 'View', 'WhereType', 3)
DBSETPROP('COMPAN', 'View', 'FetchMemo', .T.)
DBSETPROP('COMPAN', 'View', 'SendUpdates', .T.)
DBSETPROP('COMPAN', 'View', 'UseMemoSize', 255)
DBSETPROP('COMPAN', 'View', 'FetchSize', 100)
DBSETPROP('COMPAN', 'View', 'MaxRecords', -1)
DBSETPROP('COMPAN', 'View', 'Tables', 'xxcompan' )
DBSETPROP('COMPAN', 'View', 'Prepared', .F.)
DBSETPROP('COMPAN', 'View', 'CompareMemo', .T.)
DBSETPROP('COMPAN', 'View', 'FetchAsNeeded', .F.)
DBSETPROP('COMPAN', 'View', 'Comment', "")
DBSETPROP('COMPAN', 'View', 'BatchUpdateCount', 1)
DBSETPROP('COMPAN', 'View', 'ShareConnection', .F.)