Every now and then I have to do some database work (ug!). This is one of
those moments and my lack of practice is starting to show.
I am trying to create a secondary index for a table. It should be straight
forward but it ain't.
I am creating the field definitions for the table and then creating the
table. Everything is fine if I don't try and define a secondary index. If I
try to define the index then when I call myTalbe.Create I get an "Invalid
index/tag name" error, followed by a "Table does not exist" (all in the same
message). This made me think that the index should be defined after the
table was created, but then I just get the invalid index/tag name error. The
field I am trying to index on is called 'D'. The index name I am trying to
give it is 'SORTD'. It is a string field and I am not setting any of the
TIndexOptions. I can create the index in Database Desktop without any
problems after the table is created so I am unsure what to try next.
Thanks for any help.
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
To UnSub, send email to: [EMAIL PROTECTED]
with body of "unsubscribe delphi"
