Posted by Justin Guerber on December 09, 2009 at 11:33:17:
Another new feature has found its way into the new Comet 2010/Comet32 lineup: a new MySql driver that allows you to connect to MySql databases from your Internet Basic programs.
More details about the SQL device can be found on the wiki page (see attached link), but the short and sweet version is that you can now perform all of the MySql operations straight from IB. Getting started is as easy as:
SqlFmt: Format column1$; column2$; ...
Open(LUN) "SQL"
Control(LUN, "CONNECT database localhost user password"
Control(LUN, "SQLQUERY select * from mytable")
do
Read(LUN, SqlFormat) excp=nomorerows
loop
The MySql device is only be available in Comet 2010, and only to customers with active subscriptions. Trying to open the SQL device without a valid subscription license will result in an exception. Please contact us for a demo license if you would like to try it out. I believe the demo licenses expire at the end of march.
We are really excited about this product, and think it could be a great asset to your programs. Please provide any feedback here or on the wiki/discussion page, so that we can continue to improve it.
Thank you!
Each file can be a maximum of 1MB in length Uploaded files will be purged from the server on a regular basis.