Program Wont Insert Data

[Guest James Benson]

Hi,

I have a problem I hope you can help with.

I get an error on a trace log which says;

ERROR 5.1.3305 DBExecute:3134,Syntax error in INSERT INTO statement.

 

The SQL statement I am using is;

 

INSERT INTO mastertable (workordernumber , employeenumber , repairrequestedby, roomnumber , firstrepairnum , firstrepairdescription) VALUES($RV[receipt] , $RV[enteremployeeidnumber] , '$RV[Access Query 4_1_1]', $RV[askroomnumber] ,$RV[askrepaircode], '$RV[Access Query 3_1_1]')

 

This statement works fine in an older version of VG.

 

Thanks,

Jim

[SupportTeam]

Please post the entire VoiceGuide script (along with the database used) and/or update to v5.2.3 of VG and then post a copy of VoiceGuide's Debug Printout which captures the problem.

[Guest james benson]

where do ZI find the debug printout in that version?

[SupportTeam]

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.

[Guest James Benson]

ok here is what you requested

 

084433.29 0 callstate OFFERING 4342784 0 4

084433.29 0 ring 1

084437.30 0 ring 2

084437.30 0 Answer the call at 8/6/2004 8:44:37 AM

084437.30 0 lineAnswer(4342784) => 3

084437.30 0 tapi Reply (LineEvReply) ok 3 0

084437.30 0 callstate ACCEPTED 4342784 0 0

084437.63 0 callstate CONNECTED 4342784,0,0

084437.63 0 WorkingModeTAPI@Connected=

084437.63 0 WorkingModeScript@Connected=

084437.63 0 Inband detection not enabled

084437.63 0 StartLoadedVgs at 8/6/2004 8:44:37 AM

084437.63 0 [hello intro] Playing

084437.63 0 [hello intro] Playing (hello_intro_bi.wav)

084437.63 0 PlaySoundStart ok [C:\Roomtalk\voiceguide\Scripts\roomtalk script\hello_intro_bi.wav]

084437.63 0 RunModule PLAY end

084442.08 0 dtmf 1 (4342784,49,2)

084442.08 0 LsPlayMsg 1

084442.13 0 PlaySoundStop ok

084442.13 0 [Run VB Script 1] Running VB Script...

084442.13 0 RVreplace start (strlen>100)

084442.13 0 Run Script waiting... (shellid=-408113, process=256)

084443.18 0 LsRunWaitTillFinished EV_TIMEOUT_CHECKONSTATE

084443.18 0 task completed (shellid=-408113, process=256)

084443.18 0 Found result file: C:\Roomtalk\voiceguide\Scripts\roomtalk script\VGRUNRESULT_0.TXT

084443.18 0 Run Results >>>[workorder] {0207190620} , [room] {422} , [repair] {504} , [repaircode] [Tub Drain} , [repaircodetwo] {Tub/Bath tile} , [employee] {102}<<<

084443.18 0 [enteremployeeidnumber] Number Input

084443.23 0 [enteremployeeidnumber] Playing (C:\roomtalk\voiceguide\Scripts\roomtalkscript\employee_code.wav)

084443.23 0 PlaySoundStart ok [C:\Roomtalk\voiceguide\Scripts\roomtalk script\employee_code.wav]

084447.02 0 dtmf 1 (4342784,49,2)

084447.02 0 LsGetNbrsPlayWelcMsg 1

084447.19 0 PlaySoundStop ok

084447.19 0 [enteremployeeidnumber] Number Input 1

084447.24 0 path {1} not found

084447.41 0 dtmf 0 (4342784,48,2)

084447.41 0 LsGetNbrsRxDigits 0

084447.41 0 [enteremployeeidnumber] Number Input 10

084447.41 0 path {10} not found

084447.74 0 dtmf 2 (4342784,50,2)

084447.74 0 LsGetNbrsRxDigits 2

084447.74 0 [enteremployeeidnumber] Number Input 102

084447.74 0 path {102} not found

084447.74 0 path {102} not found

084447.74 0 [Access Query 6] DB Query

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

084447.74 0 RVreplace start: [sELECT employeenumber FROM employeetable WHERE employeenumber = $RV[enteremployeeidnumber]]

