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

Reply via email to