Database Engine Error?

[Bill Pappathopoulos]

When I run some very basic dBASE code (either called from some other
process or run from the command window) I regularly have the processing
stop with a "Database Engine Error" message that says "Full dBASE
exxpression not supported", but the fix or debug options usually point
to a line in the code that is functionally the same as some previous
lines of code that operated correctly. If I select the ignore option,
the program runs through, and when I look at the results, it appears
that the line at which processing was interrupted has actually been
executed correctly after the ignore.

Here is an example:

use invtrx index invtrx exclusive
zap
use timetrx index timetrx exclusive
zap
use exptrx index exptrx exclusive
zap
use wotrx index wotrx exclusive
zap
use assytemp index assytemp exclusive
zap
use

The error message comes up pointing to line 9 even though the same basic
expression was invoked 4 times earlier in this simple operation.

Can anyone point me in the right direction here?

---------------- Bill

[Ken Mayer [dBASE, Inc.]]

Post by Bill Pappathopoulos
When I run some very basic dBASE code (either called from some other
process or run from the command window) I regularly have the processing
stop with a "Database Engine Error" message that says "Full dBASE
exxpression not supported", but the fix or debug options usually point
to a line in the code that is functionally the same as some previous
lines of code that operated correctly. If I select the ignore option,
the program runs through, and when I look at the results, it appears
that the line at which processing was interrupted has actually been
executed correctly after the ignore.

Please provide *exact* steps to reproduce a problem. There's a message
in this newsgroup that I periodically repost, titled "Guidelines for
Posting Bug Reports" ... I will repost it shortly.

Ken
---
Ken Mayer [dBASE, Inc.]
** Please respond ONLY in the newsgroups **

"Think OOP"

dBASE, Inc. website: http://www.dbase.com

[Geoff Wass]

Bill,

If the table is from, say, dBASE 5.x and you are using dBASE PLUS (actually
dBASE 7.x or later), the table likely containings a index based on a formula
and that formula contains a function which is no longer supported in index
formulas. Check the online help for "INDEX" and review the list of permitted
functions. Likely you are using something like TRANSFORM() which is no
longer allowed.
--
:-)


----------
Geoff Wass (dBVIPS)
Montréal, Québec, Canada


==========
=======
====
=
More dBASE information at http://geocities.com/geoff_wass

Please reply in the news groups only.
Have you backed up your work?!
=
====
=======
==========

Post by Bill Pappathopoulos
When I run some very basic dBASE code (either called from some other
process or run from the command window) I regularly have the processing
stop with a "Database Engine Error" message that says "Full dBASE
exxpression not supported", but the fix or debug options usually point
to a line in the code that is functionally the same as some previous
lines of code that operated correctly. If I select the ignore option,
the program runs through, and when I look at the results, it appears
that the line at which processing was interrupted has actually been
executed correctly after the ignore.
use invtrx index invtrx exclusive
zap
use timetrx index timetrx exclusive
zap
use exptrx index exptrx exclusive
zap
use wotrx index wotrx exclusive
zap
use assytemp index assytemp exclusive
zap
use
The error message comes up pointing to line 9 even though the same basic
expression was invoked 4 times earlier in this simple operation.
Can anyone point me in the right direction here?
---------------- Bill