--- In firebird-support@yahoogroups.com, "menjit_singh" wrote:

> > Method 1:
> > 'SELECT Skip((SELECT COUNT(*) - 30 FROM DATA)) CLS, VOL, OPN,
> > HIGH, LOW, DATA,symbol FROM DATA
> > WHERE STOCK='''+imya+''' order by DATA ACS'
> >
> >
> > Method 2 (you need Firebird 2):
> >
> > 'SELECT * FROM (
> > SELECT First 30 CLS, VOL, OPN, HIGH, LOW, DATA,symbol
> > FROM DATA
> > WHERE STOCK=xxx ORDER BY DATA DESC )
> > ORDER BY DATA ASC
> >
> >
> > Ivan
> > http://www.volny.cz/iprenosil/interbase/
> >
>
> i'm using fbembed.dll version 1.5.2.4731.i used method 1 but an
> error occured. Should i replace the '*' in the COUNT(*) with
> something? method 2 also produced an error, undefine token SELECT
> for the 'FROM( SELECT..'

Method 1 should work, but you do need double parenthesis like Ivan
wrote (I don't know why), method 2 does not work with Firebird 1.5.

Set