> I think tcl gets its file size from the operating system and the operating > system doesn't update the size of flies with open > handles. But you are going to need someone who knows tcl to check that.
I think that would be me :) > > Please see in the script in the original post. > > I'm sorry. You did show it and I forgot it was in that post. No problem so far. But my problem remains :( If I do the script step by step I also do not see the file shrink in the file explorer. The dbfile will only shrink "after" I close the db connection. Even with an explicit "vacuum" command. So the question remain: How to shrink an used dbfile in wal mode? So far the only working solution I found is to disconnect and connect again. Rene Kernkraftwerk Goesgen-Daeniken AG CH-4658 Daeniken, Switzerland Diese Nachricht (inkl. Anhaenge) beinhaltet moeglicherweise vertrauliche oder gesetzlich geschuetzte Daten oder Informationen. Zum Empfang derselben ist (sind) ausschliesslich die genannte(n) Person(en) bestimmt. Falls Sie diese Nachricht irrtuemlicherweise erreicht hat, sind Sie hoeflich gebeten, diese unter Ausschluss jeder Reproduktion zu vernichten und den Absender umgehend zu benachrichtigen. Besten Dank.