Re: [sqlite] Help with CASE WHEN

2011-06-19 Thread jose isaias cabrera
"Mr. Puneet Kishor" wrote... > > On Jun 19, 2011, at 10:04 PM, jose isaias cabrera wrote: > >> "Mr. Puneet Kishor" wrote... >>> >>> On Jun 19, 2011, at 5:12 PM, jose isaias cabrera wrote: >>> "Nico Williams" wrote... > On Fri, Jun 17, 2011 at 5:05 PM, Mr. Puneet Kishor >

Re: [sqlite] Help with CASE WHEN

2011-06-19 Thread Mr. Puneet Kishor
On Jun 19, 2011, at 10:04 PM, jose isaias cabrera wrote: > "Mr. Puneet Kishor" wrote... >> >> On Jun 19, 2011, at 5:12 PM, jose isaias cabrera wrote: >> >>> >>> "Nico Williams" wrote... >>> On Fri, Jun 17, 2011 at 5:05 PM, Mr. Puneet Kishor wrote: > The

Re: [sqlite] Help with CASE WHEN

2011-06-19 Thread jose isaias cabrera
"Mr. Puneet Kishor" wrote... > > On Jun 19, 2011, at 5:12 PM, jose isaias cabrera wrote: > >> >> "Nico Williams" wrote... >> >>> On Fri, Jun 17, 2011 at 5:05 PM, Mr. Puneet Kishor >>> wrote: The above is not SQL. You can't have a SQL statement begin with CASE. SQL

Re: [sqlite] Help with CASE WHEN

2011-06-19 Thread Mr. Puneet Kishor
On Jun 19, 2011, at 5:12 PM, jose isaias cabrera wrote: > > "Nico Williams" wrote... > >> On Fri, Jun 17, 2011 at 5:05 PM, Mr. Puneet Kishor >> wrote: >>> The above is not SQL. You can't have a SQL statement begin with CASE. SQL >>> statements can only begin with either

Re: [sqlite] Help with CASE WHEN

2011-06-19 Thread jose isaias cabrera
"Nico Williams" wrote... > On Fri, Jun 17, 2011 at 5:05 PM, Mr. Puneet Kishor > wrote: >> The above is not SQL. You can't have a SQL statement begin with CASE. SQL >> statements can only begin with either SELECT or UPDATE or CREATE or >> DELETE or ALTER, etc. CASE is an

Re: [sqlite] Help with CASE WHEN

2011-06-17 Thread Nico Williams
On Fri, Jun 17, 2011 at 5:05 PM, Mr. Puneet Kishor wrote: > The above is not SQL. You can't have a SQL statement begin with CASE. SQL > statements can only begin with either SELECT or UPDATE or CREATE or DELETE or > ALTER, etc. CASE is an expression, and has to be a

Re: [sqlite] Help with CASE WHEN

2011-06-17 Thread Mr. Puneet Kishor
On Jun 17, 2011, at 4:56 PM, jose isaias cabrera wrote: > CASE (SELECT round(sum(Xtra8),2) FROM LSOpenJobs > WHERE subProjID = 9144 AND lang = 'ES-LA' > AND PSubClass != 'Portal-Fee') > > WHEN < 5000 THEN >UPDATE LSOpenJobs SET ProjFund = (SELECT

[sqlite] Help with CASE WHEN

2011-06-17 Thread jose isaias cabrera
Greetings. I have used CASE before, but for simple codes and it works. However, I am trying to break down some calculations and it-s not working. I am getting, ...> ...> END; Error: near "CASE": syntax error sqlite> COMMIT TRANSACTION; Error: cannot commit - no transaction is active