Solved

Dbase program error handling

Posted on 2010-08-16
5
617 Views
Last Modified: 2013-11-24
I have a Dbase utility program that reindexes files once a day.  It suddenly has been stopping on an error that says "language driver" mismatch and prompts you to fail, open read-only or reindex.  It always reindexes fine and I can't seem to resolve the language driver issue.

So how do you programatically trap or respond to this error and force the reindex without having any user interaction?
0
Comment
Question by:NAEDI
  • 3
  • 2
5 Comments
 
LVL 42

Expert Comment

by:pcelba
ID: 33445557
Such error message should be documented by the utility vendor. The only option when no documentation exists probably is to avoid conditions in which the error appears.

0
 

Author Comment

by:NAEDI
ID: 33445881
There is no vendor.  The utility program is just some DBase code, nothing third-party.  And the code simply calls these command for several tables.

USE EXTDTAIL INDEX EXTDTAIL
PACK
CLOSE ALL

USE EXTHEAD INDEX EXTHEAD
PACK
CLOSE ALL

USE EXTKBAN
PACK
CLOSE ALL
0
 
LVL 42

Expert Comment

by:pcelba
ID: 33446234
OK, and what says Dbase documentation about this error?

You should check code page and Windows regional settings used for this program. Do you use some non-US collation or order? Do you have all necessary NLS packs installed?

The solution could be following:
You should bring up the dBASE SE Desktop Properties dialog. If dQuery is open you must first close it. Then with focus at the command or navigator windows, the menu "Properties" should be displayed -- select this, and then select "Desktop Properties". In this dialog, make sure that the following settings are done:

Country tab, the Century checkbox should be checked (this is like typing SET CENTURY ON, and is used to display all four digits of the year in dates), and you may want to set Alert on mismatch off (uncheck it)
0
 
LVL 42

Accepted Solution

by:
pcelba earned 500 total points
ID: 33446257
An alternate solution is  SET LDCHECK OFF issued in Command window. More info is here: http://www.dbase.com/Knowledgebase/faq/language_drivers.asp
0
 

Author Closing Comment

by:NAEDI
ID: 33446424
Thank you.  This is exactly what I was looking for.
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Where is user Lync data stored 4 120
Auto-indent certain lines in Notepad++ 10 144
Windows 10, Hotmail and AdChoices 7 33
Getting Variable not defined error in Python 1 38
Displaying an arrayList in a listView using the default adapter is rarely the best solution. To get full control of your display data, and to be able to refresh it after editing, requires the use of a custom adapter.
In this post we will learn different types of Android Layout and some basics of an Android App.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…

713 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question