Leon Keylin wrote: > Thanks Tim for a fast reply. > > The return gives me 0 Rows Truncated message and when I look at the table, > every record is still there. > There are no foreign keys on the table and no errors. > > Andreas asked if I should commit after, should I? I didn't think I > needed to > but I can try that.
Commits shouldn't make any difference at all to truncation -- that's the point of it, unless the interface lib is actually holding back from *issuing* the cursor command until you commit. (Though I doubt it). Does it work in Query Analyzer (or any other means you have of issuing the command)? Does truncation work on any other table? TJG _______________________________________________ Tutor maillist - Tutor@python.org http://mail.python.org/mailman/listinfo/tutor
