I'm working on a project which generates tables from a config file, and it seems to be happy on a Mac OSX running 3.4.0, but Linux running 3.7.8 complains about an insert with the unhelpful message
(foreign key mismatch) I've checked all the data and don't see what it is complaining about, and if I dump the SQL to a file and execute the same commands that way, it works, and so does adding the single record in question using sqlite3. Is there some way to get more details on what mismatched, such as turning on a debug flag, upping verbosity, or using DBI's trace mechanism (which I once used ages ok and remember as being meant for DBI/DBD developers rather than mere SQL hackers :-) -- ... _._. ._ ._. . _._. ._. ___ .__ ._. . .__. ._ .. ._. Felix Finch: scarecrow repairman & rocket surgeon / fe...@crowfix.com GPG = E987 4493 C860 246C 3B1E 6477 7838 76E9 182E 8151 ITAR license #4933 I've found a solution to Fermat's Last Theorem but I see I've run out of room o _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users