comp • gb.db • _connection • quote

Connection.Quote (gb.db)

Function Quote ( Name As String [ , Table As Boolean ] ) As String

Returns a quoted identifier so that you can freely insert it into a query.

This identifier can be a table or a field name.

The quoting mechanism depends on the database server driver, so this method should be used if you need to write database-independant code.

Examples

' Returns the number of records in a query
' sTable is the name of the table. It can include reserved characters, so we need
' to quote it!

rResult = Handle.Exec("SELECT COUNT(*) AS nRecord FROM " & DB.Quote(sTable, True))
PRINT rResult!nRecord