Solved

Dbase program error handling

Posted on 2010-08-16
5
620 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

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.
This article will inform Clients about common and important expectations from the freelancers (Experts) who are looking at your Gig.
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…
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

710 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