Easy access to relational databases with rdb.ctl..

[vogler]

There is a (i guess undocumented) ctrl library "rdb.ctl".
It is very easy to access relational databases using this library!
Create an odbc data source (DSN) "mydb" in your windows environment and try the following example:

#uses "CtrlADO.dll"
#uses "rdb.ctl"

main()
{
dbConnection db;
dyn_dyn_anytype res;
rdbOpen(db, "DSN=mydb;UID=scott;PWD=tiger");
rdbSelect(db, "SELECT * FROM emp", res); DebugTN(res);
rdbExecute(db, "UPDATE emp SET sal=sal*0.10");
rdbSelect(db, "SELECT * FROM emp", res); DebugTN(res);
rdbClose(db);
}