Hi, this question is more a C question than sql related:
I am not a C expert at all so I wanted to ask if the little changes I made in shell.c are ok. It seems to work ... I use .genfkey because it is very useful if I have many fk constraints. I thought it is useful to identify what the trigger is doing by its name (adding from/to table infos). Therefore I changed the line 867 in shell.c from ", '/name/', 'genfkey' || min(rowid) to ", '/name/', 'genfkey' || min(rowid) || '_' || replace(dq(from_tbl),'\"','') || '_to_' || replace(dq(to_tbl),'\"','')" _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users