jose isaias cabrera wrote:
> now this command is working perfectly:
>
> BEGIN; INSERT OR REPLACE INTO LSOpenProjects
>SELECT * FROM client.LSOpenProjects WHERE id IN
>(SELECT id from LSOpenProjects WHERE
>login != '20513925' AND
>id = client.LSOpenProjects.id
>
Clemens Ladisch wrote...
To: <sqlite-users@sqlite.org>
Sent: Friday, January 31, 2014 1:32 PM
Subject: Re: [sqlite] Error: near "SELECT": syntax error
jose isaias cabrera wrote:
INSERT OR REPLACE INTO LSOpenProjects
(
SELECT ...
)
SQL does not allow parentheses he
jose isaias cabrera wrote:
> INSERT OR REPLACE INTO LSOpenProjects
> (
>SELECT ...
> )
SQL does not allow parentheses here.
> all records ... that the localDB UpdateDate is NOT equal to the sharedDB
> UpdateDate
This description is meaningless if you do not specify which records are to
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
4 matches
Mail list logo