Introduction

Thank you for evaluating, and your interest in our newest MySQL related product named "MyX".

•	directly accessing MySQL servers skipping slower methods like ODBC

•	full MySQL versions 3.21.x to 5.x compatible

•	primarily intended for IIS webserver ASP script usage, but also for languages like VB and VC++

•	with full realtime data editing, appending, deleting and updating capabilities

•	with full support for ALL MySQL server fieldtypes. Yes, even ENUM, SET, BLOB, TEXT, with support for getting images out of the BLOB fields directly into the browser

•	multithreaded support, ie. multiple connections to a MySQL server operating totally independently using only one MyX Object

•	Sending a quick email to a number of recipients

•	Generating Mascon reports directly to files or directly to webbrowser as PDF/RTF/XLS/WK1/WQ1/HTML/XHTML documents

•	A method (1 line of ASP), populating any template HTML (filebased/straight) with the values from the current record of a table

•	A method (1 line of ASP), building a complete HTML table from a recordset/dataset complete with header, body and footer HTML templates (filebased/straight)

•	A method (1 line of ASP), giving full editing and scrolling capabilities to any MySQL table or SQL statement you can think of, even beyond the natural limits of MySQL server

•	Master Detail capabilities, where you'll be able to link any number MySQL tables (even across databases) on a Master Detail basis displaying both on one page with full editing scrolling capability on both Master and Detail recordsets

MyX comes in two flavours, a normal version including 100% of all functionality and a Lite version which exclude the reporting and emailing functionalities, thus reducing MyX's size. The four methods of MyX excluded in the Lite version are clearly marked.

You've probably already seen the samples on the SciBit website, to get your own MyX Object to work you will need to get at least a Trial release code for your object from the SciBit website at: MyX which will enable your object for a minimum of 30 days. Do it now else you will not be able to test the rest of the help files, samples, etc. locally. Once you bought the MyX component license for a nominal fee you'll have a release code valid until the year "9999-12-31", as well as excellent email support, lifetime upgrades and a full company R&D team for this component at your disposal.

To better understand the rest of this helpfile it is important for you to understand how the 4 Objects included in MyX fit together.

This is the main ActiveX object created with the "SciBit.MyX" ASP ProgID, and includes most of the global functions as well as access to the other objects.

Each MyX Object contains ONE of these Server Objects responsible for connecting to and allocating threaded connections to the MySQL server for use by each Dataset/Recordset Object which may all share a single thread or each have there own thread to the mysql server.

Each MyX Object contains a collection of Dataset Objects each indexed using a friendly name, like "MyAccounts", each of which will by default use the single threaded connection to the MySQL server provided by the Server Object or each could use its own thread. Each Dataset Object is responsible for fetching a query result from the MySQL server, allowing full scrolling, editing, etc on the result. Such a result will naturally have several columns/fields each of which is represented with a Field Object.

Each result maintained by a Dataset Object will have a collection of columns or fields, each represented by one Field Object, that may be used to get or set field values as well as access many properties and information on each field.