Hello Paul,

Would you be willing to drop the table then create the table? :

MyTable.dropTable()
MyTable.createTable()

From the SQLObject docs....

Creating and Dropping Tables

To create a table call createTable. It takes two arguments:

ifNotExists:
If the table already exists, then don't try to create it. Default False.
createJoinTables:
If you used Many-to-Many relationships, then the intermediate tables will be created (but only for one of the two involved classes). Default True.

dropTable takes arguments ifExists and dropJoinTables, self-explanatory.


On 6/23/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:

How can I drop all records from a table?

I have an import function that needs to drop all records in the table
before adding the records from the import.





--
--
Nicky Ayoub
G-Mail Account
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "TurboGears" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at http://groups.google.com/group/turbogears
-~----------~----~----~----~------~----~------~--~---

Reply via email to