Additional
dbCAP
AnyDAC
ThinDAC
NCOCI8
Topic: ADTable and Indexes
ADTable and Indexes
Posted: 2007/10/12 14:27
 
I'm replacing TTable with TADTable and I can't set ADTable1.IndexName := 'ByLastName';
Error: "ADTable1: Index '' not found."
I get Indexenames from ADMetaInfoQuery, put them on a Combobox and select one item.

{-------------}
procedure ComboBox1Change(Sender: TOBject);
begin
ADTable1.IndexName := ComboBox.Text;
ADTable1.SetKey;
ADTable1.First;
end;

Is something missing?

Best Regards

Francisco Alvarado
Re:ADTable and Indexes
Posted: 2007/10/13 06:22
 
I read other post about Missing IndexesNames with MuSQL and I defined two indexes in TADTable.Indexes, write one of them in TDADTable.IndexName property and it resulted in same error when executed.
Is there any way to set an index in TADTable?
This is an application about five years old written in Delphi 5 and using Paradox tables now upgrading to Oracle 9i using D5, for now, I must replace all Ttables with TADTables not TADQueries. Can I set and change a Index in TADTable or I need, for now, to use TADOTables?
Best Regards
Francisco
Re:ADTable and Indexes
Posted: 2007/10/13 08:55
 
Hello

This issue is fixed in v 2.0.4.

Regards,
Dmitry