From that error I suppose that Paradox doesn't support TRUNCATE command :o((((
But You can try this
sqlH = SQLCONNECT('AmlineBobConnection')
IF sqlH < 0
AERROR(aErr)
MessageBox(aErr[1,3])
RETURN
ENDIF
IF SQLEXEC(sqlH,"DELETE FROM [xxCompan xxCompan] WHERE 1=1") < 1
AERROR(aErr)
MessageBox(aErr[1,3])
ENDIF
SQLDISCONNECT(sqlH)
Requery("YourView")
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.