VoiceGuide IVR Software Main Page
Jump to content

Problem With Return And Db Query Module

Recommended Posts

I can't seem to get the db query module to cooperate with me when using "Return". Instead of returning to what i specified in the previous module, it hangs up, since i don't know what to put in for the path. I'm using return so i can use one module to handle a call from multiple other modules. Any suggestions?

Share this post


Link to post

Could you please send us a copy of VoiceGuide's Debug Printout which captures the problem, this will allow us to see what is going wrong.

 

(When running the script click on VoiceGuide's View menu and select 'Event Trace Log' option - any log information will then appear in this window. You must open the trace window before making the call.)

 

Are you using GOSUB to go to the script which has that DB Query module with the 'return' in it?

Share this post


Link to post

041055.72 0 PlaySoundStop ok

041055.74 0 [updateBalance] DB Query

041055.75 0 Jet mode used (To use ODBC mode specify ODBC Connect string)

041055.78 0 RVreplace start: [sELECT Balance FROM Members WHERE TELEPHONE='$RV[Login]']

041055.79 0 RVreplace end: [sELECT Balance FROM Members WHERE TELEPHONE=4128846830]

041055.80 0 About to execute Retrieve Operation [sELECT Balance FROM Members WHERE TELEPHONE=4128846830]

041055.81 0 [updateBalance] row count=1

041055.84 0 Hanging up call... [srlib 282]

041055.84 0 RecSoundStop ok

041055.86 0 PlaySoundStop ok

041055.87 0 fnHangupCall end

041056.18 0 callstate DISCONNECTED 66088,1,0

041056.18 0 LsAwaitingCalls EV_REMOTEPARTY_DISCONNECT

041056.19 0 Hanging up call...

041056.20 0 RecSoundStop ok

041056.21 0 PlaySoundStop ok

041056.22 0 fnHangupCall end

041056.23 0 callstate IDLE 66088 0 0

041056.24 0 WorkingMode@Idle=

041056.27 0 tapi Reply 66054 0

041056.28 0 tapi Reply 66037 0

041057.20 0 LsAwaitingCalls EV_TIMEOUT_TIMETOREINITLINE

041057.20 0 ReinitTelephony due to IDLE start

041057.21 0 tapic lineDeallocateCall(MainCall:66088) 0

041057.55 0 lineOpen(0) => 0

041057.57 0 Waiting for a call...

 

 

From what i can see, there's no error, the db module is just hanging up because there are no path's set. What should be in there for use with Return?

Share this post


Link to post

Please post both scripts (calling script and called script) - or a cut down version them which demonstrates the problem and we can have a look at them and point out where the problem is.

 

The "paths" demo scripts shipped with VoiceGuide demonstrate how the subscripts are called and then how they return from them... - see in VG's \scripts\paths directory.

Share this post


Link to post

I'm not using multiple scripts for this so far, just multiple modules from inside the same script. All i need to know is how to fill in the path information on the db query so it starts returning. I tried just putting "on {success} return" but it still hangs up and gives me a "stack empty" error in the log

Share this post


Link to post

Is the "gosub" statement used when branching to the part of the script which does the DB query and then the "return" ?

 

To let us see what is going on we really need to see the trace log form the entire call and the script (.VGS) files itself.

Share this post


Link to post

no i wasn't using gosub, however i did switch them around just now to have the db module in its own script, and use gosub to call it, since that's how it's used in the example path scripts. no luck however, the db module continues to hang up after it retrieves the database information. i even plugged in a sound module named as the db module and it worked the first time, so i don't think i'm doing something wrong.

 

attached is the script that calls the db module with "Intro"

Instant.vgs

Share this post


Link to post

i tried on {success} return and it worked. i tried it while still having the module in the same script, guess i should have tried it when i relocated to gosub and multiple scripts. sorry for wasting your time.

Share this post


Link to post

OK, sounds like it's all sorted now.

 

For benefit of other readers: you must use "gosub" path if you then want to return back from the subscrpt using a "return" path...

 

More information on using the "gosub", "goto" and "return" paths can be found in the Paths chapter of the VoiceGuide Help File.

Share this post


Link to post

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×