Re: reindexing DBF files

Hi,

Tquery means BDE. I' m trying to forget that something ugly and slow like
the BDE ever existed. In my last BDE-project the first thing I changed was
the use of the BDE (speed gain > 1000 %). Because of that, I can't tell you
SQL commands for reindexing DBF files via the BDE. I doubt that the normal
SQL syntax (create Index ... on ...) will work

IIRC the TTable class has properties like IndexDefs and IndexFiles. Creation
of indexes is part of CreateTable method. The BDE does not support all forms
of Dbase indexes (NDX, MDX are ok, while NTX and CDX are not).

Maybe I don't understand your problem correctly, because for an import into
a SQL server the indexes are not needed.
You can use the database explorer of the BDE to create and rebuild indexes.
What for do you need a SQL version command to reindex a database that is not
designed for use with SQL? It can't be just for your import function.

Peter



"Tonic" <tonic78PUTOSPAM@xxxxxxxxxxxxxxxxxx> schrieb im Newsbeitrag
news:3f0chdF59c1gU1@xxxxxxxxxxxxxxxxx
> But I can do it in Delphi, using a TQuery?
> This is I'm triyng to do.
>
> Thanks,
> Tonic
>
> "Peter" <NoSpam@xxxxxxxxxxxxxxxxx> escribió en el mensaje
> news:d628cb$m53$00$1@xxxxxxxxxxxxxxxxxxxx
>> Hi Tonic,
>>
>> > I am trying to make a move all the information I have in dbf files to a
>> > Sql
>> > Server Database. So I want to reindex all the dbf tables first, but I
>> > don't
>> > know which sql command can do it. Can anyone help me?
>> > Thanks,
>> > Tonic
>>
>> Since Delphi does not offer native support for Dbase files, it depends on
>> the way you use thes files.
>>
>> For an import into a SQL server you don't need these files anyway. You
>> can
>> delete them before import. If you have Dbase or FoxPro you can use the
>> command Reindex within these programs. With Clipper or Visual Objects you
>> can use the included programs to reindex.
>>
>> HTH
>> Peter
>>
>>
>
>


.

Relevant Pages

  • Re: group and sort by month / site
    ... i'll try to start from scratch using the BDE view perhaps? ... "Gary Walter" wrote: ... "part of an aggregate function" because ... From your SQL, it should look like: ...
    (microsoft.public.access.queries)
  • Ntext Field Not Read by BDE
    ... that does SQL Quering on the SQL table. ... I ended up determining that it was not the ODBC connection, ... speaking the BDE either (although it only works on the MSSQL Driver, ... ntext field within it. ...
    (microsoft.public.sqlserver.server)
  • Re: SQL -> Oracle
    ... > with BDE (using regular TQuery and TDatabase). ... MS SQL 2007 won't provide SQL links which work with the BDE... ... > automatically converts query texts from SQL to Oracle? ...
    (borland.public.delphi.non-technical)
  • SQL 2000 Timeout Issues Since Converting from BDE to ADO
    ... multi-user application which runs against either SQL ... 2000 or Oracle which we recently converted to ADO from BDE. ... application to use ADO basically by converting the BDE components to ADO ...
    (borland.public.delphi.database.ado)