Hi All,

A new version of MySQLX was released today: 2001.1.6.0.

For complete descriptions on changes see: http://www.scibit.com/MySQLX

New features and methods: (A) If you have Mascon (http://www.scibit.com/Mascon), you can now display and output your professionally designed reports directly to the client webbrowser and/or file in PDF / RTF / XLS / WK1 / WQ1 format. You can even supply search values for your report queries. Report = MySQLX.ReportFromFile("c:\inetpub\wwwroot\report.rtm","AccountID=1","PDF") Response.ContentType = "application/pdf" Response.BinaryWrite Report

(B) Using the new SendMail method you can quickly sent an email to a number of recipients with an optional message and an optional attachment file or even your live report you just generated for the browser MySQLX.SendMail "smtphost","From","To1,To2,To3","Subject","Message","c:\report.pdf" OR MySQLX.SendMail "smtphost","From","To1,To2,To3","Subject","Message","report.pdf",Report ' from (A)

(C) The new ClientSide method will enable you to specify that the mysql server should keep the result sets instead of the dataset objects RS.ClientSide = False ' Have mysql server keep the results

(D) DatasetFrom will enable you to create or update a dataset object with a new SQL statement with 1 line of code: Set RS = MySQLX.DatasetFrom "select * from ..."

Enjoy, SciBit Development Team http://www.scibit.com http://www.scibit.com/Mascon http://www.scibit.com/MySQLX http://www.scibit.com/MySQL