User Tools

Site Tools


query

Query

It is useful to create custom SQL queries on the fly.

METHODS

Run

Function Run(SQLStatement As String) As Boolean

Get the data from database by running a sql statement.


Run

Static Function Run(SQLStatement As String) As Query

Get the query from database by running a sql statement.


SQL

Function SQL() As String


SetSQL

Function SetSQL() As Boolean


First

Function First() As Boolean


Next

Function Next() As Boolean


Previous

Function Previous() As Boolean


Last

Function Last() As Boolean


GoTo

Function GoTo(Position As Integer) As Boolean


Insert

Function Insert() As Boolean


Update

Function Update() As Boolean


Delete

Function Delete() As Boolean


AddNew

Function AddNew() As Boolean


Value

Function Value(FieldName As String) As AnyType

Query1!FieldName


SetValue

Sub SetValue(FieldName As String, FieldValue As AnyType)

Query1!FieldName =


Length

Function Length () As Integer


Position

Function Position() As Integer


LastSQLError

Function LastSQLError() As String


Requery

Function Requery() As Boolean


query.txt · Last modified: 2013/04/09 22:58 (external edit)