DB Connection - Query

hoangvo81 · Post by **hoangvo81** » Mon Mar 05, 2012 10:10 pm

Hi All,

Quick question - when running dbQuery, the result set is stored in a 2 dimensional variable.

if the result is very big, would it help easy up the system that is running the query by setting the result set variable to blank?

dbQuery>conn,sql,rSet,nRec,nFld

if>nRec>10000
let>rSet=
endif

doing the above would that basically release all mem usuage hold by rSet?

Sorry if m shooting in the dark here.

and Thanks,

JRL · Post by **JRL** » Tue Mar 06, 2012 12:07 am

If you are using release 13 you have the new DelArray function. You might try that and see if it suits your need. Otherwise, prior to 13, once a variable is created it exists until the script ends.

hoangvo81 · Post by **hoangvo81** » Tue Mar 06, 2012 7:44 pm

That would work,

Thanks,