record-variable '.' field-name
where object-variable is an object variable that contains an instance of the ActiveX object
and property-name is the name of the property being accessed.
See the Irie Pascal Programmer's Reference Manual (in "progref.html") for more information.
NOTE: After you have finished using the ActiveX object make sure you get rid of it (see disposing of
ActiveX objects).
3.10.5 Disposing of ActiveX object
After you have finished using an ActiveX object you should get rid of it using the built-in procedure
dispose.
See the Irie Pascal Programmer's Reference Manual (in "progref.html") for more information.
3.11.1.1 Connecting to ODBC databases
What is ODBC?
The Open Database Connectivity (ODBC) interface is widely used to access Database Management
Systems (DBMSs). ODBC was originally created by Microsoft but has now become an industry standard,
and is supported by all major DBMSs for Windows.
Connecting to ODBC databases
In order to connect to an ODBC database, you need to:
1. Declare a variable of the built-in type connection
2. Use new on the variable to create a connection object
3. Invoke the open method of the connection object
The open method of the connection object takes one argument, the connection string. ODBC connection
strings can take one of two forms:
odbc-connection-string = odbc-connection-string-1 | odbc-connection-string-2
odbc-connection-string-1 = 'ODBC' ';' dsn-parm ';' uid-parm ';' pwd-parm [';' [driver-specific-text]]
odbc-connection-string-2 = 'ODBC' ';' name ';' [uid] ';' [password]
dsn-parm = 'DSN' '=' name
uid-parm = 'UID' '=' uid
pwd-parm = 'PWD' '=' [password]
