Re: [sqlite] Addressing columns in an attached db

"James K. Lowden" wrote... On Wed, 23 Jul 2014 20:00:52 -0600 "Keith Medcalf" wrote: BEGIN; INSERT OR REPLACE INTO LSOpenProjects SELECT * FROM client.LSOpenProjects as A WHERE A.ProjID <= 133560 AND Date != A.Date AND A.login =

Re: [sqlite] Addressing columns in an attached db

"Keith Medcalf" wrote... BEGIN; INSERT OR REPLACE INTO LSOpenProjects SELECT * FROM client.LSOpenProjects as A WHERE A.ProjID <= 133560 AND Date != A.Date AND A.login = 'user1'; END; I presume that LSOpenProjects in both databases has a unique constraint on

Re: [sqlite] Addressing columns in an attached db

On Wed, 23 Jul 2014 20:00:52 -0600 "Keith Medcalf" wrote: > BEGIN; > INSERT OR REPLACE INTO LSOpenProjects > SELECT * FROM client.LSOpenProjects as A > WHERE A.ProjID <= 133560 AND > Date != A.Date AND > A.login = 'user1'; > END; > > I

Re: [sqlite] Addressing columns in an attached db

gin ... >-Original Message- >From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users- >boun...@sqlite.org] On Behalf Of jose isaias cabrera >Sent: Wednesday, 23 July, 2014 10:32 >To: General Discussion of SQLite Database >Subject: [sqlite] Addressing columns in an attac

Re: [sqlite] Addressing columns in an attached db

Richard Hipp wrote... On Wed, Jul 23, 2014 at 12:32 PM, jose isaias cabrera

Re: [sqlite] Addressing columns in an attached db

On Wed, Jul 23, 2014 at 12:32 PM, jose isaias cabrera wrote: > > Greetings. > > I have two DB identical and I am copying data from one to another. > > When I attach a DB, i.e.. > > ATTACH 'c:\db\mydb.sqlite' as client; > > how do I address the names of the column? for

[sqlite] Addressing columns in an attached db

Greetings. I have two DB identical and I am copying data from one to another. When I attach a DB, i.e.. ATTACH 'c:\db\mydb.sqlite' as client; how do I address the names of the column? for example, both DBs connected and disconnected have the columns: id,ProjID, Date, code, login. When I