Programming with dBASE - Language Drivers Error

Author

Language Drivers Error

Larry Hakel

2006-02-07, 8:23 pm

I have a customer that has reported the following error.

Data Base Error: Language Driver of Table and Indexes do not match.

I am at a loss to understand how that may have occurred. So far this
is the only customer with this problem. The application has more than
100 tables. She received this error while doing our reindexing.

Is there a way to correct this or will I have to rebuild each and
every table?

Any help will be appreciated.

Larry

*Lysander*

2006-02-08, 3:23 am

In article < 382iu15dd24q61t4but0
n69v78hhtv92b6@4ax.com>,=20
adv_dataNOSPAM@ads-software.com says...

> I am at a loss to understand how that may have occurred. =20

Any chance that she was making a copy of the tables, reindexing with=20
another BDE-setting, and later copying back the old tables, this time=20
only copying the *.dbf??

You in any case have to check WHICH LD has the table now, and if this is=20
the same as it was meant to be. LDs do not get changed by magic. Most=20
likely some change in the BDE-setting is involved.

> Is there a way to correct this or will I have to rebuild each and
> every table?

Depending on what was causing this, I think there will be a solution to=20
do it efficiently. If you do not have the structures of your tables=20
documented then you would need a program looping through all tables'=20
definitions and do a loop with copystructure/append/copyback.=20

--=20
ciao,
Andr=E9

Larry Hakel

2006-02-09, 3:23 am

I'm using the Rebuild Indexes

/*
REBUILD INDEXES.PRG
Program Generated by 'CreateReindex.prg' in the dUFLP library.
Date generated: 02/07/2006
This will delete index tags and rebuild from
scratch ...
*/
//snip//
// -- ACCOUNT.DBF
fMessage.message.text = 'ACCOUNT.DBF'
fMessage.repaint()
try
d.dropIndex( 'ACCOUNT.DBF', 'ACCOUNT_TYPE' )
catch (dbException e)
if e.code # 239 // index does not exist
msgbox( 'Error: '+e.code+chr(13)+e.message )
endif
endtry

//snip//
// rebuild index tags ...
i = new DBFIndex() // undocumented feature
// index tag: ACCOUNT_TYPE
i.expression := 'account_type+accoun
t'
i.descending := false
i.unique := false
i.forExpression := ''
i.indexName := 'ACCOUNT_TYPE'
d.createIndex( 'ACCOUNT.DBF', i ) // PROBLEM LINE

