VoiceGuide IVR Software Main Page
Jump to content

Amend A Record In A Query Query Module

Recommended Posts

Help would be much appreciated,

 

I have been trying to get to grips with the basics of the IVR interacting with a database, in this case Access.

 

I have been able to use the Help to get the IVR to query the database for information,

 

However, I am having a problem making changes to a record in the a table. I am able to read the table data without any problem, but for some reason I have been unable to make changes to a record in the field.

 

I'm using Access,

 

Below is the command line I'm using

 

UPDATE Products SET Unitsinstock=$RV[Get New Stock] WHERE ProductID=$RV[Get Product Code]

 

[Get New Stock] is a created in a module prior to the database query module above.

 

Below is the log

 

Where am I going wrong.....I'm sure it it is something realy obvious!

 

Regards

 

Vatsal

 

 

 

21906 0 tapie callstate OFFERING 65778 0 4

21906 0 tapie ring 1

24901 0 tapie ring 2

24901 0 Answer the call

24901 0 lineAnswer(65778) => 66307

24911 0 tapie callstate ACCEPTED 65778 0 0

26213 0 tapi Reply 66307 0

26223 0 tapie callstate CONNECTED 65778,0,0

26223 0 WorkingModeTAPI=

26223 0 WorkingModeScript=

26223 0 TimeoutClear

26223 0 [select Query] Playing

26223 0 [select Query] Playing (C:\Program Files\ivg\Scripts\04MAR2003 IVR SMS ASSIST\Welcome to smsassist.wav)

26273 0 PlaySoundStart ok [C:\Program Files\ivg\Scripts\04MAR2003 IVR SMS ASSIST\Welcome to smsassist.wav]

26273 0 TimeoutClear

26273 0 RunModule PLAY end

26273 0 wa(6316,82622300)

32602 0 Play End line[0] (id=826223)

32602 0 LsPlayMsg EV_PLAY_FINISHED

32602 0 TimeoutSet 10 EV_TIMEOUT_HANGUP

32612 0 TimeoutSet 0 EV_TIMEOUT_GOTOMODULE

32612 0 LsPlayMsgFinished EV_TIMEOUT_GOTOMODULE

32622 0 TimeoutClear

32622 0 [Get Product Code] Number Input

32632 0 [Get Product Code] Playing (C:\Program Files\ivg\Scripts\04MAR2003 IVR SMS ASSIST\T&C.wav)

32682 0 PlaySoundStart ok [C:\Program Files\ivg\Scripts\04MAR2003 IVR SMS ASSIST\T&C.wav]

32682 0 TimeoutClear

32682 0 wa(11756,83263200)

35005 0 tapie monitordigits 51 2

35005 0 LsGetNbrsPlayWelcMsg [3]

35596 0 PlaySoundStop ok

35606 0 [Get Product Code] Number Input 3

