[PLUG] MS Access and Linux

Ted Kubaska tedkubaska at comcast.net
Wed Feb 13 06:51:30 UTC 2008


Could you drop the table and then recreate?
 -ted

-----Original Message-----
From: plug-bounces at lists.pdxlinux.org
[mailto:plug-bounces at lists.pdxlinux.org] On Behalf Of John Jason Jordan
Sent: Tuesday, February 12, 2008 10:45 PM
To: plug at lists.pdxlinux.org
Subject: Re: [PLUG] MS Access and Linux

On Wed, 13 Feb 2008 00:03:47 -0600
"Robert Citek" <robert.citek at gmail.com> dijo:

> Yup.  Give me a handful of examples over the docs they got.
> 
> If it's anything like sqlite3, then this might work to delete all the
rows:
> 
>   delete from <tablename> ;
> 
> throw in a where clause to limit the amount deleted:
> 
>   delete from <tablename> where <where clause> ;

Still doesn't work. Strangely,

SELECT * FROM worktable

Works fine. But

DELETE * FROM worktable

Gives a message that there is an error near DELETE. The SQLite syntax
website (http://www.sqlite.org/lang.html) gives the example:

DELETE FROM worktable

But that gives the same error message. Adding ";" at the end doesn't
help either. Neither did changing * to "all" or putting it in different
places.

Maybe Kexi didn't implement all of SQLite syntax. Maybe it never
occurred to them that someone might want to empty a table. I joined the
SQLite e-list and asked there, but it doesn't appear to have much
activity.
_______________________________________________
PLUG mailing list
PLUG at lists.pdxlinux.org
http://lists.pdxlinux.org/mailman/listinfo/plug




More information about the PLUG mailing list