TMySQLQuery:

:nSocket
Connection handle to MySQL server

:nResultHandle
Result handle received from MySQL

:cQuery
Copy of query that generated this object

:nNumRows
Number of rows available on answer NOTE MySQL is 0 based

:nCurRow
I'm currently over row number

:lBof

:lEof

:lFieldAsData
Use fields as object DATA. For compatibility Names of fields can match name of TMySQLQuery/Table DATAs, and it is dangerous. ::lFieldAsData:=.F. can fix it

:aRow
Values of fields of current row

:nNumFields
How many fields per row

:aFieldStruct
Type of each field, a copy is here a copy inside each row

:lError
.T. if last operation failed

:New(nSocket, cQuery)
New query object

:Destroy()

:End()

:Refresh()
ReExecutes the query (cQuery) so that changes to table are visible

:GetRow(nRow)
Return Row n of answer

:Skip(nRows)
Same as clipper ones

:Bof()

:Eof()

:RecNo()

:LastRec()

:GoTop()

:GoBottom()

:GoTO(nRow)

:FCount()

:NetErr()
Returns .T. if something went wrong

:Error()
Returns textual description of last error and clears ::lError

:FieldName(nNum)

:FieldPos(cFieldName)

:FieldGet(cnField)

:FieldLen(nNum)
Length of field N

:FieldDec(nNum)
How many decimals in field N

:FieldType(nNum)
Clipper type of field N