Solved

Dbase program error handling

Posted on 2010-08-16
5
609 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 41

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 41

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 41

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

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
wordmultiple challenge 12 121
Looking for example pivot year code used in Y2K 4 62
Hide vba in gp 7 83
C# DataGridView_RowsAdded event not firing 1 66
This article will show, step by step, how to integrate R code into a R Sweave document
Deploying a Microsoft Access application in a Citrix environment is not difficult but takes a few steps. However, Citrix system people are often of little help, as they typically know next to nothing about Access. The script provided here will take …
Viewers will learn the different options available in the Backstage view in Excel 2013.
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…

863 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

Need Help in Real-Time?

Connect with top rated Experts

25 Experts available now in Live!

Get 1:1 Help Now