Limiting cursor size

[Frank Bitterlich]

Sorry, I must take that back as it looks. I was sure I read it in the
specs, but I can't find it there anymore. Hmm. Anyway, I still like
"top"... :)

Cheers,
   Frank+++

Ruslan Zasukhin wrote:
> 
> on 6/13/03 17:33, Frank Bitterlich at bitterlich at gsco.de wrote:
> 
> >
> >
> > Ruslan Zasukhin wrote:
> > ...
> >> Yes we going to add this feature.
> >>
> >> As always we want
> >>
> >> 1) follow SQL Standard
> >> 2) may be optionally provide popular syntax, e.g. From mySQL.
> >
> > AFAIK thae SQL92 syntax is
> >
> >  select top(0,100) * from mytable;
> >
> > FrontBase uses the same. Would be nice if Valentina would use the same too.
> 
> If this is standard of SQL92 then yes.,
> 
> Although it seems I have not see LIMIT or TOP in the SQL92 standard,
> May be it was added only for SQL99.

--
Günter Schmidt & Co. oHG         
Frank Bitterlich             eMail: bitterlich at gsco.de
Schlosserstr. 4              WWW:   http://www.gsco.de/gsco
D-60322 Frankfurt            Tel.:  069 / 156809-29
GERMANY                      Fax:   069 / 156809-28