Get(LastODBCError)

Category: Get

Syntax: Get ( LastODBCError )

Parameters: None

Data type returned: Text

Description:

Returns a string that shows the ODBC error state (SQLSTATE), as published by ODBC standards, based on ISO/IEF standards.

The ODBC error state is cleared at the time the next ODBC-related script step is performed. Anytime before that happens, you can check to see whether an ODBC error was generated.

By setting the Set Error Capture script step to On, you can suppress the error messages that a user sees during execution of a script that uses ODBC functions.

Examples:

When attempting to execute a SQL statement with an invalid field name, Get (LastODBCError) Returns S0022.

If no error is encountered, Get (LastODBCError) Returns 00000.


: FileMaker Specifications

FileMaker 8 Product Line

Specifications and Storage Limits

Field Types and Import/Export Formats

: Calculation Functions

Working with Calculations Primer

Calculation Signatures

Calculation Functions

: Custom Functions

Custom Functions Primer

Useful Custom Functions

: Script Steps

Scripting Primer

Script Step Reference

: Quick Reference

FileMaker Error Codes

FileMaker Keyboard Shortcuts

FileMaker Network Ports

FileMaker Server Command Line Reference

FileMaker XML Reference

: Other Resources

Where to Go for More Information



FileMaker 8 Functions and Scripts Desk Reference
FileMaker 8 Functions and Scripts Desk Reference
ISBN: 0789735113
EAN: 2147483647
Year: 2004
Pages: 352

Flylib.com © 2008-2020.
If you may any questions please contact us: flylib@qtcs.net