Vb Script To Query Db

[AntonB]

Hi,

 

Is it posible to use VB Script module to perform the database query (currently I'm using db query module but many method could be better if we run DB query within VB Script), if so how to use recordset/row result on another module, a sample script will be appreciated

 

Thanks

[SupportTeam]

For information on how to access databases from VBScript I'd recommend you read up on ADO objects (plenty of books on this available). This is a sample of how to insert data:

 

Set cnn = CreateObject("ADODB.Connection")

cnn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\data\news.mdb"

cnn.Execute "INSERT INTO MyTable (Column1, Column2) VALUES (Value1, Value2);"

cnn.Close

Set cnn = Nothing

 

Te return data from VBScript back to VoiceGuide use the Run_ResultReturn COM function, see: http://www.voiceguide.com/vghelp/html/com_...esultReturn.htm

[AntonB]

Hi,

 

Can I access the results with $RV[module title_RowCount] and

$RV[module title_ColumnIndex_RowIndex] if access databases from VBScript Module?

[SupportTeam]

No. Those Result Variables are defined by the DB Query module when you use it.

 

You can of course create and set your own Result Variables. See the COM functions:

 

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

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

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