35606 0 LsGetNbrsRxDigits [#]

35606 0 TimeoutClear

35616 0 fn PlaySoundStartNumbers C:\Program Files\ivg\system\voice\GetNbrsConfirmIntro.wav, C:\Program Files\ivg\system\voice\GetNbrsConfirmMenu.wav, 3, Digits

35626 0 twcal PlaySayNumber C:\Program Files\ivg\system\voice\GetNbrsConfirmIntro.wav, C:\Program Files\ivg\system\voice\GetNbrsConfirmMenu.wav, 3, , 1

35676 0 PlaySoundStartNumbers ok

35676 0 TimeoutClear

35676 0 wa(8791,83562602)

44489 0 Play End line[0] (id=835626)

44489 0 LsGetNbrsPlayConfirm EV_PLAY_FINISHED

44499 0 TimeoutSet 5 EV_TIMEOUT_REPLAYMSG

44879 0 tapie monitordigits 49 2

44879 0 LsGetNbrsPlayConfirm [1]

44879 0 PlaySoundStop ok

44889 0 TimeoutClear

44889 0 [Access Query] DB Query

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

44910 0 RVreplace start: [sELECT UnitsinStock, UnitPrice FROM Goods WHERE ProductID=$RV[Get Product Code]]

44910 0 RVreplace end: [sELECT UnitsinStock, UnitPrice FROM Goods WHERE ProductID=3]

44910 0 About to execute Retrieve Operation [sELECT UnitsinStock, UnitPrice FROM Goods WHERE ProductID=3]

44920 0 [Access Query] row count=1

44930 0 TimeoutClear

44930 0 RVreplace start: [$RV[Access Query_1_1]]

44940 0 RVreplace end: [145]

44940 0 [say Stock Count Access] Say numbers: 145 as Digits

44950 0 fn PlaySoundStartNumbers , , 145, Digits

44950 0 twcal PlaySayNumber , , 145, , 1

44990 0 PlaySoundStartNumbers ok

45000 0 TimeoutClear

45000 0 wa(1973,84495002)

46982 0 Play End line[0] (id=844950)

46992 0 LsSayNbrPlay EV_PLAY_FINISHED

46992 0 TimeoutSet 10 EV_TIMEOUT_HANGUP

46992 0 TimeoutSet 0 EV_TIMEOUT_GOTOMODULE

47003 0 LsSayNbrPlay EV_TIMEOUT_GOTOMODULE

47003 0 TimeoutClear

47013 0 RVreplace start: [$RV[Access Query_2_1]]

47013 0 RVreplace end: [45]

47023 0 [say Price Access] Say numbers: 45 as Amount Cents, Decimal Point

47023 0 fn PlaySoundStartNumbers , , 45, Amount Cents, Decimal Point

47033 0 twcal PlaySayNumber , , 4500, , 12

47073 0 PlaySoundStartNumbers ok

47083 0 TimeoutClear

47083 0 wa(3901,84703304)

50998 0 Play End line[0] (id=847033)

50998 0 LsSayNbrPlay EV_PLAY_FINISHED

50998 0 TimeoutSet 10 EV_TIMEOUT_HANGUP

51008 0 TimeoutSet 0 EV_TIMEOUT_GOTOMODULE

51008 0 LsSayNbrPlay EV_TIMEOUT_GOTOMODULE

51018 0 TimeoutClear

51018 0 [Get New Stock] Number Input

51028 0 [Get New Stock] Playing (C:\Program Files\ivg\Scripts\04MAR2003 IVR SMS ASSIST\amendprice.wav)

51068 0 PlaySoundStart ok [C:\Program Files\ivg\Scripts\04MAR2003 IVR SMS ASSIST\amendprice.wav]

51078 0 TimeoutClear

51078 0 wa(2766,85102800)

53852 0 Play End line[0] (id=851028)

53862 0 LsGetNbrsPlayWelcMsg EV_PLAY_FINISHED

53862 0 TimeoutSet 10 EV_TIMEOUT_HANGUP

53872 0 TimeoutSet 10 EV_TIMEOUT_GOTOMODULE

54664 0 tapie monitordigits 50 2

54664 0 LsGetNbrsRxDigits [2]

54674 0 [Get New Stock] Number Input 2

54674 0 TimeoutSet 10 EV_TIMEOUT_GOTOMODULE

55815 0 tapie monitordigits 51 2

55815 0 LsGetNbrsRxDigits [3]

55825 0 [Get New Stock] Number Input 23

55825 0 TimeoutSet 10 EV_TIMEOUT_GOTOMODULE

65749 0 Timer fired EV_TIMEOUT_GOTOMODULE

65749 0 LsGetNbrsRxDigits EV_TIMEOUT_GOTOMODULE

65759 0 TimeoutClear

65759 0 [Play 4] Playing

65769 0 [Play 4] Playing (C:\Program Files\ivg\Scripts\04MAR2003 IVR SMS ASSIST\commandfailed.wav)

65810 0 PlaySoundStart ok [C:\Program Files\ivg\Scripts\04MAR2003 IVR SMS ASSIST\commandfailed.wav]

65820 0 TimeoutClear

65820 0 RunModule PLAY end

65820 0 wa(2396,86576900)

68233 0 Play End line[0] (id=865769)

68233 0 LsPlayMsg EV_PLAY_FINISHED

68233 0 TimeoutSet 10 EV_TIMEOUT_HANGUP

68243 0 TimeoutSet 0 EV_TIMEOUT_GOTOMODULE

68243 0 LsPlayMsgFinished EV_TIMEOUT_GOTOMODULE

68253 0 TimeoutClear

68253 0 [select Query] Playing

68263 0 [select Query] Playing (C:\Program Files\ivg\Scripts\04MAR2003 IVR SMS ASSIST\Welcome to smsassist.wav)

68313 0 PlaySoundStart ok [C:\Program Files\ivg\Scripts\04MAR2003 IVR SMS ASSIST\Welcome to smsassist.wav]

68313 0 TimeoutClear

68313 0 RunModule PLAY end

68323 0 wa(6316,86826300)

74652 0 Play End line[0] (id=868263)

74652 0 LsPlayMsg EV_PLAY_FINISHED

74652 0 TimeoutSet 10 EV_TIMEOUT_HANGUP

74662 0 TimeoutSet 0 EV_TIMEOUT_GOTOMODULE

74662 0 LsPlayMsgFinished EV_TIMEOUT_GOTOMODULE

74672 0 TimeoutClear

74672 0 [Get Product Code] Number Input

74682 0 [Get Product Code] Playing (C:\Program Files\ivg\Scripts\04MAR2003 IVR SMS ASSIST\T&C.wav)

74732 0 PlaySoundStart ok [C:\Program Files\ivg\Scripts\04MAR2003 IVR SMS ASSIST\T&C.wav]

74732 0 TimeoutClear

74732 0 wa(11756,87468200)

82373 0 LsGetNbrsPlayWelcMsg EV_TIMEOUT_HANGUP

83054 0 PlaySoundStop ok

83064 0 Hanging up call...

83064 0 TimeoutSet 2 EV_TIMEOUT_WAITFORIDLEAFTERLINEDROP

83064 0 PlaySoundStop ok

83074 0 fnHangupCall end

83245 0 tapie callstate DISCONNECTED 65778,1,0

83245 0 LsAwaitingCalls EV_REMOTEPARTY_DISCONNECT

83255 0 PlaySoundStop ok

83255 0 Hanging up call...

83265 0 TimeoutSet 2 EV_TIMEOUT_WAITFORIDLEAFTERLINEDROP

83265 0 PlaySoundStop ok

83265 0 fnHangupCall end

83275 0 tapie callstate IDLE 65778 0 0

83275 0 WorkingMode@Idle=

83285 0 TimeoutClear

83285 0 TimeoutSet 1 EV_TIMEOUT_TIMETOREINITLINE

83295 0 tapi Reply 65948 0

83295 0 tapi Reply 65982 0

84196 0 Timer fired EV_TIMEOUT_TIMETOREINITLINE

84196 0 LsAwaitingCalls EV_TIMEOUT_TIMETOREINITLINE

84206 0 Initialise telephony (due to IDLE)

84206 0 tapic lineDeallocateCall(MainCall:65778) 0

85027 0 Waiting for a call...

85037 0 hLine=65931

85037 0 TimeoutSet 5 EV_TIMOUT_ATERIDLE_ALLOWOUT

90044 0 Timer fired EV_TIMOUT_ATERIDLE_ALLOWOUT

Share this post


Link to post

The trace did not show the UPDATE statement executed...

I would try running the SQL query first from an SQL Query tool - and once it works then copy the query into VoiceGuide. There are many various SQL Query tools around.

(BTW: in your database is ProductID an integer field or a string field?)

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
×