Gambas/libraries/gb.db/Connection/Find - Revision history

Woozle: post-move tidying

2013-04-24T20:19:25Z

post-move tidying

← Older revision		Revision as of 20:19, 24 April 2013
Line 1:		Line 1:
	~~==Navigation==~~
	~~[[computing]]: [[software]]: [[programming]]: [[Gambas]]: [[Gambas reference\|reference]]: [[gb.db]].[[Connection (gb.db)\|Connection]].'''Find'''()~~

	==Definition==		==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]]		FUNCTION '''Find''' ( <u>Table</u> AS String {{optargs\|, <u>Request</u> AS String, <u>Argument</u> AS (any type), ...}} ) AS [[../../Result\|Result]]
	==~~Overview~~==		==About==
	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.		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)

Woozle: Woozle moved page gb.db.Connection.Find to Gambas/libraries/gb.db/Connection/Find: reorganizing as subpages

2013-04-24T20:17:12Z

Woozle moved page gb.db.Connection.Find to Gambas/libraries/gb.db/Connection/Find: reorganizing as subpages

← Older revision	Revision as of 20:17, 24 April 2013
(No difference)

Woozle: /* Navigation */ added "reference"

2006-12-05T22:13:49Z

Navigation: added "reference"

← Older revision		Revision as of 22:13, 5 December 2006
Line 1:		Line 1:
	==Navigation==		==Navigation==
	[[computing]]: [[software]]: [[programming]]: [[Gambas]]: [[gb.db]].[[Connection (gb.db)\|Connection]].'''Find'''()		[[computing]]: [[software]]: [[programming]]: [[Gambas]]: [[Gambas reference\|reference]]: [[gb.db]].[[Connection (gb.db)\|Connection]].'''Find'''()

	==Definition==		==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]]		FUNCTION '''Find''' ( <u>Table</u> AS String {{optargs\|, <u>Request</u> AS String, <u>Argument</u> AS (any type), ...}} ) AS [[Result (gb.db)\|Result]]

Woozle at 16:30, 5 December 2006

2006-12-05T16:30:53Z

New page

==Navigation==
[[computing]]: [[software]]: [[programming]]: [[Gambas]]: [[gb.db]].[[Connection (gb.db)|Connection]].'''Find'''()
==Definition==
FUNCTION '''Find''' ( Table AS String {{optargs|, Request AS String, Argument 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. 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 (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)