084447.74 0 RVreplace end: [sELECT employeenumber FROM employeetable WHERE employeenumber = 102]

084447.79 0 About to execute Retrieve Operation [sELECT employeenumber FROM employeetable WHERE employeenumber = 102]

084447.79 0 [Access Query 6] row count=1

084447.85 0 [Access Query 4] DB Query

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

084447.85 0 RVreplace start: [sELECT (employeename) FROM employeetable WHERE employeenumber = $RV[enteremployeeidnumber]]

084447.85 0 RVreplace end: [sELECT (employeename) FROM employeetable WHERE employeenumber = 102]

084447.85 0 About to execute Retrieve Operation [sELECT (employeename) FROM employeetable WHERE employeenumber = 102]

084447.85 0 [Access Query 4] row count=1

084447.85 0 [askroomnumber] Number Input

084447.85 0 [askroomnumber] Playing (C:\roomtalk\voiceguide\Scripts\roomtalkscript\Ask_room_number.wav)

084447.90 0 PlaySoundStart ok [C:\Roomtalk\voiceguide\Scripts\roomtalk script\Ask_room_number.wav]

084450.48 0 dtmf 4 (4342784,52,2)

084450.48 0 LsGetNbrsPlayWelcMsg 4

084450.54 0 PlaySoundStop ok

084450.54 0 [askroomnumber] Number Input 4

084450.54 0 path {4} not found

084450.87 0 dtmf 2 (4342784,50,2)

084450.87 0 LsGetNbrsRxDigits 2

084450.87 0 [askroomnumber] Number Input 42

084450.87 0 path {42} not found

084451.09 0 dtmf 2 (4342784,50,2)

084451.09 0 LsGetNbrsRxDigits 2

084451.09 0 [askroomnumber] Number Input 422

084451.09 0 path {422} not found

084457.68 0 LsGetNbrsRxDigits EV_TIMEOUT_ENTERDATA

084457.68 0 path {422} not found

084457.68 0 [Access Query 5] DB Query

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

084457.68 0 RVreplace start: [sELECT roomnumber FROM roomnumberstable WHERE roomnumber = $RV[askroomnumber]]

084457.68 0 RVreplace end: [sELECT roomnumber FROM roomnumberstable WHERE roomnumber = 422]

084457.68 0 About to execute Retrieve Operation [sELECT roomnumber FROM roomnumberstable WHERE roomnumber = 422]

084457.68 0 [Access Query 5] row count=1

084457.68 0 [askrepaircode] Number Input

084457.68 0 [askrepaircode] Playing (C:\roomtalk\voiceguide\Scripts\roomtalkscript\enter_repair_code_num.wav)

084457.73 0 PlaySoundStart ok [C:\Roomtalk\voiceguide\Scripts\roomtalk script\enter_repair_code_num.wav]

084500.97 0 dtmf 1 (4342784,49,2)

084500.97 0 LsGetNbrsPlayWelcMsg 1

084500.97 0 PlaySoundStop ok

084500.97 0 [askrepaircode] Number Input 1

084500.97 0 path {1} not found

084502.73 0 dtmf 0 (4342784,48,2)

084502.73 0 LsGetNbrsRxDigits 0

084502.73 0 [askrepaircode] Number Input 10

084502.73 0 path {10} not found

084503.34 0 dtmf 1 (4342784,49,2)

084503.34 0 LsGetNbrsRxDigits 1

084503.34 0 [askrepaircode] Number Input 101

084503.34 0 path {101} not found

084503.34 0 path {101} not found

084503.34 0 [Access Query 2] DB Query

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

084503.39 0 RVreplace start: [sELECT repaircodenumber FROM repaircodetable WHERE repaircodenumber = $RV[askrepaircode]]

084503.39 0 RVreplace end: [sELECT repaircodenumber FROM repaircodetable WHERE repaircodenumber = 101]

084503.39 0 About to execute Retrieve Operation [sELECT repaircodenumber FROM repaircodetable WHERE repaircodenumber = 101]

084503.39 0 [Access Query 2] row count=1

084503.39 0 [Access Query 3] DB Query

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

