Home Product home page Download Order

Contents

TmySQLBatchExecute

TmySQLDirectQuery

TmySQLMacroQuery

TmySQLStoredProc

TmySQLUpdateSQL

AfterDelete, Format

Append, FieldValues, Post

BeforeInsert, Insert, AsInteger, FieldByName

BeforePost, Abort

Create, CreateBlobStream, Edit, CopyFrom

CreateTable() method usage

DataSetCount, DataSets

DisableControls, EnableControls, Eof

EditKey, GotoKey

EditRangeStart, EditRangeEnd, FieldByName, ApplyRange

FieldCount, Fields, FieldName

FindField, AsString

GetBookmark, GotoBookmark, FreeBookmark, FindPrior, Value, OnDataChange, BOF

IndexDefs, Update, Count, Items, IndexName, Fields, Name

IndexFields, IndexFieldCount

MasterSource, MasterFields

Min, Max, Position, RecordCount, First, Next

MoveBy, SelectedIndex, Tag

ParamCount, DataType, StrToIntDef, AsXXX

Prepared, Prepare

SetKey, GotoNearest

SetRange, CancelRange, Refresh

State, Seek, Truncate

DAC for MySQL

Example: Prepared, Prepare

if not MySQLQuery1.Prepared then
begin
  MySQLQuery1.Close;
  MySQLQuery1.Prepare;
  MySQLQuery1.Open
end;