"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
>
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
"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
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
"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
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
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
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
8 matches
Mail list logo