On 18 Aug 2010, at 9:54pm, Stephan Wehner wrote:
> So attaching the file1 before creating the table in file2
> is going to fail? (Then sqlite would know about the {texts} table)
The ATTACH command is a bit of a misnomer: it doesn't do anything to the
database files. It affects a particular connection that you opened with
sqlite3_open(), and allows your application to address both files on disk via
the same connection. It does not attach the two database files for any later
connections to them, and the two files still don't know anything about
one-another.
Simon.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
