Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Reindex DBF Table !!

2 posts in FoxPro Last posting was on 2007-11-16 18:43:03.0Z
Hugo Posted on 2007-11-16 06:32:02.0Z
From: "Hugo" <gomh7172@hotmail.com>
Newsgroups: advantage.foxpro
Subject: Reindex DBF Table !!
Date: Thu, 15 Nov 2007 22:32:02 -0800
Lines: 11
Organization: Cibernetica de Mexico
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: 189.165.7.11
Message-ID: <473d1bd7@solutions.advantagedatabase.com>
X-Trace: 15 Nov 2007 21:25:59 -0700, 189.165.7.11
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!189.165.7.11
Xref: solutions.advantagedatabase.com Advantage.FoxPro:240
Article PK: 1109594

Hi,

How Can I reindex a DBF-CDX table, from VFP with OLEDB.

Somebody have an example ?

Thank's
Hugo
Cibernetica de Mexico


Mark Wilkins Posted on 2007-11-16 18:43:03.0Z
From: "Mark Wilkins" <mark@no.email>
Newsgroups: advantage.foxpro
References: <473d1bd7@solutions.advantagedatabase.com>
Subject: Re: Reindex DBF Table !!
Date: Fri, 16 Nov 2007 11:43:03 -0700
Lines: 35
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-RFC2646: Format=Flowed; Response
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198
NNTP-Posting-Host: 10.24.38.228
Message-ID: <473de37a@solutions.advantagedatabase.com>
X-Trace: 16 Nov 2007 11:37:46 -0700, 10.24.38.228
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!10.24.38.228
Xref: solutions.advantagedatabase.com Advantage.FoxPro:241
Article PK: 1109595

Hi Hugo,

There is not currently a system procedure for doing a reindex (it seems like
there should be ... but it has never been created apparently). There is a
system procedure to do a table pack (remove deleted records). After the
pack, Advantage will reindex the table ... but if you want to keep the
deleted records, this is obviously not an option. The system procedure is
sp_PackTable.

Run an SQL statement such as:
execute procedure sp_packtable( '\\server\share\data\file.dbf' );

Aside from this, I think the only option would be through DROP INDEX/CREATE
INDEX statements or a stored procedure that you write.

Mark Wilkins
Advantage R&D

"Hugo" <gomh7172@hotmail.com> wrote in message
news:473d1bd7@solutions.advantagedatabase.com...
> Hi,
>
> How Can I reindex a DBF-CDX table, from VFP with OLEDB.
>
> Somebody have an example ?
>
> Thank's
> Hugo
> Cibernetica de Mexico
>
>