SQLRequest (gb.db)
Since 3.8
此类提供了一种在单个表
table上生成基本SQL请求的工具。 .
Methods
该类保留了Gambas DBMS的独立性。换句话说，相同的代码将生成一个对底层数据库的方言语法正确的请求。
示例
Dim hConn As Connection
Dim iAgeMin As Integer = 18
Dim iAgeMax As Integer = 30
Dim hSqlRequest As SqlRequest
' ... Initializing the connection
hSqlRequest = New SqlRequest(hConn)
Print hSqlRequest.Select("id", "name", "age").From("people").Where("age >= &1", iAgeMin).And().Where("age <= &1", iAgeMax).OrderBy("name", "age DESC").Get()
将产生一个对于 hConn
Connection 指定的数据库类型正确的 SQL DML 语句。
SELECT id, name, age FROM people WHERE age >= 18 AND age <= 30 ORDER BY name,age DESC