c# - SQLite In Clause not working in trigger -

-

i have 2 tables table1 , table2. table1 have columns id,stringids , table2 columns id,data

there 2 tables in picture

i have created trigger delete rows based on table1. doesn't works if comma seperated stringids more one. works if stringids single value

create trigger tgtriggername after delete on table1 begin delete table2 id in (old.stringids); end

gordon right, table structure really not want. if reason must way, query might accomplish want:

delete table2  id = old.stringids                   -- id matches   or old.stringids id + ',%'          -- or id @ beginning of list   or old.stringids '%,' + id          -- or id @ end of list   or old.stringids '%,' + id + ',%'   -- or id in middle of list

but that's mess. don't it. instead remove stringids column table1, , add column table2 called table1id indicate table1 id table2 record belongs to. table2 this

id     table1id     data 1      1            data 2      1            data 3      2            data 4      2            data 5      2            data ...

then trigger query can be:

delete table2 table1id = old.id

even more clean skip trigger , foreign key contstraint cascading delete. have feeling that's lesson day.


Comments

Post a Comment

Popular posts from this blog

Hatching array of circles in AutoCAD using c# -

-
i beginner in autocad plugins .i have created array of circle using following code. now, have hatch circles in array .how that??how hatch circles @ once? moreover, how can return hatch method , use hatch objects.sorry language.thanks in advance. [assembly: commandclass(typeof(beamsection.class1))] namespace beamsection { public class class1 { //class1 obj = new class1(); [commandmethod("beamatsupport")] public void addlightweightpolyline() { // current document , database document acdoc = application.documentmanager.mdiactivedocument; database accurdb = acdoc.database; promptpointresult ppr = acdoc.editor.getpoint("\nselect starting point "); var ucs = acdoc.editor.currentusercoordinatesystem; point3d startingpt = ppr.value.transformby(ucs); list<double> radius = new list<double>(); radius.add(0.5);
Read more

ios - UITEXTFIELD InputView Uipicker not working in swift -

-
hello trying pop uipickerview view programmatically when user clicks on textfield. have tried doesn't doing anything. isn't working. nothing happening when click textfield class userprofiletableviewcontroller: uitableviewcontroller,uitextfielddelegate,uipickerviewdelegate,uipickerviewdatasource { var itempicker: uipickerview! = uipickerview() @iboutlet weak var gendertxtfield: uitextfield! var gender = ["male","female"] override func viewdidload() { super.viewdidload() gendertxtfield.delegate = self itempicker!.delegate = self itempicker!.datasource = self itempicker!.backgroundcolor = uicolor.blackcolor() self.gendertxtfield.inputview = itempicker } func numberofcomponentsinpickerview(pickerview: uipickerview) -> int{ return 1 } // returns # of rows in each component.. func pickerview(pickerview: uipickerview, numberofrowsincomponent component:
Read more

Python Pig Latin Translator -

-
so have been working on @ codecademy.com while trying learn python. don't know if blind , can't see why won't work or what. here's code won't let me use. function print variable if had typed in , print "empty" if didn't type anything. print "welcome english pig latin translator!" original = raw_input("what's name?") if len(original) > 0 print original else print "empty" if len(original) > 0 else the above lines contains syntax errors. try: if len(original) > 0: else: note added colons, ( : ).
Read more