Peter
Wed Nov 26 03:38:05 CST 2003
You can create up to 4 indexes on a table. These should be used on fields
which you intend to use for searching or ordering data by. They are created
using the SQL statement CREATE INDEX and once created are used by the
querying process automatically - you don't need to specify anything in your
query to use the index. See here for the syntax for creating an index
http://www.inthehand.com/documentation/adoce/sql/createindex.html
Peter
--
Peter Foot
Windows Embedded MVP
OpenNETCF.org Senior Advisor
www.inthehand.com | www.opennetcf.org
"Renato Edson Figueiredo Junior" <reete@ggf.com> wrote in message
news:%23QHhCP3sDHA.3536@tk2msftngp13.phx.gbl...
> Anybody knows how to use indexes in Pocket Acess ?
>
> renato e. figueiredo jr. project manager ACTIVE automação na indústria
> farmacêutica 55 11 4994.4600
>
>