
Click above to get retro games delivered to your door ever month!
X-Hacker.org- Mach SIx v1.1c - Reference Guide - Norton Guide
[<<Previous Entry] [^^Up^^] [Next Entry>>] [Menu] [About The Guide]
m6_Error():
Purpose: Used to check if an error occurred during the last command or
function executed. Error codes 2000 through 2027 indicate
why an expression was not optimizable by Mach SIx. See below
for a complete list of error codes.
Syntax: m6_Error()
Returns: Error code for last command/function. A value of 0 indicates
no error occurred. The following is a list of the possible
error codes:
2001 No database in use
2003 Driver not supported
2005 No index(es) in use
2007 Database contains over 524 million records
2009 No matching index expression(s) found
2011 Indeterminate
2013 Missing quote ( [, ], ', " )
2015 Missing parenthesis
2017 Syntax error
2019 Data type error
2021 No filter active
2025 Low memory
2027 Automatic optimization off
2101 Maximum number of Clipper array elements(4096) exceeded
2103 Unknown operator
2105 Stack overflow
2107 Stack underflow
2109 Unknown map type
2113 Deferred stack overflow
Example:
#include "DBFSIX.CH"
#include "MACHSIX.CH"
? m6_IsOptimize( "age = 25" ) //......0
? m6_Error() //...2001
USE Names VIA "DBFSIX"
//..........................................No indexes in use
? m6_IsOptimize( "age = 25" ) //......0
? m6_Error() //...2005
SET INDEX TO City, Name
//...............................No matching index expression
? m6_IsOptimize( "age = 25" ) //......0
? m6_Error() //...2009
//..............................................Missing quote
? m6_IsOptimize( "state = 'CA" ) //......0
? m6_Error() //...2013
//...............................................Syntax error
? m6_IsOptimize( "state = 'CA' .AND" ) //......0
? m6_Error() //...2017
Online resources provided by: http://www.X-Hacker.org --- NG 2 HTML conversion by Dave Pearson