084503.39 0 RVreplace start: [sELECT (repaircodedescription) FROM repaircodetable WHERE repaircodenumber = $RV[askrepaircode]]

084503.39 0 RVreplace end: [sELECT (repaircodedescription) FROM repaircodetable WHERE repaircodenumber = 101]

084503.39 0 About to execute Retrieve Operation [sELECT (repaircodedescription) FROM repaircodetable WHERE repaircodenumber = 101]

084503.39 0 [Access Query 3] row count=1

084503.39 0 [printpath] Evaluate [($RV[askrepaircode]) = 100]

084503.39 0 RVreplace start: [($RV[askrepaircode]) = 100]

084503.45 0 RVreplace end: [(101) = 100]

084503.45 0 .Eval((101) = 100)

084503.45 0 Eval Expr result:[False]

084503.45 0 [repairtwo] Playing

084503.45 0 [repairtwo] Playing (C:\roomtalk\voiceguide\Scripts\roomtalkscript\enter_repair_code_number_two.wav)

084503.50 0 PlaySoundStart ok [C:\Roomtalk\voiceguide\Scripts\roomtalk script\enter_repair_code_number_two.wav]

084503.50 0 RunModule PLAY end

084507.89 0 dtmf 1 (4342784,49,2)

084507.89 0 LsPlayMsg 1

084507.89 0 PlaySoundStop ok

084507.89 0 [askrepairtwo] Number Input

084507.89 0 [askrepairtwo] Playing (C:\roomtalk\voiceguide\Scripts\roomtalkscript\enter_repair_code_num.wav)

084508.00 0 PlaySoundStart ok [C:\Roomtalk\voiceguide\Scripts\roomtalk script\enter_repair_code_num.wav]

084510.92 0 dtmf 5 (4342784,53,2)

084510.92 0 LsGetNbrsPlayWelcMsg 5

084510.92 0 PlaySoundStop ok

084510.92 0 [askrepairtwo] Number Input 5

084510.92 0 path {5} not found

084511.63 0 dtmf 0 (4342784,48,2)

084511.63 0 LsGetNbrsRxDigits 0

084511.63 0 [askrepairtwo] Number Input 50

084511.63 0 path {50} not found

084511.85 0 dtmf 0 (4342784,48,2)

084511.85 0 LsGetNbrsRxDigits 0

084511.85 0 [askrepairtwo] Number Input 500

084511.85 0 path {500} not found

084511.85 0 path {500} not found

084511.85 0 [Access Query 9] DB Query

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

084511.90 0 RVreplace start: [sELECT repaircodenumber FROM repaircodetable WHERE repaircodenumber = $RV[askrepairtwo]]

084511.90 0 RVreplace end: [sELECT repaircodenumber FROM repaircodetable WHERE repaircodenumber = 500]

084511.90 0 About to execute Retrieve Operation [sELECT repaircodenumber FROM repaircodetable WHERE repaircodenumber = 500]

084511.90 0 [Access Query 9] row count=1

084511.90 0 [Access Query 7] DB Query

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

084511.90 0 RVreplace start: [sELECT (repaircodedescription) FROM repaircodetable WHERE repaircodenumber = $RV[askrepairtwo]]

084511.90 0 RVreplace end: [sELECT (repaircodedescription) FROM repaircodetable WHERE repaircodenumber = 500]

084511.90 0 About to execute Retrieve Operation [sELECT (repaircodedescription) FROM repaircodetable WHERE repaircodenumber = 500]

084511.90 0 [Access Query 7] row count=1

084511.90 0 [Access Query 1] DB Query

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

084511.90 0 RVreplace start (strlen>100)

084511.90 0 About to execute Action Query

084512.01 0 ERROR 5.1.3305 DB Execute: 3134,Syntax error in INSERT INTO statement.

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

084512.01 0 RecSoundStop ok

084512.01 0 PlaySoundStop ok

084512.01 0 fnHangupCall end

084512.95 0 callstate IDLE 4342784 0 0

084512.95 0 WorkingMode@Idle=

084512.95 0 tapi Reply (LineEvReply) ok 4 0

