[yunqa.de] Re: [SQLiteSpy] enable modifications on SELECT statements or VIEWS
- From: Delphi Inspiration <delphi@xxxxxxxx>
- To: yunqa@xxxxxxxxxxxxx
- Date: Fri, 29 Oct 2010 12:39:08 +0200
On 28.10.2010 16:33, Marco NOVARO wrote:
> Shouldn't ROWID work for this issue?
> For instance,
>
> SELECT ROWID, * FROM "Tickets";
>
> returns a column (ROWID) that is the same as my private ID ("ID" INTEGER
> PRIMARY KEY NOT NULL), and the following statement:
>
> UPDATE Tickets SET Assigned = 'MySelf' WHERE ROWID=5
>
> works fine.
This is the exact approach SQLiteSpy takes for cell editing in table mode.
Unfortunately, it is not possible to generalize this for arbitrary
user-entered queries for the reasons outlined in my previous message.
Ralf
_______________________________________________
Delphi Inspiration mailing list
yunqa@xxxxxxxxxxxxx
//www.freelists.org/list/yunqa
Other related posts:
