Difference between revisions of "Gambas/libraries/gb.db/Connection/Find"
< Gambas | libraries | gb.db | Connection
Jump to navigation
Jump to search
m (Woozle moved page gb.db.Connection.Find to Gambas/libraries/gb.db/Connection/Find: reorganizing as subpages) |
(post-move tidying) |
||
| Line 1: | Line 1: | ||
| − | |||
| − | |||
| − | |||
==Definition== | ==Definition== | ||
| − | FUNCTION '''Find''' ( <u>Table</u> AS String {{optargs|, <u>Request</u> AS String, <u>Argument</u> AS (any type), ...}} ) AS [[Result | + | FUNCTION '''Find''' ( <u>Table</u> AS String {{optargs|, <u>Request</u> AS String, <u>Argument</u> AS (any type), ...}} ) AS [[../../Result|Result]] |
| − | == | + | ==About== |
| − | Returns a read-only [[Result | + | Returns a read-only [[../../Result|Result]] object used for querying records in the specified table. <u>Request</u> is a [[SQL WHERE clause]] used for filtering the table, and the <u>Argument</u>s are quoted as needed by the [[SQL]] syntax and substituted inside the <u>Request</u> string in much the same manner as done by the [[Gambas/functions/Subst|Subst]]() function. |
==Questions== | ==Questions== | ||
Does a Result object become invalid after the Connection is closed? I suspect so, but don't see any mention in the documentation. I'm about to test this and find out... --[[User:Woozle|Woozle]] 11:30, 5 December 2006 (EST) | Does a Result object become invalid after the Connection is closed? I suspect so, but don't see any mention in the documentation. I'm about to test this and find out... --[[User:Woozle|Woozle]] 11:30, 5 December 2006 (EST) | ||
Latest revision as of 20:19, 24 April 2013
Definition
FUNCTION Find ( Table AS String
- REDIRECT Template:arg/opt ) AS Result
About
Returns a read-only Result object used for querying records in the specified table. Request is a SQL WHERE clause used for filtering the table, and the Arguments are quoted as needed by the SQL syntax and substituted inside the Request string in much the same manner as done by the Subst() function.
Questions
Does a Result object become invalid after the Connection is closed? I suspect so, but don't see any mention in the documentation. I'm about to test this and find out... --Woozle 11:30, 5 December 2006 (EST)