On Thu, Aug 13, 2015 at 4:05 AM, Chris Parsonson <z2668856 at gmail.com> wrote:
> So can someone give me a working example of two database ATTACHed and a
> simple select using columns from a table in each database
C:\SQLite3>sqlite3 C:\SQLite3\UpdateWolfpro.db3
SQLite version 3.8.11.1 2015-07-29 20:00:57
Enter ".help" for usage hints.
sqlite> CREATE TABLE Items (
[Category] VARCHAR(50) NOT NULL,
[Supplier] VARCHAR(50) DEFAULT 'Default',
[Product Code] VARCHAR(20) NOT NULL,
[Short Description] VARCHAR(50),
[Long Description] VARCHAR(1000),
[Unit Price] INTEGER,
[Maximum Sample Quantity] INT,
[Box Price] INTEGER,
[Box Quantity] INT,
[Deleted] VARCHAR(5) DEFAULT 'No',
[Item Image File Path] VARCHAR(100),
[Last Update] TIMESTAMP, CONSTRAINT
[sqlite_autoindex_Items_1] PRIMARY KEY ([Product Code]));
sqlite> .quit
C:\SQLite3>sqlite3 C:\SQLite3\Wolfpro.db3
SQLite version 3.8.11.1 2015-07-29 20:00:57
Enter ".help" for usage hints.
sqlite> CREATE TABLE Items (
[Category] VARCHAR(50) NOT NULL,
[Supplier] VARCHAR(50) DEFAULT 'Default',
[Product Code] VARCHAR(20) NOT NULL,
[Short Description] VARCHAR(50),
[Long Description] VARCHAR(1000),
[Unit Price] INTEGER,
[Maximum Sample Quantity] INT,
[Box Price] INTEGER,
[Box Quantity] INT,
[Deleted] VARCHAR(5) DEFAULT 'No',
[Item Image File Path] VARCHAR(100),
[Last Update] TIMESTAMP, CONSTRAINT
[sqlite_autoindex_Items_1] PRIMARY KEY ([Product Code]));
sqlite> attach 'C:\SQLite3\UpdateWolfpro.db3' as UPD;
sqlite> INSERT INTO main.Items (
[Category], [Product Code]) VALUES("resistor", "300ohm");
sqlite> INSERT INTO UPD.Items (
[Category], [Product Code]) VALUES("capacitor", "47uf");
sqlite> SELECT * FROM UPD.Items;
capacitor|Default|47uf|||||||No||
sqlite> SELECT * FROM main.Items;
resistor|Default|300ohm|||||||No||
sqlite> DELETE FROM UPD.Items;
sqlite> SELECT * FROM UPD.Items;
sqlite> SELECT * FROM main.Items;
resistor|Default|300ohm|||||||No||
sqlite> .quit
C:\SQLite3>
--
--
--
--???--
K e V i N
