look your email ( picture )

bernhart



>>sqlH = SQLCONNECT('AmlineBobConnection')
>>IF SQLEXEC(sqlH,"TRUNCATE TABLE xxCompan xxCompan") < 0
>>
>>*-- here I have a error : Variable 'AERR' is not found.
>>
>> AERRORS(aErr)
>> DISP MEMO LIKE aErr
>>ENDIF
>>SQLDISCONECT(sqlH)
>>
>>
>>
>>bernhart
>
>
>Sorry Typo in Function must be AERROR() not AERRORS()
>
>BTW what is the name of the Remote table? xxCompan xxCompan is ths the name if so You must use
>IF SQLEXEC(sqlH,"TRUNCATE TABLE [xxCompan xxCompan]") < 0
>...