Error Message 5.1.3000

[hdouglas]

I am trying to do a database query from an ACCESS database and then play the wav file returned from the query.

 

The query returns the expected result when performed outside Voiceguide, but within it I get the following error in the Event Trace Log

 

141802.39  5 [web_text_speak_db] DB Query

141802.39  5 Jet mode used (To use ODBC mode specify ODBC Connect string)

141802.41  5 RVreplace start (strlen>100)

141802.41  5 About to execute Retrieve Operation [sELECT web_text_file FROM main WHERE user_gsm=07770577300' AND con1_gsm='07770577300' AND pin='817]

141802.42  5 ERROR 5.1.3000 OpenRecordset: 3061:Too few parameters. Expected 2.

141802.42  5 Hanging up call... [srlib 282]

 

Testing with a short script where the above QUERY is hard coded the expected wav file is played, in the above example the parameters user_gsm, con1_gsm and pin are all entered from values captured in VG.

 

Is there any further documentation other than the help files which give more details on these error messages?

 

Set up is VG5.1 Dialogic D/4PCI

[hdouglas]

Answer found, it appears the database being pointed to by the script was just an empty container and not the one containing data.