MacSQL has a number of objects representing remote database objects. The following diagram shows the heirarchy of scriptable objects.
The most important thing to know about scripting MacSQL is that every query
you execute creates a Result Set object which must be deleted when you are
done with it. Otherwise, you will leak memory and an open database connection.
You can access the result set created by a query as "last result set" of the
document/session that did the query. To delete it, simply use the command
"delete last result set of theSession".
For more details, select Open Scripting Dictionary from the Scripts menu or look at the tutorial included with MacSQL.
| MacSQL Object Model |
|