Vbs Module

[Guest DiegoBellini]

Please, I need help with a VBS module that works making a "do while" reproduce then each of the recovered information.

I don't understand because it does not work.

 

For example, look at this VBS code:

 

SQLConnStr = "$RV[ConnStr]"

 

Conn.Open SQLConnStr

StrSQL = "SELECT CodigoPago from telepago WHERE SocioNum = " & CustId

Set Rs = Conn.execute(StrSQL)

 

If Rs.Eof or Rs.Bof Then

'No codes availables

Else

NroReg = 0

Do while Not Rs.EOF

NroReg = NroReg + 1

CodigoPago = Rs.fields("CodigoPago").Value

StrSQL = "SELECT FileDeLectura from CodigoCuentas where CodigoPago = " & CodigoPago

Set Rs2 = Conn.Execute(StrSQL)

If Rs2.Eof or Rs2.Bof Then

'No data in this query

Else

Rs2.MoveFirst

FileDeLectura = Rs2.Fields("FileDeLectura").Value

vg.RvSet LineID,"FileDeLectura",FileDeLectura

vg.Script_Goto iLineId,"","LeerCodigoConfirmacion","" 'This program ends here in abnormal form

End If

Rs.MoveNext

Loop

End If

 

 

 

 

 

[SupportTeam]

If you could post the entire script then we can better answer your question, but I think the reason why you are having problem on line

 

vg.Script_Goto iLineId,"","LeerCodigoConfirmacion","" 'This program ends here in abnormal form

 

is because iLineId is not holding the actaul LineID value.

 

Try:

 

vg.Script_Goto $RV_LINEID,"","LeerCodigoConfirmacion",""

[SupportTeam]

Also change:

 

vg.RvSet LineID,"FileDeLectura",FileDeLectura

 

to be

 

vg.RvSet $RV_LINEID,"FileDeLectura",FileDeLectura

[Guest DiegoBellini]

Also change:

 

vg.RvSet LineID,"FileDeLectura",FileDeLectura

 

to be

 

vg.RvSet $RV_LINEID,"FileDeLectura",FileDeLectura

 

 

 

 

I did the changes and they did not do effect, the program continues ending badly

Thanks

[SupportTeam]

Could you please post a copy of VoiceGuide's Trace Logs which captures the call, this will allow us to see what happened.

 

Enable logging by setting the log levels to 10 in VG.INI as per below:

[Log]

 

VoiceGuide=10

Then restart VG and make a test call which demonstrates the problem.

 

Trace files will be created in VG's \log\ subdirectory.

 

Please post the traces and the VoiceGuide script used.

 

When posting traces/scripts please .ZIP them up and post them as attachments.