Igor Tandetnik schrieb:
> You don't have a single row in dbapp view that has fields='surname'. The
> only record you have is one where fields='name,surname'. So no row
> matches condition, and thus no row gets deleted. Your trigger never even
> runs.
That's weird. So Sqlite first does read from
Ok, I've removed that nested DELETE command. Now I have still the problem
that I can't delete tablenames with multiple field entries. The full sql
I have is as follows:
---
create table dbapp_tablenames (
tablenameID integer primary key,
tablename text not null unique on conflict ignore
);
crea
Hi folks!
After having UPDATE and INSERT on a view working, I'd also like to DELETE
FROM a view. I have the following tables and a view:
---
create table dbapp_tablenames (
tablenameID integer primary key,
tablename text not null unique on conflict ignore
);
create table dbapp_tab
Jay A. Kreibich schrieb:
> http://www.sqlite.org/lang_createview.html
>
> "You cannot COPY, DELETE, INSERT or UPDATE a view. Views are
> read-only in SQLite. However, in many cases you can use a
> TRIGGER on the view to accomplish the same thing."
>
> -j
Aha!...and...so what?
Hi folks!
I'm building a tool (with PyQt) which automatically generates menues and
forms for maintaining data on a database. Instead of hardcoding the names
of tables and fields into the code, i'd like to store this info into the
db itself. So my tool shall gather the info by the following stateme
5 matches
Mail list logo
