Re: Opening CE database for seek when multiple search orders specified

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Peter Foot [MVP] (feedback_at_nospam-inthehand.com)
Date: 03/22/04 

Date: Mon, 22 Mar 2004 13:13:23 -0000

When you call CeOpenDatabase you specify which index (sort-order) is used
during that database session. Therefore you should specify one of the sort
orders of the MSysFields table. You can query these with the CeGetOidInfoEx
function from the MSysFields table Oid.

Peter 

-- 
Peter Foot
Windows Embedded MVP
OpenNETCF.org Senior Advisor
www.inthehand.com | www.opennetcf.org
"Paul Perkins" <paul.perkins@nospam.thanks.com> wrote in message 
news:1079954715.774486@ernani.logica.co.uk...
> Hi All,
>
> This is a repeat of a previously posted question, but hopefully in a more 
> understandable way :)
>
> How do I open a CE database using the CeOpenDatabase RAPI function on a 
> database that was created with more than one sort order in such a way that 
> CeSeekDatabase can be used with the CEDB_SEEK_VALUEFIRSTEQUAL flag?
>
> I need to search the MSysFields table to query the column names of tables. 
> It *works* by stepping over each row in the table and comparing the key 
> against what I'm looking for, but it's very slow. I need to use an indexed 
> seek to speed up the UI.
>
> Please help!
>
>     Paul.
>

Relevant Pages

  • Re: Sort database alphabetically
    ... What I am saying is that you cannot sort the database, ... So all you need to do is add "ORDER BY Name" to your existing query. ... In the Query Designer screen use the Sort Order column to specify ...
    (microsoft.public.sqlserver.server)
  • Re: Access database records not sorted
    ... Just because you sort and display your data within Access ... Also you need to specify whether your code is using ADO or DAO. ... You'll obviously need to set the database path, table name, ...
    (microsoft.public.word.vba.general)
  • Re: Import Text with existing schema.ini file utility
    ... the database engine looks for schema.ini. ... As far as I know it's not possible to specify schema.ini in SQL; ... DAO is specifically designed to work with the Jet ... >> oDB.Execute strSQL ...
    (microsoft.public.access.modulesdaovba)
  • Re: Primary Key not sorted
    ... Are you willing to rely on any "natural" sort of records? ... > though the Company field is the Primary Key but if I ... When I Compact and Repair the database it ...
    (microsoft.public.access.tablesdbdesign)
  • Re: KirbyBase
    ... creating objects from the database records was much easier. ... Hal, I don't know if you have had a chance to take a look at the beta yet, but I basically tried to implement a uniform way to specify one-to-one links, one-to-many links, and calculated fields in the ... I suppose it would in effect be embedding an array where all the ... My first couple of attempts at adding more complexity to KirbyBase did not honor this concept. ...
    (comp.lang.ruby)