[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