I think I answered my own question--

STORE SQLCONNECT('myDSN') to gnconnhandle
=SQLEXEC(gnconnhandle, 'use mytable')
=SQLEXEC(gnconnhandle, 'sp_dboption mydatabase, trunc, true')
=SQLEXEC(gnconnhandle, "TRUNCATE TABLE mytable")
=SQLCOMMIT(gnConnHandle)

JR

>How do you do a SQL Passthrough and Truncate Table?
>
>I'm looking for specific code--I can't find it on UT or MS sites.
>
>TIA,
>Joy
>
>>Are there any constraints on the table that would prevent a parent record from being deleted if there is a child record?
>>
>>It is much quicker to do SQL Passthrough and TRUNCATE TABLE then to do a delete all.
>>
>>It is also possible that you do not have enough log space to handle the deletes. When you delete records the deletes are all logged and if you have a lot of records being deleted, it may fill the log. Check to see if you have restricted growth on the log table.
>>
>>And again, Truncate Table does not log deleted records so it is rather final, but very quick.
>>
>>
>>>I have a remote view/Updatable to a SQL 7 table. I try to zap the record set,
>>>but that does nothing. I try to delete all in the remote view and
>>>get back a update conflict message. any Ideas? Thanks Eric.