/* --- Script © 2005 EC Software --- */
var ua = navigator.userAgent;
var dom = (document.getElementById) ? true : false;
var ie4 = (document.all && !dom) ? true : false;
var ie5_5 = ((ua.indexOf("MSIE 5.5")>=0 || ua.indexOf("MSIE 6")>=0) && ua.indexOf("Opera")<0) ? true : false;
var ns4 = (document.layers && !dom) ? true : false;
var offsxy = 6;
function hmshowPopup(e, txt, stick) {
  var tip = '<table  border="1" cellpadding="6" cellspacing="0" bgcolor="#FFFFFF" style="{border-width:1px; border-color:#000000; border-collapse:collapse;}"><tr valign=top><td>'+ txt + '<\/td><\/tr><\/table>';
  var tooltip = atooltip();
  e = e?e:window.event;
  var mx = ns4 ? e.PageX : e.clientX;
  var my = ns4 ? e.PageY : e.clientY;
  var bodyl = (window.pageXOffset) ? window.pageXOffset : document.body.scrollLeft;
  var bodyt = (window.pageYOffset) ? window.pageYOffset : document.body.scrollTop;
  var bodyw = (window.innerWidth)  ? window.innerWidth  : document.body.offsetWidth;
  if (ns4) {
    tooltip.document.write(tip);
    tooltip.document.close();
    if ((mx + offsxy + bodyl + tooltip.width) > bodyw) { mx = bodyw - offsxy - bodyl - tooltip.width; if (mx < 0) mx = 0; }
    tooltip.left = mx + offsxy + bodyl;
    tooltip.top = my + offsxy + bodyt;
  }
  else {
    tooltip.innerHTML = tip;
    if (tooltip.offsetWidth) if ((mx + offsxy + bodyl + tooltip.offsetWidth) > bodyw) { mx = bodyw - offsxy - bodyl - tooltip.offsetWidth; if (mx < 0) mx = 0; }
    tooltip.style.left = (mx + offsxy + bodyl)+"px";
    tooltip.style.top  = (my + offsxy + bodyt)+"px";
  }
  with(tooltip) { ns4 ? visibility="show" : style.visibility="visible" }
  if (stick) document.onmouseup = hmhidePopup;
}
function hmhidePopup() {
  var tooltip = atooltip();
  ns4 ? tooltip.visibility="hide" : tooltip.style.visibility="hidden";
}
function atooltip(){
 return ns4 ? document.hmpopupDiv : ie4 ? document.all.hmpopupDiv : document.getElementById('hmpopupDiv')
}
popid_1240877255="<p><span style=\"font-weight: bold; color: #0000ff;\">Properties<\/span><\/p>\n\r<p><img src=\"runtime.png\" width=\"6\" height=\"8\" border=\"0\" alt=\"runtime\" \/> Run-time only &nbsp; &nbsp; &nbsp; &nbsp;<img src=\"key.png\" width=\"19\" height=\"8\" border=\"0\" alt=\"key\" \/> Key properties<\/p>\n\r<p> &nbsp; &nbsp; &nbsp; &nbsp;<img src=\"key.png\" width=\"19\" height=\"8\" border=\"0\" alt=\"key\" \/> &nbsp; &nbsp; &nbsp; &nbsp;<span style=\"color: #800000;\"><a href=\"tmysqlserver_clientversion.htm\">ClientVer<\/a><\/span><\/p>\n\r<p> &nbsp; &nbsp; &nbsp; &nbsp;<img src=\"key.png\" width=\"19\" height=\"8\" border=\"0\" alt=\"key\" \/> &nbsp; &nbsp; &nbsp; &nbsp;<span style=\"color: #800000;\"><a href=\"tmysqlserver_clientversion.htm\">ClientVersion<\/a><\/span><\/p>\n\r<p> &nbsp; &nbsp; &nbsp; &nbsp;<img src=\"key.png\" width=\"19\" height=\"8\" border=\"0\" alt=\"key\" \/> &nbsp; &nbsp; &nbsp; &nbsp;<span style=\"color: #800000;\"><a href=\"tmysqlserver_compression.htm\">Compression<\/a><\/span><\/p>\n\r<p> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<span style=\"color: #800000;\">Connected<\/span><\/p>\n\r<p> &nbsp; &nbsp; &nbsp; &nbsp;<img src=\"key.png\" width=\"19\" height=\"8\" border=\"0\" alt=\"key\" \/> &nbsp; &nbsp; &nbsp; &nbsp;<span style=\"color: #800000;\"><a href=\"tmysqlserver_driverkind.htm\">DriverKind<\/a><\/span><\/p>\n\r<p> &nbsp; &nbsp; &nbsp; &nbsp;<img src=\"key.png\" width=\"19\" height=\"8\" border=\"0\" alt=\"key\" \/> &nbsp; &nbsp; &nbsp; &nbsp;<span style=\"color: #800000;\"><a href=\"tmysqlserver_driverproperties.htm\">DriverProperties<\/a><\/span><\/p>\n\r<p> &nbsp; &nbsp; &nbsp; &nbsp;<img src=\"key.png\" width=\"19\" height=\"8\" border=\"0\" alt=\"key\" \/> &nbsp; &nbsp; &nbsp; &nbsp;<span style=\"color: #800000;\"><a href=\"tmysqlserver_databasename.htm\">DatabaseName<\/a><\/span><\/p>\n\r<p> &nbsp; &nbsp; &nbsp; &nbsp;<img src=\"key.png\" width=\"19\" height=\"8\" border=\"0\" alt=\"key\" \/> &nbsp; &nbsp; &nbsp; &nbsp;<span style=\"color: #800000;\"><a href=\"tmysqlserver_host.htm\">Host<\/a><\/span><\/p>\n\r<p> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<span style=\"color: #800000;\"><a href=\"tmysqlserver_loginprompt.htm\">LoginPrompt<\/a><\/span><\/p>\n\r<p> &nbsp; &nbsp; &nbsp; &nbsp;<img src=\"key.png\" width=\"19\" height=\"8\" border=\"0\" alt=\"key\" \/> &nbsp; &nbsp; &nbsp; &nbsp;<span style=\"color: #800000;\"><a href=\"tmysqlserver_options.htm\">Options<\/a><\/span><\/p>\n\r<p> &nbsp; &nbsp; &nbsp; &nbsp;<img src=\"key.png\" width=\"19\" height=\"8\" border=\"0\" alt=\"key\" \/> &nbsp; &nbsp; &nbsp; &nbsp;<span style=\"color: #800000;\"><a href=\"tmysqlserver_params.htm\">Params<\/a><\/span><\/p>\n\r<p> &nbsp; &nbsp; &nbsp; &nbsp;<img src=\"key.png\" width=\"19\" height=\"8\" border=\"0\" alt=\"key\" \/> &nbsp; &nbsp; &nbsp; &nbsp;<span style=\"color: #800000;\"><a href=\"tmysqlserver_password.htm\">Password<\/a><\/span><\/p>\n\r<p> &nbsp; &nbsp; &nbsp; &nbsp;<img src=\"key.png\" width=\"19\" height=\"8\" border=\"0\" alt=\"key\" \/> &nbsp; &nbsp; &nbsp; &nbsp;<span style=\"color: #800000;\"><a href=\"tmysqlserver_port.htm\">Port<\/a><\/span><\/p>\n\r<p> &nbsp; &nbsp; &nbsp; &nbsp;<img src=\"key.png\" width=\"19\" height=\"8\" border=\"0\" alt=\"key\" \/> &nbsp; &nbsp; &nbsp; &nbsp;<span style=\"color: #800000;\"><a href=\"tmysqlserver_protocol.htm\">Protocol<\/a><\/span><\/p>\n\r<p> &nbsp; &nbsp; &nbsp; &nbsp;<img src=\"key.png\" width=\"19\" height=\"8\" border=\"0\" alt=\"key\" \/> &nbsp; &nbsp; &nbsp; &nbsp;<span style=\"color: #800000;\"><a href=\"tmysqlserver_serverversion.htm\">ServerVer<\/a><\/span><\/p>\n\r<p> &nbsp; &nbsp; &nbsp; &nbsp;<img src=\"key.png\" width=\"19\" height=\"8\" border=\"0\" alt=\"key\" \/> &nbsp; &nbsp; &nbsp; &nbsp;<span style=\"color: #800000;\"><a href=\"tmysqlserver_serverversion.htm\">ServerVersion<\/a><\/span><\/p>\n\r<p> &nbsp; &nbsp; &nbsp; &nbsp;<img src=\"key.png\" width=\"19\" height=\"8\" border=\"0\" alt=\"key\" \/> &nbsp; &nbsp; &nbsp; &nbsp;<span style=\"color: #800000;\"><a href=\"tmysqlserver_username.htm\">UserName<\/a><\/span><\/p>\n\r<p>&nbsp;<\/p>\n\r"
popid_1097285062="<p><span style=\"font-weight: bold; color: #0000ff;\">Methods<\/span><\/p>\n\r<p>&nbsp;<\/p>\n\r<p><img src=\"key.png\" width=\"19\" height=\"8\" border=\"0\" alt=\"key\" \/> Key methods<\/p>\n\r<p> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<span style=\"color: #800000;\">Create<\/span><\/p>\n\r<p> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<span style=\"color: #800000;\">Destroy<\/span><\/p>\n\r<p> &nbsp; &nbsp; &nbsp; &nbsp;<img src=\"key.png\" width=\"19\" height=\"8\" border=\"0\" alt=\"key\" \/> &nbsp; &nbsp; &nbsp; &nbsp;<span style=\"color: #800000;\"><a href=\"tmysqlserver_createdatabase.htm\">CreateDatabase<\/a><\/span><\/p>\n\r<p> &nbsp; &nbsp; &nbsp; &nbsp;<img src=\"key.png\" width=\"19\" height=\"8\" border=\"0\" alt=\"key\" \/> &nbsp; &nbsp; &nbsp; &nbsp;<span style=\"color: #800000;\"><a href=\"tmysqlserver_dropdatabase.htm\">DropDatabase<\/a><\/span><\/p>\n\r<p> &nbsp; &nbsp; &nbsp; &nbsp;<img src=\"key.png\" width=\"19\" height=\"8\" border=\"0\" alt=\"key\" \/> &nbsp; &nbsp; &nbsp; &nbsp;<span style=\"color: #800000;\"><a href=\"tmysqlserver_dataset.htm\">Dataset\/DatasetFrom<\/a><\/span><\/p>\n\r<p> &nbsp; &nbsp; &nbsp; &nbsp;<img src=\"key.png\" width=\"19\" height=\"8\" border=\"0\" alt=\"key\" \/> &nbsp; &nbsp; &nbsp; &nbsp;<span style=\"color: #800000;\"><a href=\"tmysqlserver_escapestr.htm\">EscapeStr<\/a><\/span><\/p>\n\r<p> &nbsp; &nbsp; &nbsp; &nbsp;<img src=\"key.png\" width=\"19\" height=\"8\" border=\"0\" alt=\"key\" \/> &nbsp; &nbsp; &nbsp; &nbsp;<span style=\"color: #800000;\"><a href=\"tmysqlserver_execsql.htm\">ExecSQL\/ExecSQLBatch<\/a><\/span><\/p>\n\r<p> &nbsp; &nbsp; &nbsp; &nbsp;<img src=\"key.png\" width=\"19\" height=\"8\" border=\"0\" alt=\"key\" \/> &nbsp; &nbsp; &nbsp; &nbsp;<span style=\"color: #800000;\"><a href=\"tmysqlserver_formatidentifier.htm\">FormatIdentifier<\/a><\/span><\/p>\n\r<p> &nbsp; &nbsp; &nbsp; &nbsp;<img src=\"key.png\" width=\"19\" height=\"8\" border=\"0\" alt=\"key\" \/> &nbsp; &nbsp; &nbsp; &nbsp;<span style=\"color: #800000;\"><a href=\"tmysqlserver_freedataset.htm\">FreeDataset<\/a><\/span><\/p>\n\r<p> &nbsp; &nbsp; &nbsp; &nbsp;<img src=\"key.png\" width=\"19\" height=\"8\" border=\"0\" alt=\"key\" \/> &nbsp; &nbsp; &nbsp; &nbsp;<span style=\"color: #800000;\"><a href=\"tmysqlserver_getdatabasenames.htm\">GetDatabaseNames<\/a><\/span><\/p>\n\r<p> &nbsp; &nbsp; &nbsp; &nbsp;<img src=\"key.png\" width=\"19\" height=\"8\" border=\"0\" alt=\"key\" \/> &nbsp; &nbsp; &nbsp; &nbsp;<span style=\"color: #800000;\"><a href=\"tmysqlserver_getfieldnames.htm\">GetFieldNames<\/a><\/span><\/p>\n\r<p> &nbsp; &nbsp; &nbsp; &nbsp;<img src=\"key.png\" width=\"19\" height=\"8\" border=\"0\" alt=\"key\" \/> &nbsp; &nbsp; &nbsp; &nbsp;<span style=\"color: #800000;\"><a href=\"tmysqlserver_getlock.htm\">GetLock<\/a><\/span><\/p>\n\r<p> &nbsp; &nbsp; &nbsp; &nbsp;<img src=\"key.png\" width=\"19\" height=\"8\" border=\"0\" alt=\"key\" \/> &nbsp; &nbsp; &nbsp; &nbsp;<span style=\"color: #800000;\"><a href=\"tmysqlserver_gettablenames.htm\">GetTableNames<\/a><\/span><\/p>\n\r<p> &nbsp; &nbsp; &nbsp; &nbsp;<img src=\"key.png\" width=\"19\" height=\"8\" border=\"0\" alt=\"key\" \/> &nbsp; &nbsp; &nbsp; &nbsp;<span style=\"color: #800000;\"><a href=\"tmysqlserver_ping.htm\">Ping<\/a><\/span><\/p>\n\r<p> &nbsp; &nbsp; &nbsp; &nbsp;<img src=\"key.png\" width=\"19\" height=\"8\" border=\"0\" alt=\"key\" \/> &nbsp; &nbsp; &nbsp; &nbsp;<span style=\"color: #800000;\"><a href=\"tmysqlserver_releaselock.htm\">ReleaseLock<\/a><\/span><\/p>\n\r<p> &nbsp; &nbsp; &nbsp; &nbsp;<img src=\"key.png\" width=\"19\" height=\"8\" border=\"0\" alt=\"key\" \/> &nbsp; &nbsp; &nbsp; &nbsp;<span style=\"color: #800000;\"><a href=\"tmysqlserver_selectdatabase.htm\">SelectDatabase<\/a><\/span><\/p>\n\r<p>&nbsp;<\/p>\n\r"
popid_1203697137="<p><span style=\"font-weight: bold; color: #0000ff;\">Events<\/span><\/p>\n\r<p>&nbsp;<\/p>\n\r<p><img src=\"key.png\" width=\"19\" height=\"8\" border=\"0\" alt=\"key\" \/> Key events<\/p>\n\r<p> &nbsp; &nbsp; &nbsp; &nbsp;<img src=\"key.png\" width=\"19\" height=\"8\" border=\"0\" alt=\"key\" \/> &nbsp; &nbsp; &nbsp; &nbsp;<span style=\"color: #800000;\"><a href=\"tmysqlserver_onlogin.htm\">OnLogin<\/a><\/span><\/p>\n\r<p>&nbsp;<\/p>\n\r"
popid_1172246062="<p><span style=\"font-weight: bold; color: #0000ff;\">Properties<\/span><\/p>\n\r<p>&nbsp;<\/p>\n\r<p><img src=\"runtime.png\" width=\"6\" height=\"8\" border=\"0\" alt=\"runtime\" \/> Run-time only &nbsp; &nbsp; &nbsp; &nbsp;<img src=\"key.png\" width=\"19\" height=\"8\" border=\"0\" alt=\"key\" \/> Key properties<\/p>\n\r<p> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<span style=\"color: #800000;\">Active<\/span><\/p>\n\r<p><img src=\"runtime.png\" width=\"6\" height=\"8\" border=\"0\" alt=\"runtime\" \/> &nbsp; &nbsp; &nbsp; &nbsp;<img src=\"key.png\" width=\"19\" height=\"8\" border=\"0\" alt=\"key\" \/> &nbsp; &nbsp; &nbsp; &nbsp;<span style=\"color: #800000;\"><a href=\"tmysqldataset_affectedrows.htm\">AffectedRows<\/a><\/span><\/p>\n\r<p> &nbsp; &nbsp; &nbsp; &nbsp;<img src=\"key.png\" width=\"19\" height=\"8\" border=\"0\" alt=\"key\" \/> &nbsp; &nbsp; &nbsp; &nbsp;<span style=\"color: #800000;\"><a href=\"tmysqldataset_cachedupdates.htm\">CachedUpdates<\/a><\/span><\/p>\n\r<p> &nbsp; &nbsp; &nbsp; &nbsp;<img src=\"key.png\" width=\"19\" height=\"8\" border=\"0\" alt=\"key\" \/> &nbsp; &nbsp; &nbsp; &nbsp;<span style=\"color: #800000;\"><a href=\"tmysqldataset_customfielddefs.htm\">CustomFieldDefs<\/a><\/span><\/p>\n\r<p> &nbsp; &nbsp; &nbsp; &nbsp;<img src=\"key.png\" width=\"19\" height=\"8\" border=\"0\" alt=\"key\" \/> &nbsp; &nbsp; &nbsp; &nbsp;<span style=\"color: #800000;\"><a href=\"tmysqldataset_databasename.htm\">DatabaseName<\/a><\/span><\/p>\n\r<p> &nbsp; &nbsp; &nbsp; &nbsp;<img src=\"key.png\" width=\"19\" height=\"8\" border=\"0\" alt=\"key\" \/> &nbsp; &nbsp; &nbsp; &nbsp;<a href=\"tmysqldataset_mastersource.htm\">DataSource<\/a><\/p>\n\r<p> &nbsp; &nbsp; &nbsp; &nbsp;<img src=\"key.png\" width=\"19\" height=\"8\" border=\"0\" alt=\"key\" \/> &nbsp; &nbsp; &nbsp; &nbsp;<span style=\"color: #800000;\"><a href=\"tmysqldataset_fieldname.htm\">FieldName<\/a><\/span><\/p>\n\r<p> &nbsp; &nbsp; &nbsp; &nbsp;<img src=\"key.png\" width=\"19\" height=\"8\" border=\"0\" alt=\"key\" \/> &nbsp; &nbsp; &nbsp; &nbsp;<span style=\"color: #800000;\"><a href=\"tmysqldataset_filter.htm\">Filter<\/a><\/span><\/p>\n\r<p> &nbsp; &nbsp; &nbsp; &nbsp;<img src=\"key.png\" width=\"19\" height=\"8\" border=\"0\" alt=\"key\" \/> &nbsp; &nbsp; &nbsp; &nbsp;<span style=\"color: #800000;\"><a href=\"tmysqldataset_filtered.htm\">Filtered<\/a><\/span><\/p>\n\r<p><img src=\"runtime.png\" width=\"6\" height=\"8\" border=\"0\" alt=\"runtime\" \/> &nbsp; &nbsp; &nbsp; &nbsp;<img src=\"key.png\" width=\"19\" height=\"8\" border=\"0\" alt=\"key\" \/> &nbsp; &nbsp; &nbsp; &nbsp;<span style=\"color: #800000;\"><a href=\"tmysqldataset_lastinsertid.htm\">LastInsertID<\/a><\/span><\/p>\n\r<p> &nbsp; &nbsp; &nbsp; &nbsp;<img src=\"key.png\" width=\"19\" height=\"8\" border=\"0\" alt=\"key\" \/> &nbsp; &nbsp; &nbsp; &nbsp;<span style=\"color: #800000;\"><a href=\"tmysqldataset_macrodel.htm\">MacroDel<\/a><\/span><\/p>\n\r<p> &nbsp; &nbsp; &nbsp; &nbsp;<img src=\"key.png\" width=\"19\" height=\"8\" border=\"0\" alt=\"key\" \/> &nbsp; &nbsp; &nbsp; &nbsp;<span style=\"color: #800000;\"><a href=\"tmysqldataset_macros.htm\">Macros<\/a><\/span><\/p>\n\r<p> &nbsp; &nbsp; &nbsp; &nbsp;<img src=\"key.png\" width=\"19\" height=\"8\" border=\"0\" alt=\"key\" \/> &nbsp; &nbsp; &nbsp; &nbsp;<span style=\"color: #800000;\"><a href=\"tmysqldataset_masterfields.htm\">MasterFields<\/a><\/span><\/p>\n\r<p> &nbsp; &nbsp; &nbsp; &nbsp;<img src=\"key.png\" width=\"19\" height=\"8\" border=\"0\" alt=\"key\" \/> &nbsp; &nbsp; &nbsp; &nbsp;<span style=\"color: #800000;\"><a href=\"tmysqldataset_mastersource.htm\">MasterSource<\/a><\/span><\/p>\n\r<p><img src=\"runtime.png\" width=\"6\" height=\"8\" border=\"0\" alt=\"runtime\" \/> &nbsp; &nbsp; &nbsp; &nbsp;<img src=\"key.png\" width=\"19\" height=\"8\" border=\"0\" alt=\"key\" \/> &nbsp; &nbsp; &nbsp; &nbsp;<span style=\"color: #800000;\"><a href=\"tmysqldataset_mysqlfields.htm\">MySQLFields<\/a><\/span><\/p>\n\r<p><img src=\"runtime.png\" width=\"6\" height=\"8\" border=\"0\" alt=\"runtime\" \/> &nbsp; &nbsp; &nbsp; &nbsp;<img src=\"key.png\" width=\"19\" height=\"8\" border=\"0\" alt=\"key\" \/> &nbsp; &nbsp; &nbsp; &nbsp;<span style=\"color: #800000;\"><a href=\"tmysqldataset_mysqlrecords.htm\">MySQLRecords<\/a><\/span><\/p>\n\r<p><img src=\"runtime.png\" width=\"6\" height=\"8\" border=\"0\" alt=\"runtime\" \/> &nbsp; &nbsp; &nbsp; &nbsp;<img src=\"key.png\" width=\"19\" height=\"8\" border=\"0\" alt=\"key\" \/> &nbsp; &nbsp; &nbsp; &nbsp;<span style=\"color: #800000;\"><a href=\"tmysqldataset_mysqltables.htm\">MySQLTables<\/a><\/span><\/p>\n\r<p> &nbsp; &nbsp; &nbsp; &nbsp;<img src=\"key.png\" width=\"19\" height=\"8\" border=\"0\" alt=\"key\" \/> &nbsp; &nbsp; &nbsp; &nbsp;<span style=\"color: #800000;\"><a href=\"tmysqldataset_options.htm\">Options<\/a><\/span><\/p>\n\r<p> &nbsp; &nbsp; &nbsp; &nbsp;<img src=\"key.png\" width=\"19\" height=\"8\" border=\"0\" alt=\"key\" \/> &nbsp; &nbsp; &nbsp; &nbsp;<span style=\"color: #800000;\"><a href=\"tmysqldataset_queryinfo.htm\">QueryInfo<\/a><\/span><\/p>\n\r<p> &nbsp; &nbsp; &nbsp; &nbsp;<img src=\"key.png\" width=\"19\" height=\"8\" border=\"0\" alt=\"key\" \/> &nbsp; &nbsp; &nbsp; &nbsp;<span style=\"color: #800000;\"><a href=\"tmysqldataset_paramcheck.htm\">ParamCheck<\/a><\/span><\/p>\n\r<p> &nbsp; &nbsp; &nbsp; &nbsp;<img src=\"key.png\" width=\"19\" height=\"8\" border=\"0\" alt=\"key\" \/> &nbsp; &nbsp; &nbsp; &nbsp;<span style=\"color: #800000;\"><a href=\"tmysqldataset_macros.htm\">Params<\/a><\/span><\/p>\n\r<p> &nbsp; &nbsp; &nbsp; &nbsp;<img src=\"key.png\" width=\"19\" height=\"8\" border=\"0\" alt=\"key\" \/> &nbsp; &nbsp; &nbsp; &nbsp;<span style=\"color: #800000;\"><a href=\"tmysqldataset_rawdata.htm\">RAWData<\/a><\/span><\/p>\n\r<p> &nbsp; &nbsp; &nbsp; &nbsp;<img src=\"key.png\" width=\"19\" height=\"8\" border=\"0\" alt=\"key\" \/> &nbsp; &nbsp; &nbsp; &nbsp;<span style=\"color: #800000;\"><a href=\"tmysqldataset_readonly.htm\">ReadOnly<\/a><\/span><\/p>\n\r<p><img src=\"runtime.png\" width=\"6\" height=\"8\" border=\"0\" alt=\"runtime\" \/> &nbsp; &nbsp; &nbsp; &nbsp;<img src=\"key.png\" width=\"19\" height=\"8\" border=\"0\" alt=\"key\" \/> &nbsp; &nbsp; &nbsp; &nbsp;<span style=\"color: #800000;\"><a href=\"tmysqldataset_realsql.htm\">RealSQL<\/a><\/span><\/p>\n\r<p><img src=\"runtime.png\" width=\"6\" height=\"8\" border=\"0\" alt=\"runtime\" \/> &nbsp; &nbsp; &nbsp; &nbsp;<img src=\"key.png\" width=\"19\" height=\"8\" border=\"0\" alt=\"key\" \/> &nbsp; &nbsp; &nbsp; &nbsp;<span style=\"color: #800000;\"><a href=\"tmysqldataset_records.htm\">Records<\/a><\/span><\/p>\n\r<p> &nbsp; &nbsp; &nbsp; &nbsp;<img src=\"key.png\" width=\"19\" height=\"8\" border=\"0\" alt=\"key\" \/> &nbsp; &nbsp; &nbsp; &nbsp;<span style=\"color: #800000;\"><a href=\"tmysqldataset_resulttype.htm\">ResultType<\/a><\/span><\/p>\n\r<p> &nbsp; &nbsp; &nbsp; &nbsp;<img src=\"key.png\" width=\"19\" height=\"8\" border=\"0\" alt=\"key\" \/> &nbsp; &nbsp; &nbsp; &nbsp;<span style=\"color: #800000;\"><a href=\"tmysqldataset_server.htm\">Server<\/a><\/span><\/p>\n\r<p> &nbsp; &nbsp; &nbsp; &nbsp;<img src=\"key.png\" width=\"19\" height=\"8\" border=\"0\" alt=\"key\" \/> &nbsp; &nbsp; &nbsp; &nbsp;<span style=\"color: #800000;\"><a href=\"tmysqldataset_shareconnection.htm\">ShareConnection<\/a><\/span><\/p>\n\r<p> &nbsp; &nbsp; &nbsp; &nbsp;<img src=\"key.png\" width=\"19\" height=\"8\" border=\"0\" alt=\"key\" \/> &nbsp; &nbsp; &nbsp; &nbsp;<span style=\"color: #800000;\"><a href=\"tmysqldataset_sql.htm\">SQL<\/a><\/span><\/p>\n\r<p> &nbsp; &nbsp; &nbsp; &nbsp;<img src=\"key.png\" width=\"19\" height=\"8\" border=\"0\" alt=\"key\" \/> &nbsp; &nbsp; &nbsp; &nbsp;<span style=\"color: #800000;\"><a href=\"tmysqldataset_sqlbatch.htm\">SQLBatch<\/a><\/span><\/p>\n\r<p> &nbsp; &nbsp; &nbsp; &nbsp;<img src=\"key.png\" width=\"19\" height=\"8\" border=\"0\" alt=\"key\" \/> &nbsp; &nbsp; &nbsp; &nbsp;<span style=\"color: #800000;\"><a href=\"tmysqldataset_sqlcached.htm\">SQLCached<\/a><\/span><\/p>\n\r<p> &nbsp; &nbsp; &nbsp; &nbsp;<img src=\"key.png\" width=\"19\" height=\"8\" border=\"0\" alt=\"key\" \/> &nbsp; &nbsp; &nbsp; &nbsp;<span style=\"color: #800000;\"><a href=\"tmysqldataset_sqldelete.htm\">SQLDelete<\/a><\/span><\/p>\n\r<p> &nbsp; &nbsp; &nbsp; &nbsp;<img src=\"key.png\" width=\"19\" height=\"8\" border=\"0\" alt=\"key\" \/> &nbsp; &nbsp; &nbsp; &nbsp;<span style=\"color: #800000;\"><a href=\"tmysqldataset_sqlinsert.htm\">SQLInsert<\/a><\/span><\/p>\n\r<p> &nbsp; &nbsp; &nbsp; &nbsp;<img src=\"key.png\" width=\"19\" height=\"8\" border=\"0\" alt=\"key\" \/> &nbsp; &nbsp; &nbsp; &nbsp;<span style=\"color: #800000;\"><a href=\"tmysqldataset_sqlupdate.htm\">SQLUpdate<\/a><\/span><\/p>\n\r<p> &nbsp; &nbsp; &nbsp; &nbsp;<img src=\"key.png\" width=\"19\" height=\"8\" border=\"0\" alt=\"key\" \/> &nbsp; &nbsp; &nbsp; &nbsp;<span style=\"color: #800000;\"><a href=\"tmysqldataset_tablename.htm\">TableName<\/a><\/span><\/p>\n\r<p> &nbsp; &nbsp; &nbsp; &nbsp;<img src=\"key.png\" width=\"19\" height=\"8\" border=\"0\" alt=\"key\" \/> &nbsp; &nbsp; &nbsp; &nbsp;<span style=\"color: #800000;\"><a href=\"tmysqldataset_usecursor.htm\">UseCursor<\/a><\/span><\/p>\n\r<p>&nbsp;<\/p>\n\r"
popid_1773878237X="<p><span style=\"font-weight: bold; color: #0000ff;\">Methods<\/span><\/p>\n\r<p>&nbsp;<\/p>\n\r<p><img src=\"key.png\" width=\"19\" height=\"8\" border=\"0\" alt=\"key\" \/> Key methods<\/p>\n\r<p> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<span style=\"color: #800000;\">Create<\/span><\/p>\n\r<p> &nbsp; &nbsp; &nbsp; &nbsp;<img src=\"key.png\" width=\"19\" height=\"8\" border=\"0\" alt=\"key\" \/> &nbsp; &nbsp; &nbsp; &nbsp;<a href=\"tmysqldataset_createtable.htm\">CreateTable<\/a><\/p>\n\r<p> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<span style=\"color: #800000;\">Destroy<\/span><\/p>\n\r<p> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<span style=\"color: #800000;\">BookmarkValid<\/span><\/p>\n\r<p> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<span style=\"color: #800000;\">CompareBookmarks<\/span><\/p>\n\r<p> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<span style=\"color: #800000;\">CreateBlobStream<\/span><\/p>\n\r<p> &nbsp; &nbsp; &nbsp; &nbsp;<img src=\"key.png\" width=\"19\" height=\"8\" border=\"0\" alt=\"key\" \/> &nbsp; &nbsp; &nbsp; &nbsp;<span style=\"color: #800000;\"><a href=\"tmysqldataset_execbatch.htm\">ExecBatch<\/a><\/span><\/p>\n\r<p> &nbsp; &nbsp; &nbsp; &nbsp;<img src=\"key.png\" width=\"19\" height=\"8\" border=\"0\" alt=\"key\" \/> &nbsp; &nbsp; &nbsp; &nbsp;<span style=\"color: #800000;\"><a href=\"tmysqldataset_execsql.htm\">ExecSQL<\/a><\/span><\/p>\n\r<p> &nbsp; &nbsp; &nbsp; &nbsp;<img src=\"key.png\" width=\"19\" height=\"8\" border=\"0\" alt=\"key\" \/> &nbsp; &nbsp; &nbsp; &nbsp;<span style=\"color: #800000;\"><a href=\"tmysqldataset_execsqlbatch.htm\">ExecSQLBatch<\/a><\/span><\/p>\n\r<p> &nbsp; &nbsp; &nbsp; &nbsp;<img src=\"key.png\" width=\"19\" height=\"8\" border=\"0\" alt=\"key\" \/> &nbsp; &nbsp; &nbsp; &nbsp;<span style=\"color: #800000;\"><a href=\"tmysqldataset_hexstr.htm\">HexStr<\/a><\/span><\/p>\n\r<p> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<span style=\"color: #800000;\">Locate<\/span><\/p>\n\r<p> &nbsp; &nbsp; &nbsp; &nbsp;<img src=\"key.png\" width=\"19\" height=\"8\" border=\"0\" alt=\"key\" \/> &nbsp; &nbsp; &nbsp; &nbsp;<span style=\"color: #800000;\"><a href=\"tmysqldataset_locaterecord.htm\">LocateRecord<\/a><\/span><\/p>\n\r<p> &nbsp; &nbsp; &nbsp; &nbsp;<img src=\"key.png\" width=\"19\" height=\"8\" border=\"0\" alt=\"key\" \/> &nbsp; &nbsp; &nbsp; &nbsp;<span style=\"color: #800000;\"><a href=\"tmysqldataset_locateoption.htm\">LocateRecordOption<\/a><\/span><\/p>\n\r<p> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<span style=\"color: #800000;\">Lookup<\/span><\/p>\n\r<p> &nbsp; &nbsp; &nbsp; &nbsp;<img src=\"key.png\" width=\"19\" height=\"8\" border=\"0\" alt=\"key\" \/> &nbsp; &nbsp; &nbsp; &nbsp;<span style=\"color: #800000;\"><a href=\"tmysqldataset_macrobyname.htm\">MacroByName<\/a><\/span><\/p>\n\r<p> &nbsp; &nbsp; &nbsp; &nbsp;<img src=\"key.png\" width=\"19\" height=\"8\" border=\"0\" alt=\"key\" \/> &nbsp; &nbsp; &nbsp; &nbsp;<span style=\"color: #800000;\"><a href=\"tmysqldataset_quotestr.htm\">QuoteStr<\/a><\/span><\/p>\n\r<p>&nbsp;<\/p>\n\r"
popid_737394056="<p><span style=\"font-weight: bold; color: #0000ff;\">Events<\/span><\/p>\n\r<p>&nbsp;<\/p>\n\r<p><img src=\"key.png\" width=\"19\" height=\"8\" border=\"0\" alt=\"key\" \/> Key events<\/p>\n\r<p> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<span style=\"color: #800000;\">OnCalcFields<\/span><\/p>\n\r<p> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<a href=\"tmysqldataset_oncustomvalue.htm\">OnCustomValue<\/a><\/p>\n\r<p> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<a href=\"tmysqldataset_ondefaultvalue.htm\">OnDefaultValue<\/a><\/p>\n\r<p> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<span style=\"color: #800000;\">OnDeleteError<\/span><\/p>\n\r<p> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<span style=\"color: #800000;\">OnEditError<\/span><\/p>\n\r<p> &nbsp; &nbsp; &nbsp; &nbsp;<img src=\"key.png\" width=\"19\" height=\"8\" border=\"0\" alt=\"key\" \/> &nbsp; &nbsp; &nbsp; &nbsp;<span style=\"color: #800000;\"><a href=\"tmysqldataset_onexecsql.htm\">OnExecSQL<\/a><\/span><\/p>\n\r<p> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<a href=\"tmysqldataset_onmacro.htm\">OnMacro<\/a><\/p>\n\r<p> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<span style=\"color: #800000;\">OnNewRecord<\/span><\/p>\n\r<p> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<span style=\"color: #800000;\">OnPostError<\/span><\/p>\n\r<p> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<a href=\"tmysqldataset_onthreadopened.htm\">OnThreadOpened<\/a><\/p>\n\r<p> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<a href=\"tmysqldataset_onthreadposted.htm\">OnThreadPosted<\/a><\/p>\n\r<p>&nbsp;<\/p>\n\r"
popid_318914222="<p><span style=\"font-weight: bold; color: #0000ff;\">See also MySQLDataset<\/span><\/p>\n\r<p>&nbsp;<\/p>\n\r<p><span style=\"color: #800000;\"><a href=\"tmysqldataset.htm\">TMySQLDataset<\/a><\/span><\/p>\n\r<p>&nbsp;<\/p>\n\r"
popid_1742718219="<p><span style=\"font-weight: bold; color: #0000ff;\">See also MySQLServer<\/span><\/p>\n\r<p>&nbsp;<\/p>\n\r<p><span style=\"color: #800000;\"><a href=\"tmysqlserver.htm\">TMySQLServer<\/a><\/span><\/p>\n\r<p>&nbsp;<\/p>\n\r"
popid_111850645="<p><span class=\"f_Heading1\">Example - Server Create<\/span><\/p>\n\r<p>&nbsp;<\/p>\n\r<p><span style=\"font-family: \'Courier New\';\">...<\/span><\/p>\n\r<p> &nbsp; &nbsp; &nbsp; &nbsp;<span style=\"font-family: \'Courier New\'; font-weight: bold;\">with<\/span><span style=\"font-family: \'Courier New\';\"> TMySQLServer.Create(<\/span><span style=\"font-family: \'Courier New\'; font-weight: bold;\">nil<\/span><span style=\"font-family: \'Courier New\';\">) <\/span><span style=\"font-family: \'Courier New\'; font-weight: bold;\">do<\/span><span style=\"font-family: \'Courier New\';\"> <\/span><\/p>\n\r<p> &nbsp; &nbsp; &nbsp; &nbsp;<span style=\"font-family: \'Courier New\'; font-weight: bold;\">try<\/span><\/p>\n\r<p> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<span style=\"font-family: \'Courier New\';\">Host := <\/span><span style=\"font-family: \'Courier New\'; color: #000080;\">\'localhost\'<\/span><\/p>\n\r<p> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<span style=\"font-family: \'Courier New\';\">Username := <\/span><span style=\"font-family: \'Courier New\'; color: #000080;\">\'root\'<\/span><span style=\"font-family: \'Courier New\';\">;<\/span><\/p>\n\r<p> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<span style=\"font-family: \'Courier New\';\">Password := <\/span><span style=\"font-family: \'Courier New\'; color: #000080;\">\'\'<\/span><span style=\"font-family: \'Courier New\';\">;<\/span><\/p>\n\r<p> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<span style=\"font-family: \'Courier New\';\">DatabaseName := <\/span><span style=\"font-family: \'Courier New\'; color: #000080;\">\'mysql\'<\/span><span style=\"font-family: \'Courier New\';\">;<\/span><\/p>\n\r<p> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<span style=\"font-family: \'Courier New\';\">LoginPrompt := False;<\/span><\/p>\n\r<p> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<span style=\"font-family: \'Courier New\';\">Connected := True;<\/span><\/p>\n\r<p> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<span style=\"font-family: \'Courier New\';\">...<\/span><\/p>\n\r<p> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<span style=\"font-family: \'Courier New\';\">ExecSQL(<\/span><span style=\"font-family: \'Courier New\'; color: #000080;\">\'GRANT SELECT, INSERT, UPDATE, DELETE, RELOAD ON *.* TO \'<\/span><span style=\"font-family: \'Courier New\';\">Admin<\/span><span style=\"font-family: \'Courier New\'; color: #000080;\">\'@\'<\/span><span style=\"font-family: \'Courier New\';\">%<\/span><span style=\"font-family: \'Courier New\'; color: #000080;\">\'\'<\/span><span style=\"font-family: \'Courier New\';\">);<\/span><\/p>\n\r<p> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<span style=\"font-family: \'Courier New\';\">...<\/span><\/p>\n\r<p> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<span style=\"font-family: \'Courier New\';\">CreateDatabase(<\/span><span style=\"font-family: \'Courier New\'; color: #000080;\">\'Test\'<\/span><span style=\"font-family: \'Courier New\';\">);<\/span><\/p>\n\r<p> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<span style=\"font-family: \'Courier New\';\">DropDatabase(<\/span><span style=\"font-family: \'Courier New\'; color: #000080;\">\'Test\'<\/span><span style=\"font-family: \'Courier New\';\">);<\/span><\/p>\n\r<p> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<span style=\"font-family: \'Courier New\';\">...<\/span><\/p>\n\r<p> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<span style=\"font-family: \'Courier New\';\">GetDatabaseNames(List);<\/span><\/p>\n\r<p> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<span style=\"font-family: \'Courier New\';\">GetTableNames(<\/span><span style=\"font-family: \'Courier New\'; color: #000080;\">\'mysql\'<\/span><span style=\"font-family: \'Courier New\';\">,List);<\/span><\/p>\n\r<p> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<span style=\"font-family: \'Courier New\';\">GetFieldNames(<\/span><span style=\"font-family: \'Courier New\'; color: #000080;\">\'mysql\'<\/span><span style=\"font-family: \'Courier New\';\">,<\/span><span style=\"font-family: \'Courier New\'; color: #000080;\">\'user\'<\/span><span style=\"font-family: \'Courier New\';\">,List);<\/span><\/p>\n\r<p> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<span style=\"font-family: \'Courier New\';\">...<\/span><\/p>\n\r<p> &nbsp; &nbsp; &nbsp; &nbsp;<span style=\"font-family: \'Courier New\';\">...<\/span><\/p>\n\r<p> &nbsp; &nbsp; &nbsp; &nbsp;<span style=\"font-family: \'Courier New\'; font-weight: bold;\">finally<\/span><\/p>\n\r<p> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<span style=\"font-family: \'Courier New\';\">Free;<\/span><\/p>\n\r<p> &nbsp; &nbsp; &nbsp; &nbsp;<span style=\"font-family: \'Courier New\'; font-weight: bold;\">end<\/span><span style=\"font-family: \'Courier New\';\">;<\/span><\/p>\n\r<p><span style=\"font-family: \'Courier New\';\">...<\/span><\/p>\n\r"
popid_420095738="<p><span class=\"f_Heading1\">Example - MySQLDataset<\/span><\/p>\n\r<p>&nbsp;<\/p>\n\r<p><span style=\"font-family: \'Courier New\';\">...<\/span><\/p>\n\r<p> &nbsp; &nbsp; &nbsp; &nbsp;<span style=\"font-family: \'Courier New\'; font-weight: bold;\">with<\/span><span style=\"font-family: \'Courier New\';\"> TMySQLDataset.Create(<\/span><span style=\"font-family: \'Courier New\'; font-weight: bold;\">nil<\/span><span style=\"font-family: \'Courier New\';\">) <\/span><span style=\"font-family: \'Courier New\'; font-weight: bold;\">do<\/span><span style=\"font-family: \'Courier New\';\"> <\/span><\/p>\n\r<p> &nbsp; &nbsp; &nbsp; &nbsp;<span style=\"font-family: \'Courier New\'; font-weight: bold;\">try<\/span><\/p>\n\r<p> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<span style=\"font-family: \'Courier New\';\">Server := MySQLServer1;<\/span><\/p>\n\r<p> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<span style=\"font-family: \'Courier New\';\">DatabaseName := <\/span><span style=\"font-family: \'Courier New\'; color: #000080;\">\'mysql\'<\/span><span style=\"font-family: \'Courier New\';\">;<\/span><\/p>\n\r<p> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<span style=\"font-family: \'Courier New\';\">TableName := <\/span><span style=\"font-family: \'Courier New\'; color: #000080;\">\'user\'<\/span><span style=\"font-family: \'Courier New\';\">;<\/span><\/p>\n\r<p> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<span style=\"font-family: \'Courier New\';\">Active := True;<\/span><\/p>\n\r<p> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<span style=\"font-family: \'Courier New\';\">...<\/span><\/p>\n\r<p> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<span style=\"font-family: \'Courier New\';\">ExecSQL(<\/span><span style=\"font-family: \'Courier New\'; color: #000080;\">\'GRANT SELECT, INSERT, UPDATE, DELETE, RELOAD ON *.* TO \'\'<\/span><span style=\"font-family: \'Courier New\';\">Admin<\/span><span style=\"font-family: \'Courier New\'; color: #000080;\">\'\'<\/span><span style=\"font-family: \'Courier New\';\">@<\/span><span style=\"font-family: \'Courier New\'; color: #000080;\">\'\'<\/span><span style=\"font-family: \'Courier New\';\">%<\/span><span style=\"font-family: \'Courier New\'; color: #000080;\">\'\'\'<\/span><span style=\"font-family: \'Courier New\';\">, True, False);<\/span><\/p>\n\r<p> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<span style=\"font-family: \'Courier New\';\">Server.Reload;<\/span><\/p>\n\r<p> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<span style=\"font-family: \'Courier New\';\">...<\/span><\/p>\n\r<p> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<span style=\"font-family: \'Courier New\';\">MacroByName(<\/span><span style=\"font-family: \'Courier New\'; color: #000080;\">\'WHERE\'<\/span><span style=\"font-family: \'Courier New\';\">).AsString := <\/span><span style=\"font-family: \'Courier New\'; color: #000080;\">\'where user=\'\'<\/span><span style=\"font-family: \'Courier New\';\">root<\/span><span style=\"font-family: \'Courier New\'; color: #000080;\">\'\'\'<\/span><span style=\"font-family: \'Courier New\';\">;<\/span><\/p>\n\r<p> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<span style=\"font-family: \'Courier New\';\">Close; Open;<\/span><\/p>\n\r<p> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<span style=\"font-family: \'Courier New\';\">...<\/span><\/p>\n\r<p> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<span style=\"font-family: \'Courier New\';\">ShareConnection := False; Open; <\/span><span style=\"font-family: \'Courier New\'; font-style: italic; color: #000080;\">\/\/ Now the dataset has it\'s own threaded connection<\/span><\/p>\n\r<p> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<span style=\"font-family: \'Courier New\';\">...<\/span><\/p>\n\r<p> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<span style=\"font-family: \'Courier New\';\">ShareConnection := True; Open; <\/span><span style=\"font-family: \'Courier New\'; font-style: italic; color: #000080;\">\/\/ Now we are back on the TMySQLServer connection<\/span><\/p>\n\r<p> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<span style=\"font-family: \'Courier New\';\">...<\/span><\/p>\n\r<p> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<span style=\"font-family: \'Courier New\';\">ClearMacros;<\/span><\/p>\n\r<p> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<span style=\"font-family: \'Courier New\';\">MacroByName(<\/span><span style=\"font-family: \'Courier New\'; color: #000080;\">\'ORDER\'<\/span><span style=\"font-family: \'Courier New\';\">).AsString := <\/span><span style=\"font-family: \'Courier New\'; color: #000080;\">\'order by user\'<\/span><span style=\"font-family: \'Courier New\';\">;<\/span><\/p>\n\r<p> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<span style=\"font-family: \'Courier New\';\">MacroByName(<\/span><span style=\"font-family: \'Courier New\'; color: #000080;\">\'LIMIT\'<\/span><span style=\"font-family: \'Courier New\';\">).AsString := <\/span><span style=\"font-family: \'Courier New\'; color: #000080;\">\'limit 0,10\'<\/span><span style=\"font-family: \'Courier New\';\">; Close; Open;<\/span><\/p>\n\r<p> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<span style=\"font-family: \'Courier New\';\">...<\/span><\/p>\n\r<p> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<span style=\"font-family: \'Courier New\';\">CahcedUpdates := True; <\/span><span style=\"font-family: \'Courier New\'; font-style: italic; color: #000080;\">\/\/ All edits, insert, deletes, updates are now cached<\/span><\/p>\n\r<p> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<span style=\"font-family: \'Courier New\';\">Edit;<\/span><\/p>\n\r<p> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<span style=\"font-family: \'Courier New\';\">FieldByName(<\/span><span style=\"font-family: \'Courier New\'; color: #000080;\">\'user\'<\/span><span style=\"font-family: \'Courier New\';\">).AsString := <\/span><span style=\"font-family: \'Courier New\'; color: #000080;\">\'test\'<\/span><span style=\"font-family: \'Courier New\';\">;<\/span><\/p>\n\r<p> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<span style=\"font-family: \'Courier New\';\">Post;<\/span><\/p>\n\r<p> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<span style=\"font-family: \'Courier New\';\">Close; <\/span><span style=\"font-family: \'Courier New\'; font-style: italic; color: #000080;\">\/\/ Cached statements flushed<\/span><\/p>\n\r<p> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<span style=\"font-family: \'Courier New\';\">CachedUpdates := False; <\/span><span style=\"font-family: \'Courier New\'; font-style: italic; color: #000080;\">\/\/ Statements not cached, sent real-time to server<\/span><\/p>\n\r<p> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<span style=\"font-family: \'Courier New\';\">...<\/span><\/p>\n\r<p> &nbsp; &nbsp; &nbsp; &nbsp;<span style=\"font-family: \'Courier New\'; font-weight: bold;\">finally<\/span><\/p>\n\r<p> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<span style=\"font-family: \'Courier New\';\">Free;<\/span><\/p>\n\r<p> &nbsp; &nbsp; &nbsp; &nbsp;<span style=\"font-family: \'Courier New\'; font-weight: bold;\">end<\/span><span style=\"font-family: \'Courier New\';\">;<\/span><\/p>\n\r<p><span style=\"font-family: \'Courier New\';\">...<\/span><\/p>\n\r"