ADO for Director xtra provides a way to use ADO (ActiveX Data Objects) right from Lingo.
Microsoft Data Access Components (MDAC) which includes ADO is a modern technology of database management. It is already installed with Windows 98/ME/2000, Internet Explorer, Microsoft Office. So it is already present on the most of user systems. Installers for Windows 95/NT systems are available online at http://www.microsoft.com/data/download.htm.
So, all you need to get connected to MS Access files, MS SQL Server and Oracle databases over LAN, ODBC compliant databases from both authoring and projector is ADOxtra or ADOxtraLite.
Create database client software using Director? Why not? It is easy. What about large information multimedia system? Have you ever tried to generate it by Lingo script that retrives information from a database? It couldn't be easier...
Recordset based data accessing with automatic type casting allows you to handle integer database fields as integer Lingo values and text database fields as text Lingo values, etc.
Recordset based data modification (Full version only) is as simple as reading data. You just assign new value to a recordset's field. You want data modification with transactions? Why not? Nothing special, just call BeginTrans before modifying data and do not forget to call CommitTrans when you are done.
Fully functional demo version is available.
36 South Court Sq
Newnan, GA 30263