Every time the code comes to the d.createIndex(... the following error
is genereated. "Data Base Error: Language Driver of Table and Indexes
do not match." But not for every table. The tablelevel in the BDE
Administrator is set at 7 in our application and on the customer's
computer.

This error also occurs in a datamodule when the table is made active.
And again it is not all the tables.

I was on the telephone with this customer installing the application
when the error first occurred. This has been installed litterally
100s of times without this error.

Now today a second customer reported the same error. So I'm in the
process of recreating each of my tables and their indexes.

Has anybody got any other ideas?

Thanks.

Larry

On Tue, 07 Feb 2006 16:00:05 -0500, Larry Hakel
<adv_dataNOSPAM@ads-software.com> wrote:

>I have a customer that has reported the following error.
>
>Data Base Error: Language Driver of Table and Indexes do not match.
>
>I am at a loss to understand how that may have occurred. So far this
>is the only customer with this problem. The application has more than
>100 tables. She received this error while doing our reindexing.
>
>Is there a way to correct this or will I have to rebuild each and
>every table?
>
>Any help will be appreciated.
>
>Larry

Ivar B. Jessen

2006-02-09, 3:23 am

On Wed, 08 Feb 2006 18:10:03 -0500, in dbase.programming,
Subject: Re: Language Drivers Error,
Message-ID: < nmtku1p5aqvli9um8jpq
4he8ltq1o95sjk@4ax.com>,
Larry Hakel <adv_dataNOSPAM@ads-software.com> wrote:

>I'm using the Rebuild Indexes
>
>/*
> REBUILD INDEXES.PRG
> Program Generated by 'CreateReindex.prg' in the dUFLP library.
> Date generated: 02/07/2006
> This will delete index tags and rebuild from
> scratch ...
>*/

You have an older version of :duflp:CreateReindex
.prg, try if the latest version
which handles things a little differently will improve the situation.

Ivar B. Jessen

Larry Hakel

2006-02-11, 11:23 am

Thanks Ivar
Changing to the new Create Indexes version solved the problem with
these two customers however now others have reported "Data Base Engine
Error: Invalid Index Descriptor". This error I reported to the
newsgroup about a year ago and was not able to resolve it. So I ended
up using Reindex instead. Last week when the customer reported
getting an indexing problem I sent them the Rebuild Indexes that
resulted in the Database Engine Error: Language Driver for Table and
Indexes don't match. Like I said changing to the new Create Indexes
solved that.

But now I am back the the dreaded "Data Base Engine Error: Invalid
Index Descriptor". Both errors pointed to the same line

d.createIndex( 'account', i ) // create it

I don't like using Reindex but quess I'll have to go back to it.
Unless you or anyone else has a solution.

Larry

On Thu, 09 Feb 2006 06:47:18 +0100, Ivar B. Jessen
<bergishagen@it.notthis.dk> wrote:

>On Wed, 08 Feb 2006 18:10:03 -0500, in dbase.programming,
>Subject: Re: Language Drivers Error,
>Message-ID: < nmtku1p5aqvli9um8jpq
4he8ltq1o95sjk@4ax.com>,
>Larry Hakel <adv_dataNOSPAM@ads-software.com> wrote:
>
>
>You have an older version of :duflp:CreateReindex
.prg, try if the latest version
>which handles things a little differently will improve the situation.
>
>
>Ivar B. Jessen

Ivar B. Jessen

2006-02-11, 1:23 pm

On Sat, 11 Feb 2006 11:47:26 -0500, in dbase.programming,
Subject: Re: Language Drivers Error,
Message-ID: < ai4su19khjkuv2m30gr3
f1vp7s8g5rkja5@4ax.com>,
Larry Hakel <adv_dataNOSPAM@ads-software.com> wrote:

>Thanks Ivar
>Changing to the new Create Indexes version solved the problem with
>these two customers

I take this to mean that using the latest version of CreateReindex.prg and
rebuildIndexes.prg fixed the problem for good at those two customers.

>however now others have reported "Data Base Engine
>Error: Invalid Index Descriptor". This error I reported to the
>newsgroup about a year ago and was not able to resolve it. So I ended
>up using Reindex instead. Last week when the customer reported
>getting an indexing problem I sent them the Rebuild Indexes that
>resulted in the Database Engine Error: Language Driver for Table and
>Indexes don't match.

Hmm, why did you send the customer a version of RebuildIndexes.prg that resulted
in the mentioned error?

>Like I said changing to the new Create Indexes
>solved that.

Are you saying that you _then_ sent them the latest version of
RebuildIndexes.prg and it fixed the problem for good?

>
>But now I am back the the dreaded "Data Base Engine Error: Invalid
>Index Descriptor". Both errors pointed to the same line

Why are you back to this error? Is this error reported by the same two or three
customers who used the latest version of RebuildIndexes.prg or by some other
customers, i.e. a new problem?

>
> d.createIndex( 'account', i ) // create it
>
>I don't like using Reindex but quess I'll have to go back to it.
>Unless you or anyone else has a solution.

The error: (10049) "Language Drivers of Table and Index do not match",

is easy to reproduce. It could indicate that you at one time used a language
driver different from the one you are using now and that you, maybe by copying a
table without its mdx from an old backup or from an exe, end up with a table
with one language driver and a mdx with a different language driver.

The error: (10023) Invalid index descriptor,

is also easy to reproduce. It pops up when you attempt to use a non-existent
field name in the line: i.expression := 'account_type+accoun
t'

Again assuming that you use an outdated backup, could it be that a field name in
the index expression is slightly different from the one used in the backup
table.

This is all pure guesswork and it will be interesting to hear if it has anything
to do with real life :-)

Ivar B. Jessen

Sponsored Links