Important Vg Empty Db Query Variable

[Guest Dominik]

Hi,

 

Is it possible to empty or unset or delete a DB query variable?

Scenario:

1. I query database with DB module (module name is rs)

2. a result count is i.e. 4, $RV[rs_RowCount]

3. $RV[rs_x_1] to $RV[rs_x_4] are set

4. I query DB again with the same module

5. this time the result count is let's say 3, $RV[rs_RowCount]

6. $RV[rs_x_1] to $RV[rs_x_3] are set with new values, but $RV[rs_x_4] still stores the old

 

I need a clean or brand new rs each time DB is queried.

 

Best regards

Dominik

[Guest Dominik]

Will

 

set vg = CreateObject("VoiceGuide.CommandLink")

vg.RvSet $RV_LINEID, "rs", ""

set vg = Nothing

 

empty all the results as well ? ($RV[rs_1_1] and so on?)

Dominik

[SupportTeam]

RVs are never 'deleted' - once set they exist for the length of the call, but may be overwritten with new values.

 

To see how many rows the latest Database query returns you can use $RV[ModuleTitle_RowCount]

[Guest Dominik]

Thanks,

but I'd like to force deleting them. Is it possible?

 

Dominik

[SupportTeam]

You can just set them to be a blank...

[Guest Dominik]

Sek blank, OK.

 

What about query result variable?

How can I set it blank?

 

 

Dominik

[SupportTeam]

If you want to clear the query result variable hen you can just set them to be a blank in the same way... (using the Eval Expr module or using multiple RvSet COM function calls)

 

But why do need to set them to a blank? To see how many rows the latest Database query returns you can use $RV[ModuleTitle_RowCount] ..