Hi Mike
On Wed, 2008-10-08 at 12:11 -0700, mmccaws2 wrote:
> Hi
>
> I don't understand the error for this statement for SQLITE
>
> $dbh->do("ALTER TABLE new_definition (
> ADD COLUMN loopback TEXT)");
>
> here is the error message:
>
> DBD::SQLite::db do failed: near "(": syntax error(1) at dbdimp.c line
> 271 at ./a
> ddnewdef.pl line 38.
> DBD::SQLite::db do failed: near "(": syntax error(1) at dbdimp.c line
> 271 at ./a
> ddnewdef.pl line 38.
What happens when you believe the msg, and try:
$dbh->do("ALTER TABLE new_definition
ADD COLUMN loopback TEXT");
> Or is it the case I'll have to delete the table and create the table
> with the new column added.
>
>
>
>
> Also additional question about SQLITE. I've been developing using
> against a SQLITE db. I trimmed hundreds of entries out of table and
> the count command returns values shows that the number of entries has
> reduced. However the file doesn't reduce in size. Does SQLITE keep
> the last greatest file size eventhough the table has been trimmed?
> Or is there something else I need to do.
I would not expect it to return space to the OS unless you ran a
specific command.
--
Ron Savage
[EMAIL PROTECTED]
http://savage.net.au/index.html
