Hello,

I am using OLEDB to access SQL2000i data from Visual Basic.

I have the ddf files and have sucessfully created the database within
SQL2000i. I can look at the table structure etc but I cannot see any
information relating to the indexes. The properties state that there are 5
indexes. This is also confirmed by BtrSearch where I can also see how the
indexes are segmented.

However to use the indexes in OLEDB, I need to know the index names.

Any ideas how I can either get the index names out of SQL 2000i or get the
index names programatically?

Cheers

Chris

In the Pervasive Control Center, right click on the table and select
"Tasks/Edit Table Design". This window will provide the index names.

If this isn't quite so useful to you, then I have a DDF printing utility that
may be helpful. It takes the DDF definitions, reads them from the Btrieve
layer, and prints out (to screen, but it can also be sent to a file or to the
printer) the data file definitions. I believe the registered version will
display index names, as well as the fields included in there.
Goldstar Software Inc.
Building on Btrieve(R) for the Future(SM)
Bill Bach
BillBach (AT) goldstarsoftware (DOT) com
http://www.goldstarsoftware.com
*** Pervasive.SQL Service & Support Classes ***
Chicago: November 16-19, 2004: See our web site for details!


Chris Smith wrote:

Bill

I have looked in the PCC at the Edit table design and there is no
information present for the index names / strucutre. I know the indexes
exist as I can see the structure in BtrSearch but the actual indexes names
are knowhere to be seen.

The DDF printing utility sounds useful. Can you let me know how to obtain a
copy / license.

Kind regards,

Chris Smith
"Bill Bach" <bbach (AT) cncdsl (DOT) com> wrote

If you don't see them, then they are defined by Btrieve, but NOT by the DDF's.
You may be able to add the index definitions from the Edit Table Design
function. However, this tool is known to be quite flaky, so I would STRONGLY
recommend making a backup of your DDF's before starting, and periodically as you
successfully complete each index.

You can get a copy of the free DOS-based FPrint from
www.goldstarsoftware.com/download.asp -- the purchased version is fairly cheap
and offers a few more options, product support, and true Win32 operations.
Goldstar Software Inc.
Building on Btrieve(R) for the Future(SM)
Bill Bach
BillBach (AT) goldstarsoftware (DOT) com
http://www.goldstarsoftware.com
*** Pervasive.SQL Service & Support Classes ***
Chicago: November 16-19, 2004: See our web site for details!


Chris Smith wrote:

Bill,

Would adding the indexes via the Edit Table Design function mess up any
indexes defined by Btrieve? For instance if by some coincidence the index
names were the same etc would the DDF index overwrite the Btrieve index?

Kind regards,

Chris Smith
"Bill Bach" <bbach (AT) cncdsl (DOT) com> wrote

If you are in "UNLINKED" mode (see lower right corner), then the changes will
impact the DDF's ONLY.
Goldstar Software Inc.
Building on Btrieve(R) for the Future(SM)
Bill Bach
BillBach (AT) goldstarsoftware (DOT) com
http://www.goldstarsoftware.com
*** Pervasive.SQL Service & Support Classes ***
Chicago: November 16-19, 2004: See our web site for details!


Chris Smith wrote:

Bill,

I am in Linked mode...Being fairly new to Btrieve and Pervasive what does
this mean?

Will adding indexes here mess up the Btrieve indexes?

If this is the case can you point me towards a good concise guide for using
the Btrieve API from Visual Basic.

Many thanks,

Chris Smith

"Bill Bach" <bbach (AT) cncdsl (DOT) com> wrote

In addition to this, I have just had the index names confirmed by the
Software developer whos data I am accessing.

Even though I now have the name I still cant set the index. Is this due to
the fact that they are not contatained within the DDF files?

Chris
"Chris Smith" <chris (AT) bitsltd (DOT) co.uk> wrote

Yes. Go to Tools/Options and uncheck "Table Linked Mode" to switch to UNLINKED
mode. You must fix the DDF's. Better yet -- have the devceloper give you good
DDF's -- this would be a much better solution and would save you lots of time.
Goldstar Software Inc.
Building on Btrieve(R) for the Future(SM)
Bill Bach
BillBach (AT) goldstarsoftware (DOT) com
http://www.goldstarsoftware.com
*** Pervasive.SQL Service & Support Classes ***
Chicago: November 16-19, 2004: See our web site for details!



Chris Smith wrote:

On Tue, 16 Nov 2004 08:56:52 -0000, "Chris Smith"
<chris (AT) bitsltd (DOT) co.uk> wrote:

I believe there is some confusion as to exactly what information is
stroed in a Btrieve file about the Btrieve file.
All that is stored (besides your records) in a Btrieve data file is:
1) Record length, 2) Variable records (y/n)
3) Key Offset and Length as well as 4) key data types.
The offset and legths are stored as 2 byte integers and the key data
type is stored as another byte. There are no "names" stored in the
file. Any byte not in a key is a byte... no data type associated.

Bill is correct, in linked mode if you make changes in the table
designer on the SQL side, the Btrieve file is modified accordingly,
e.g. adding a SQL index will add a Key to the file.
If your goal is to fix the DDFs then UNLINKED should be showing in the
bottom right corner of table designer.

Leonard