Board index » delphi » Adotable1.seek('test',soFirstEQ) = not supported...?

Adotable1.seek('test',soFirstEQ) = not supported...?

I use an access2000 table

my code :

adotable1.indexfieldnames := 'name';
adotable1.seek('test',soFirstEQ);
   // the operation requested by the application is not supported by  the
provider?

the provider that i use = Microsoft jet oledb 4.0

 

Re:Adotable1.seek('test',soFirstEQ) = not supported...?


Hi,

Quote
> I use an access2000 table

> my code :

> adotable1.indexfieldnames := 'name';
> adotable1.seek('test',soFirstEQ);
>    // the operation requested by the application is not supported by
the
> provider?

This works only if:
- you use a clUseServer cursor location (which implies using a
ctKeyset cursor type);
- you use a cmdTableDirect command type (which implies using a
TADODataset instead of a TADOTable).

See here for details:
http://support.microsoft.com/support/kb/articles/Q243/4/65.ASP

Thrse

Other Threads