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.