Thanks, Simon, this looks promising! Is this something that can be done programmatically in code (vb.net) or only from the command prompt?
If programmatically, could you shoot me a quick syntax example? -----Original Message----- From: sqlite-users-boun...@mailinglists.sqlite.org [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Simon Slavin Sent: Wednesday, July 20, 2016 6:46 AM To: SQLite mailing list Subject: Re: [sqlite] SQL to SQLite On 20 Jul 2016, at 12:21am, Robby Helperin <r...@spotlightmusic.com> wrote: > Any SQLite string is going to refer to just one database, so you can't > write an INSERT command that will take from one database and write to > another, or can you? How would this normally done? See the ATTACH command: <https://www.sqlite.org/lang_attach.html> Open one database file and ATTACH another. Once command can refer to tables in both database files. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
