use stored procedure eg :

FOR SELECT Field1, Field2, ....
DO BEGIN
IF (Field1 = 'desktop') THEN BEGIN
END
....
....
SUSPEND;
END


--- hay77772000 <david.hay@...> a écrit : >
Hi. Am completely new to Firebird - having been

> using mySQL til now.
>
> Have a couple of questions:
>
> - is there anywhere I can download documentation on
> the Firebird
> keywords and how to use them eg LEFT, IN etc..
>
> - in mySQL I simulated a crosstab query (eg from MS
> Access) by
> getting the column names, and then creating a query
> like this to
> return the report table in one swoop:
>
> SELECT 'Total', SUM(IF(Kiosks.Name='desktop',
> Metrics.Copies,
> 0)) AS 'desktop', SUM(IF(Kiosks.Name='redcoat3',
> Metrics.Copies, 0))
> AS 'redcoat3', SUM(Metrics.Copies) as Total FROM
> Kiosks INNER JOIN
> Metrics ON Kiosks.ID=Metrics.Kiosk_Id WHERE Time IS
> NOT NULL AND
> Copies IS NOT NULL
>
> Is this possible in Firebird, and if not, can anyone
> suggest another
> method?
>
> Many thanks,
>
> David
>
>
>
> ------------------------ Yahoo! Groups Sponsor
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to
> http://docs.yahoo.com/info/terms/
>
>

___________________________________________________________
Do You Yahoo!? -- Une adresse @... gratuite et en français !
Yahoo! Mail : http://fr.mail.yahoo.com