On Tuesday 03 July 2007 00:08:43 Ekrame Ayari wrote:
> Hi
>
> I wish to remove table rows to allow user decrease space disk.
>
> I try to delete table rows for free disk space with this code :
>
> "Connect connect =
> DriverManager.getConnection("jdbc:derby:GenoCensusMin2"); Statement stat =
> connect.createStatement();
> stat.executeUpdate("DELETE FROM Project WHERE id="+idProjet);"
>
> But disk space size of my system directory is the same before and after
> the deletion.
>
> Can you help me?Have you tried using SYSCS_UTIL.SYSCS_COMPRESS_TABLE ? Daniel -- Daniel Noll Nuix Pty Ltd Suite 79, 89 Jones St, Ultimo NSW 2007, Australia Ph: +61 2 9280 0699 Web: http://nuix.com/ Fax: +61 2 9212 6902
