>> 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
>>
>
> 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?

Which error ? I copy/pasted you typo ACS, should be ORDER BY DATA ASC.
Do you really use two pairs or parenthesis ?
SELECT Skip ( ( SELECT ... ) ) ...

> method 2 also produced an error, undefine token SELECT for the 'FROM(
> SELECT..'

As I wrote, it is for FB2.0 only.

Ivan