Harry,
It's possible you don't have delete rights on the table or that foreign key constraints are preventing the rows from being deleted.
>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?