View source for Gambas/libraries/gb.db/Connection/Find

==Navigation==
[[computing]]: [[software]]: [[programming]]: [[Gambas]]: [[Gambas reference|reference]]: [[gb.db]].[[Connection (gb.db)|Connection]].'''Find'''()

==Definition==
FUNCTION '''Find''' ( <u>Table</u> AS String {{optargs|, <u>Request</u> AS String, <u>Argument</u> AS (any type), ...}} ) AS [[Result (gb.db)|Result]]
==Overview==
Returns a read-only [[Result (gb.db)|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 [[Subst (Gambas)|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... --[[User:Woozle|Woozle]] 11:30, 5 December 2006 (EST)