Limitations On Sql Statements

[Guest skywalker]

hi

i want to know if there r any limitations on the sql statements i can use with voice guide .. because it doesnt work when it use a little bit complex statement(having more than one join) while it works well if i decreased the joins to one join .. knowing that i have tested the complex statement with the query analyser and it works properly.

regards

[SupportTeam]

VoiceGuide does not do any interpretation on the SQL statement apart from replacing the $RV Result Variables. VG just passes the SQL to the database driver.

 

Which version of VG are you using?

 

Could you please post a copy of VoiceGuide's Trace Logs which captures the problem, 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.

 

[Guest skywalker]

hi

i use version 6 .. and when i finish my ivr wish voice guide 6 .. i will do the whole thing again with a voice modem using voice guide 5.

attached my script and the file created in the log folder.

regards

script_and_log.zip

[Guest skywalker]

hi,

sorry i think i didnt attach the right log file

so here u r the script and log file again

by the way .. i have read the log file .. and it seems the problem is about using 2 successive INNER JOIN's .. it works good on sql query analyzer .. so i dont know what i should add here !!

script_and_log.zip

[Guest skywalker]

hey team

waste no time on ma question .. it works now .. i added some brackets and it worked .. thnx

regards

[SupportTeam]

OK, thanks for letting us know.