Greetings and salutations!
I have two Databases:
1. LocalDB
2. SharedDB
The SharedDB has the latest updates made from different machines and
different users. I would like to update the localDB record based on a date
field (UpdateDate) that the SharedDB has, which is the latest. I have
indexed that field, but I am failing with
Error: near "SELECT": syntax error
and "I think", it looks good. So, here is the setup using the command line
SQLite3 interpreter:
sqlite3 c:\users\user1\localDB.db
in sqlite3>
attach 'k:\data\sharedDB.db' as client;
BEGIN;
INSERT OR REPLACE INTO LSOpenProjects
(
SELECT * FROM client.LSOpenProjects WHERE client.LSOpenProjects.id=
(
SELECT id from LSOpenProjects WHERE
login != 'user1' AND
id = client.LSOpenProjects.id AND
UpdateDate != client.LSOpenProjects.UpdateDate
)
)
END;
I get, "Error: near "SELECT": syntax error". Any help would be greatly
appreciated. So, what I am trying to do is to INSERT all records in the in
the sharedDB for table LSOpenProjects that do NOT belong to login user1 and
that the localDB UpdateDate is NOT equal to the sharedDB UpdateDate. Any
help would be greatly appreciated. Thanks.
josé
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
