dbTalk Databases Forums  

Index Structure collection

comp.databases.xbase.codebase comp.databases.xbase.codebase


Discuss Index Structure collection in the comp.databases.xbase.codebase forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Piero Salandin
 
Posts: n/a

Default Index Structure collection - 05-19-2008 , 02:00 AM






Hi there! I hope someone can help me with this question.
The short form is:
how can I know when an index i sascending or descending?

The long form is:

I have a Codebase Delphi Application (actually Delphi 5.0), in which
I have to check and, in case, modify, the structure of fields and tags
in a collection of tables.

Regadring tags/indexes, which is the problem, I use the TAG4INFO structure
to build indexes:

lData4File := d4Create(lcb,PFileName,
PFIELD4INFO(lfiPtr),
PTAG4INFO(ltiPtr));

actually, the TAG4INFO structure is as following:

TAG4INFO = Record
name : PChar;
expression : PChar;
filter : PChar;
unique : SmallInt;
descending : Word;
end;

Yhe problem arises when I have to check the tag/index structure for an
existing table; I use the tag info functions to retrieve these informations,
which can be invoked once a pointer to the tag is captured:

lsTAlias := t4alias(MyT4);
lsTExpr := t4expr(MyT4);
lsTFiltr := t4filter(MyT4);
liTUnique := t4Unique(MyT4);

The problem is that there seems to be NO FUCNTION FOR THE DESCENDING
attribute of a tag! How can I know if an index is ascending or descending?


Best regards and thank you
Piero Salandin
P.S.: remove the nospam from the address to write directly.

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.