Re: [sqlite] Error: near "SELECT": syntax error

2014-02-01 Thread Clemens Ladisch
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 >

Re: [sqlite] Error: near "SELECT": syntax error

2014-01-31 Thread jose isaias cabrera
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

Re: [sqlite] Error: near "SELECT": syntax error

2014-01-31 Thread Clemens Ladisch
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

[sqlite] Error: near "SELECT": syntax error

2014-01-31 Thread jose isaias cabrera
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