> 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..'