Vbscript Variables

[kempvet]

Is it possible for a variable once defined in a module Vbscript such as

strPhoneNumber=2341235341534

being available in all the modules of the current vgs script

 

sort of like

 

RV[strPhoneNumber]=strPhoneNumber

 

alternatively the following connection script works in the VBScript modules - so can someone tell me the correct nomenclature to use in the Database query models

 

Set cn = CreateObject("ADODB.Connection")

cn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\\main\works\bases\products.mdb;Jet OLEDB:Database Password=mypassword"

set rs = CreateObject("ADODB.recordset")

SQL etc

 

regards all

[SupportTeam]

Is it possible for a variable once defined in a module Vbscript such as

strPhoneNumber=2341235341534

being available in all the modules of the current vgs script

Yes, just save the information you want to use in future modules in a Result Variable, and then use that RV in future modules.

See:

http://www.voiceguide.com/vghelp/html/com_RvSet.htm

http://www.voiceguide.com/vghelp/html/com_...vSet_RvList.htm

http://www.voiceguide.com/vghelp/html/com_...esultReturn.htm

 

Script_Goto, Script_Gsub, and Script_Return COM functions also allow you to set RVs, as does the Evaluate Expression module...

 

can someone tell me the correct nomenclature to use in the Database query models

Set the Database field to be:

 

\\main\works\bases\products.mdb

 

and for Connect string specify:

 

";pwd=mypassword

 

(notice the ";" at the beginning)

[kempvet]

0 cl RvSet Status, LevelOne

0 ERROR: COM interface not supported in this version.

 

 

????????? Version of what

nothing ever appears simple with this program, does this mean that I have to fork out more money just to carry someones status as level one through the modules

[SupportTeam]

The COM interface is supported in the Enterprise (and Evaluation) versions.

See: http://www.voiceguide.com/vgFeatures.htm

 

An (more cumbersome) alternative is to use Evaluate Expression modules to set the RVs.