when using sql anywhere 11.0.1 and has patched to 2308, I found that in
Delphi 7, using ADOconnection and adotable, click the tablename, it will
apper an "object or the provider can not perform the required operation"
,and in the sqlwhywhere 10.0 version, adotable can not using the table who
have a primary key

What happens when you add either a primary key, or a unique table constraint
or even just a unique not null index? Do both problems go away?

"antx3" <antx3111 (AT) 163 (DOT) com> wrote

From: antx3111 <antx3111 (AT) 163 (DOT) com> 10/11/2009 02:03 AM

Thanks for your help.
One has a primary key of the table, such as Create table t1 (dm Char (2) not
Null, mc Varchar (20) Null, CONSTRAINT "t1" Primary Key ( "dm" ASC) );
In Delphi 7, using ADO connection (Provider = SAOLEDB.11; Password = sql;
User ID = dba; eng = mydb) and adotable ,datasoucer and dbgrid control ; and
there are nothing for choose in the adotable.IndexName properties, and when
running the simple program, it will show "index file t1 not found".

"Nick Elson [Sybase iAnywhere]" <@nick@.@elson@@sybase@.@com@> wrote in
message news:4acdf762 (AT) forums-1-dub (DOT) ..

Please respond to the newsgroup thread ... I just got back
from a short vacation ...

Since you have a primary key then I would presume your
..Net adapter is at fault somehow. If you are not using
the SQL Anywhere data adapter then try that out next.

If you are using the V11.0.1 data adapter I would recommend
opening up a support case to track this in greater detail
than would be possible in a newsgroup thread. It is likely
one will need the source code and database schema to
see what is actually happening.



"Nick Elson [Sybase iAnywhere]" <@nick@.@elson@@sybase@.@com@> wrote in
message news:4ad5de7f$1 (AT) forums-1-dub (DOT) ..