>want to zap a table on sql server
>In line with MSDN's topic
>have tried
>
>SQLPREPARE(gnhandle,'Delete from vizkeys','')
>SQLEXEC(gnhandle)
>
>which doesn't report any error but doensn't delete anything either.
>
>variations like "Delete from vizkeys where realkey<>'.NULL.'" (which should delete all) don't work either.
>
>Whats the secret?
Try SQLExec(gnHandle, 'Delete vizkeys') - don't bother with the SQLPrepare.