Re: Question about SqlCe Parameters usage

From: tiger79 (poli_at_freemail.nl)
Date: 07/07/04 

Date: Wed, 7 Jul 2004 14:48:24 +0200

Sorry Jon, but how can I make a Query in qhich I specify the range of index
to fetch ?

"Jon Skeet [C# MVP]" <skeet@pobox.com> wrote in message
news:MPG.1b55e5e87fc098fc98ae22@msnews.microsoft.com...
> tiger79 <poli@freemail.nl> wrote:
> > about that datatable usage : "Getting the data in one
> > > block from the database may very well be quicker than doing 51
separate
> > > queries."
> > do I still have to make use of paramaters then ? I mean what do u mean
> > exactly ? First I make a datatable containing all records from DB, then
I
> > perform like a search on this datatable ???
>
> No, you create an empty table and fill it with a SQL query which only
> fetches the relevant data. In your original post, you could just have
> done a query which specified the range of index to fetch, for instance.
> You might want to order the results by index, too.
>
> --
> Jon Skeet - <skeet@pobox.com>
> http://www.pobox.com/~skeet
> If replying to the group, please do not mail me too

Relevant Pages

  • Re: Splitting file
    ... No row was found for FETCH, UPDATE or DELETE; ... query is an empty table. ... UPDATE TABLE1 SET ... ...
    (comp.unix.shell)
  • MS Access/VBA Question - Using Multiple combo Boxes to Search on a Form
    ... -I have a form with several combo boxes and several text ... a button is clicked which launches a new form (frmResults). ... frmResults is bound to a query, the criteria of which is set to the ... specify anything for a particular field. ...
    (microsoft.public.office.developer.vba)
  • Re: ASP / Access: use of same table twice in one query
    ... are in the same table and I need them both in one query. ... I agree it is better to specify the fields I need in the select statement, ... >> The data is stored in an Access database. ... > quicker response by posting to the newsgroup. ...
    (microsoft.public.inetserver.asp.db)
  • Re: Query records with single Dates Automatically
    ... both queries pull from the same table. ... -- Two Tables Attendees and Visits ... Please copy and post the SQL of your query. ... I have to find a way to specify ...
    (microsoft.public.access.queries)
  • RE: build an if statement with conditional parameters
    ... This is my modified code, no errors, but like I said, I can query with just ... Dave Hargis, Microsoft Access MVP ... "David Pelizzari" wrote: ... specify a date, and leave the site blank, and get nothing back, if I specify ...
    (microsoft.public.access.queries)