Hello John, ATTACH DATABASE may well be the statement that you need: https://www.sqlite.org/lang_attach.html <https://www.sqlite.org/lang_attach.html>
It lets you use several sqlite files from a single database connection, and execute queries across all tables of all attached files. Gwendal Roué > Le 31 août 2017 à 19:44, John R. Sowden <jsow...@americansentry.net> a écrit : > > I have been using the xbase language (dbase, foxpro, etc.) for about 36 > years, writing applicatios for my alarm company, so each database is a > separate file for me. For the last 21 years, I have been using Linux, and > have found that sqlite is my best match for Linux database use. > > What I fail to understand is how I set up my files/databases. I have > categories that I write for: accounting, dispatching, service, billing, etc. > Some (most) of these use customer data, so when I am writing code for the > billing program, and I want to reference the customers, is that a separate > file, so I only have 1 customer file to update (the relational model)? > Having a customer table, with indices, in each category's database (file) > breaks the relational model. I have been on this list for about a year and > see no reference to this issue. I am reading now about sqlite in _The > Definitive Guide to SQLite_ by Michael Owens, but I'm early in the book. > > Help? > > John > > _______________________________________________ > 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
