Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 623
  • Last Modified:

Dbase program error handling

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
NAEDI
Asked:
NAEDI
  • 3
  • 2
1 Solution
 
pcelbaCommented:
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
 
NAEDIAuthor Commented:
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
 
pcelbaCommented:
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
 
pcelbaCommented:
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
 
NAEDIAuthor Commented:
Thank you.  This is exactly what I was looking for.
0

Featured Post

Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now