da-soft - Data Access Technologies

Additional

dbCAP

AnyDAC

ThinDAC

NCOCI8

Topic: Missing IndexNames wih MYSQL

Forum List » AnyDAC » v 1.x General English

BenjoD
User

Fresh Boarder

Posts: 1

Karma: 0

Missing IndexNames wih MYSQL

Posted: 2007/08/27 20:20

Hello there.

I am fairly new to both AnyDAC and MySQL. I am able to setup a TAdTable and browse it in a grid. My problem is that the IndexName property is empty. I can see the indexes in AdExplorer (referred to as Indexed Columns).

Thank you for any help.

Benjo Dans

Diman

Admin

Posts: 1495

Karma: 19

Re:Missing IndexNames wih MYSQL

Posted: 2007/08/27 21:00

Hello

1) TADTable.IndexName is name of one of index, defined in TADTable.Indexes. This collection is not filled automatically by server side indexes. You can fill it by hands at design time or run time.
2) TADTable.IndexFieldNames may contain any field names, separated by ';'.
3) Setting either of properties, will rebuild the SELECT query and will append ORDER BY to the query.
4) TADTable is here only for compatibility with BDE. If you are just starting, then forget this component and use TADQuery.

Regards,
Dmitry

Forum List » AnyDAC » v 1.x General English