The syntax for specifyingīind variables in SQL is dependent on the database. The bound variables are cleared and have to be set again for future calls. Such variables must be set beforeĬalling the function using SetDatabaseString(), SetDatabaseLong() etc. The query can contain place holders for bind variables. Once the query results aren't needed anymore, FinishDatabaseQuery() has to be called To get the number of columns returned by the query, use DatabaseColumns(). It is safe to use NextDatabaseRow() even if the requestĭoesn't return any records. In the event of an error, the error text can be retrieved withĭatabaseError(). If the query has succeeded then NextDatabaseRow() can be used to list returned records Returns nonzero if the query was successful or zero if it failed (due to a SQL error or a badly-formatted query). It can be slower, or even unsupported on some drivers. #PB_Database_DynamicCursor: performs the query to access the result in a random manner using PreviousDatabaseRow() or FirstDatabaseRow(). With PreviousDatabaseRow() or FirstDatabaseRow() on some drivers, but it is the faster way to get the data (default). #PB_Database_StaticCursor : performs the query to access the result in a sequential manner. To performs database modification, use DatabaseUpdate().
Records are accepted ('SELECT' like queries). Only queries which doesn't change the database Result = DatabaseQuery(#Database, Request$ ) DescriptionĮxecutes a SQL query on the given database.
0 kommentar(er)
