I'm trying to execute a simple truncate table command "TRUNCATE TABLE CPWR_DP123", but it errors out stating that "java.sql.SQLFeatureNotSupportedException: Now HXTT Access doesn't support truncate table."
The development doc http://www.hxtt.com/access/sqlsyntax.html#truncatetable does not indicate this in any way.
Can you please explain this ?
TRUNCATE TABLE syntax is provided, but that feature doesn't be supported.
delete from CPWR_DP123 can do it.
If you need that TRUNCATE TABLE feature for your project, we can complement it.