084513.99 0 LsAwaitingCalls EV_TIMEOUT_TIMETOREINITLINE

084513.99 0 ReinitTelephony due to IDLE start

084513.99 0 tapic lineDeallocateCall(MainCall:4342784) 0

084514.38 0 lineOpen(0) => 0

084514.38 0 Waiting for a call...

084514.38 0 lineOpen(0)LineHandle=4341992

090510.16 0 sys cleanup Start

090510.16 0 sys cleanup End

[waliwiz]

I hope you get these

masterdb.zip

[SupportTeam]

Please post the VoiceGuide script you are using...

[Guest James Benson]

I'm sorry , I thought I had already sent this script.

Thanks,

Jim

new_puter_bilingual.zip

[SupportTeam]

OK. Which version of VoiceGuide are you using right now? (plz see the "About VG" selection from the Help menu)

[Guest James Benson]

the version is 5.1.3302.

In case you tell me to upgrade, i need to know if upgrading will affect the license

on the version I have now?

Thanks,

jim

[SupportTeam]

Please update to v5.2.3 and post trace from that version. (backup any scripts you need first!)

 

You will be able to use the license key from v5.1 (or v5.0) with v5.2

[Guest James Benson]

I dont believe I have the license key ( code nymbers) anymore . Where can I find them at on the program?

Thanks,

Jim

[SupportTeam]

They are in the USERINFO.INI file - just backup that file before uninstalling Voiceguide and after installing new version just copy that file into VG's directory.

[Guest James Benson]

ok, here is the trace log from the updated voice guide

8604_err0r.doc

[SupportTeam]

You can see from the trace that $RV[receipt] which is used in the SQL statement has not been defined earlier in the script- so it is replaced by a blank - which then causes the syntax error when trying to execute the SQL command.

 

Suggest checking the script to see why $RV[receipt] is not getting defined - or maybe yo should be using another RV?

145613.32  0 rv    replace start: [iNSERT INTO mastertable (workordernumber , employeenumber , repairrequestedby, roomnumber , firstrepairnum , firstrepairdescription) VALUES($RV[receipt] , $RV[enteremployeeidnumber] , '$RV[Access Query 4_1_1]', $RV[askroomnumber] ,$RV[askrepaircode], '$RV[Access Query 3_1_1]')]

 

145613.32  0 rv    ns [PathSysVoice]{}[PathApp]{C:\ROOMTALK\VOICEGUIDE\}[PathDataVm]{C:\ROOMTALK\VOICEGUIDE\data\}[PathVgSys]{C:\ROOMTALK\VOICEGUIDE\system\}[scriptsPath]{C:\Roomtalk\voiceguide\Scripts\roomtalk script\}[scriptPath]{C:\Roomtalk\voiceguide\Scripts\roomtalk script}[$RV_STARTTIME]{8/13/2004 2:55:35 PM}[$RV_DEVICEID]{0}[$RV_CIDNAME]{}[PathApp]{C:\ROOMTALK\VOICEGUIDE\}[$RV_CIDNUMBER]{}[hello intro]{1}[workorder]{0207190620}[room]{422}[repair]{504}[repaircode]{Tub/Bath tile}[employee]{102}[enteremployeeidnumber]{102}[enteremployeeidnumber_PathTaken

{success}[Access Query 6_RowCount]{1}[Access Query 6_1_1]{102}[Access Query 4_RowCount]{1}[Access Query 4_1_1]{Jim Benson}[askroomnumber]{422}[askroomnumber_PathTaken]{success}[Access Query 5_RowCount]{1}[Access Query 5_1_1]{422}[askrepaircode]{102}[askrepaircode_PathTaken]{success}[Access Query 2_RowCount]{1}[Access Query 2_1_1]{102}[Access Query 3_RowCount]{1}[Access Query 3_1_1]{Door Lock}[printpath_Input]{(102) = 100}[printpath]{False}[repairtwo]{2}

 

145613.32  0 db    About to execute a Modify type operation [iNSERT INTO mastertable (workordernumber , employeenumber , repairrequestedby, roomnumber , firstrepairnum , firstrepairdescription) VALUES( , 102 , 'Jim Benson', 422 ,102, 'Door Lock')]