Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Trigger setup issue #3115

Open
pawelsalawa opened this issue Jan 18, 2018 · 0 comments
Open

Trigger setup issue #3115

pawelsalawa opened this issue Jan 18, 2018 · 0 comments
Labels
bug Something isn't working

Comments

@pawelsalawa
Copy link
Owner

(This issue was migrated from the old bug tracker of SQLiteStudio)

Original ID from old bug tracker: 3265
Originally created at: Tue Jan 24 15:02:01 2017
Originally last updated at: Tue Jan 24 15:02:01 2017

Trying to setup this trigger

CREATE TRIGGER UpdateDispInM
INSTEAD OF UPDATE OF [Disp.InM]
ON InMtoOrder
BEGIN
UPDATE DispInM
SET [Disp.InM] = new.[Disp.InM]
WHERE DispInM.[Part Number] = new.[Part Number];
END;

on a view. It is working for a while, but then something happens and the shell is reporting:

[14:43:26] Cannot edit this cell. Details: The query execution mechanism had problems with extracting ROWID's properly. This might be a bug in the application. You may want to report this.

Plugins loaded:
PopulateRandom, DbSqlite2, ScriptingTcl, PopulateSequence, MultiEditorNumericPlugin, MultiEditorTextPlugin, ScriptingSql, MultiEditorDateTimePlugin, ConfigMigration, PopulateDictionary, HtmlExport, PdfExport, SqlExport, RegExpImport, SqlEnterpriseFormatter, DbSqliteCipher, JsonExport, ScriptingQt, XmlExport, DbSqliteWx, MultiEditorBoolPlugin, PopulateRandomText, DbSqliteSystemData, PopulateConstant, JavaScriptHighlighterPlugin, MultiEditorTimePlugin, Printing, CsvImport, SqliteHighlighterPlugin, CsvExport, DbPluginSqlite3, MultiEditorHexPlugin, MultiEditorDatePlugin, PopulateScript

Version:
3.1.1

Operating System:
Windows 10, 64bit

@pawelsalawa pawelsalawa added the bug Something isn't working label Jan 18, 2018
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Projects
None yet
Development

No branches or pull requests

1 participant