WebDNA Software | [SQLrelease]

Technical References - [SQLrelease]

numero = 281
interpreted = N
texte = [SQLrelease result_ref=][SQLrelease] will close the result set and variable name created by a [SQLexecute] context. The name is freed and available for use again.All SQL result objects are released at the end of template execution anyway, so it is not required to use [SQLrelease]. However, it can come in handy if you wish to iterate several [SQLexecute] contexts, re-using the same result variable name for each SQL execution.

Parameters	Description
conn_ref (or just 'ref')	(Required) - The name of the SQLConnect variable you have created via the conn_var (or var) parameter of a [SQLconnect] context you have already successfully executed.

[SQLrelease result_ref=]

[SQLrelease] will close the result set and variable name created by a [SQLexecute] context. The name is freed and available for use again.
All SQL result objects are released at the end of template execution anyway, so it is not required to use [SQLrelease]. However, it can come in handy if you wish to iterate several [SQLexecute] contexts, re-using the same result variable name for each SQL execution.

Parameters	Description
conn_ref (or just 'ref')	(Required) - The name of the SQLConnect variable you have created via the conn_var (or var) parameter of a [SQLconnect] context you have already successfully executed.

DOWNLOAD WEBDNA NOW!

Technical References - [SQLrelease]

Top Articles:

Related Readings: