Version 2.1.3.18185

ODBC version 2.0.0.150

-----Original Message-----
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Thomas Steinmaurer
Sent: 23 May 2011 9:51 AM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Re: SQL statment Help

> Ignore the " they are from the code within my Software
>
> So if the statement looks ok why do I get a error when I try to action the
> code?

Have you tried executing the statement in isql?

What Firebird version do you use (sorry if I have missed that information)?



--
With regards,

Thomas Steinmaurer
Upscene Productions
http://www.upscene.com
http://blog.upscene.com/thomas/

Download LogManager Series, FB TraceManager today!
Continuous Database Monitoring Solutions supporting
Firebird, InterBase, Advantage Database, MS SQL Server
and NexusDB!

> -----Original Message-----
> From: firebird-support@yahoogroups.com
> [mailto:firebird-support@yahoogroups.com] On Behalf Of karolbieniaszewski
> Sent: 23 May 2011 6:58 AM
> To: firebird-support@yahoogroups.com
> Subject: [firebird-support] Re: SQL statment Help
>
>
> --- In firebird-support@yahoogroups.com, "Andrew Gable"<andrew.gable@...>
> wrote:
>>
>> Hi All,
>>
>> I am using the following SQL statement
>>
>> "SELECT POSDESCRIPTION,"
>> "CASE WHEN (TradeDate = '2011/05/01') THEN COALESCE(QtySold, 0) ELSE 0

END

>> as Col1,"
>> "CASE WHEN (TradeDate = '2011/05/02') THEN COALESCE(QtySold, 0) ELSE 0

END

>> as Col2,"
>> "CASE WHEN (TradeDate = '2011/05/03') THEN COALESCE(QtySold, 0) ELSE 0

END

>> as Col3 FROM ("
>> "SELECT"
>> "POSDESCRIPTION, TradeDate, SUM(QtySold) As QtySold"
>> "From SALEHISTORY"
>> "Where"
>> "TradeDate Between '2011/04/01' AND '2011/04/04'"
>> "GROUP BY 1, 2) as Sales ORDER BY 1"
>>
>> But I am getting the following error message
>>
>> Runtime error -2147467259
>> [ODBC Firebird Driver][Firebird]Dynamic SQL Error
>> Expression evaluation not supported
>>
>> Is this because I am running it through code in VB6?
>>
>> Does the above sql code need to be run with in the Database?
>>
>> -----Original Message-----
>> From: firebird-support@yahoogroups.com
>> [mailto:firebird-support@yahoogroups.com] On Behalf Of Leyne, Sean
>> Sent: 19 May 2011 11:29 PM
>> To: firebird-support@yahoogroups.com
>> Subject: RE: [firebird-support] SQL statment Help
>>
>>
>>> This may be the wrong group but I need some advice on a SQL statement
>>>
>>> I have a database that tacks all sales by date and by product I would
> like
>> to
>>> run a function to display the products with a summary of the items per
>>>
>>> Day for example
>>>
>>> Item 01/05/11 02/05/11
>>> 03/05/11
>>>
>>> =====================================================
>>>
>>> VALUE ORANGE JUICE 5 9
>>> 10
>>
>> If you are using the Firebird v2.1 or later you should be able to:
>>
>> SELECT
>> Sales.Product_Desc,
>> CASE WHEN (Sales.ItemDate = '1 MAY 2011') THEN COALESCE(
> Sales.ItemCount,
>> 0) ELSE 0 END as Col1,
>> CASE WHEN (Sales.ItemDate = '2 MAY 2011') THEN COALESCE(
> Sales.ItemCount,
>> 0) ELSE 0 END as Col2,
>> CASE WHEN (Sales.ItemDate = '3 MAY 2011') THEN COALESCE(
> Sales.ItemCount,
>> 0) ELSE 0 END as Col3
>> FROM (
>> SELECT
>> Product_Desc,
>> ItemDate,
>> SUM( ItemCount) as ItemCount
>> FROM ItemSales
>> WHERE
>> ItemDate BETWEEN '1 MAY 2011' AND '3 MAY 2011'
>> GROUP BY 1, 2
>> ) as Sales
>> ORDER BY 1
>>
>>
>>
>>
>> ------------------------------------
>>
>> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>>
>> Visit http://www.firebirdsql.org and click the Resources item
>> on the main (top) menu. Try Knowledgebase and FAQ links !
>>
>> Also search the knowledgebases at http://www.ibphoenix.com
>>
>> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>> Yahoo! Groups Links
>>
>>
>>
>>
>>
>> -----
>> No virus found in this message.
>> Checked by AVG - www.avg.com
>> Version: 10.0.1375 / Virus Database: 1509/3649 - Release Date: 05/20/11
>>
>> -----
>> No virus found in this message.
>> Checked by AVG - www.avg.com
>> Version: 10.0.1375 / Virus Database: 1509/3649 - Release Date: 05/20/11
>>
>
>
> statement look ok - i run it on test table
> but from what are this chars " ?
>
> Karol Bieniaszewski
>
>
>
> ------------------------------------
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> Yahoo! Groups Links
>
>
>
>
>
> -----
> No virus found in this message.
> Checked by AVG - www.avg.com
> Version: 10.0.1375 / Virus Database: 1509/3653 - Release Date: 05/22/11
>
>
>
> ------------------------------------
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> Yahoo! Groups Links
>
>
>

------------------------------------

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://www.firebirdsql.org and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !

Also search the knowledgebases at http://www.ibphoenix.com

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Yahoo! Groups Links





-----
No virus found in this message.
Checked by AVG - www.avg.com
Version: 10.0.1375 / Virus Database: 1509/3653 - Release Date: 05/22/11

-----
No virus found in this message.
Checked by AVG - www.avg.com
Version: 10.0.1375 / Virus Database: 1509/3653 - Release Date: 05/22/11