All functions   Mac OS X   Windows   Crossplatform   Components   New in version: 1.0   1.1   1.2   1.3   1.4   1.5   1.6   1.7   1.8   2.0  

FM.ExecuteSQL.LastError

Component: FM
Mac OS X: Works
Windows: Works

MBS("FM.ExecuteSQL.LastError")

Parameters

none

Description

Returns an error number. The Errors number s are the same ones as the ones retuned by Native FileMaker function "Get(LastError)" Examples: 1200 - Generic Calculation Error" 200 - "Access Denied" 106 - "Missing Table" Known Limitations: Record Locking Errors are Not Reported! This means you must exercise caution when using UPDATE. There is no way to determine if an update actually occurs unless you check the value again after the update occured.

Examples

Get Last SQL Error

MBS( "FM.ExecuteSQL.LastError")

Feedback: Report problem or ask question.