--- In firebird-support@yahoogroups.com, "Ivan Prenosil"
<Ivan.Prenosil@s...> 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
> >>
> >
> > 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
>