MaxRecords question
Jan Gucik
When accessing large table, I need only limited number of records, but
setting this property appear functionless.
John.
Tomasz Cwajda (szaman)
>Can I use property MaxRecords on TAdoTable?
>
>When accessing large table, I need only limited number of records, but
>setting this property appear functionless.
>
Yes it is strange that it's present. May be it works with some
providers ?
But why not to use TADOQuery ? It is simple to do live query with
ado.
Tomek Cwajda
(szaman)
Jan Gucik
> >
> >When accessing large table, I need only limited number of records, but
> >setting this property appear functionless.
> >
> Yes it is strange that it's present. May be it works with some
> providers ?
>
> But why not to use TADOQuery ? It is simple to do live query with
> ado.
Yes, I think that TADOQuery works much better with MaxRecords.
After retrieving 10 records from 10000, is there any way how can
retrieve next 10 ? I need this solution for DBGrid-like component.
BTW: Setting CursorLocation to clUseServer is not suitable for problem.
John.
Jan Gucik
After reading a lots of interesting opinions from this discussion group, I
left database engine Access a switch
to true SQL Server.
Problem SQL TOP N has simple solution when I use SELECT and WHERE
statements, but
with ORDER BY it's not so easy. I can't presume existence of unique key
(field) for
additional limiting and seting position for result set.
I newbie in SQL, so may be I going wrong way.
Is there any SQL ability for runtime creating special unique index field
directly in SELECT statement. Something
like record ranking ?
BTW. Is there any diference between TOP N and property MaxRecord, e.g. in
optimalisation strategy on server side ?
Jan.
Harry Van Tassell <ha...@nada.com> píąe v diskusním
příspěvku:88jre5$qe...@bornews.borland.com...
> Hi Jan,
>
> I forgot to include in my last message a comment to the person who
started
> this thread, that while MaxRecords doesn't work in MS Access it works just
> fine in SQL-7 and TOP N works in both.
>
> > It's a pity, there is not delphi code for SQL TOP N grid sollution. ;-(
>
> My, what a pity you can't use all the Delphi code contained in that thread
> but OTOH I'll look forward to seeing your own coded solution published
here.
> ;>)
>
> Regards,
> Hairy
>
>
> Jan Gucik <gu...@atlas.cz> wrote in message
> news:88jpck$q7...@bornews.borland.com...
> > Hi Hairy,
> >
> > thank for very nice discussion thread with a lot of interesting notes
> about
> > using SQL.
> >
> > It's a pity, there is not delphi code for SQL TOP N grid sollution. ;-(
> >
> > Jan.
> >
> >
> > Harry Van Tassell <ha...@nada.com> píąe v diskusním
> > příspěvku:88jk16$q7...@bornews.borland.com...
> > > Hi Jan,
> > >
> > > The best discussion and solution to your problem that I've ever seen
was
> > by
> > > a talented fella named Craig Baugh who sometimes visits this NG. Go
read
> > all
> > > the post by him in the thread centered on this URL. In one of his
posts
> he
> > > shows how he uses SQL TOP N to do speedy record selection via
> incremental
> > > searching displayed in a dbgrid. All very good stuff...
> > >
> > >
> >
>
"http://x31.deja.com/=infoseek/getdoc.xp?AN=539264130&CONTEXT=942720850.6853
> > > 75573&hitnum=33"
> > >
> > > Regards,
> > > Hairy
> > >
>
>
>
>
>
>
>
Harry Van Tassell
When using clientside cursor you can sort a recordset.
Regards,
Hairy
Jan Gucik <gu...@atlas.cz> wrote in message
news:88m17k$s1...@bornews.borland.com...