Query Database-fail And Rowcount=0

[amolinero]

Hi!

I need detect when my database is down when i use query database node.

The thing is that the result for this node is fail in these both cases:

-> RowCount is 0

-> DataBase error

 

How can i do for diference between cases?

 

Thanks in advance.

[SupportTeam]

If you want to detect if database does not answer I'd recommend using a VBScript module to do the Database query - you will then be able to check for all sorts of error conditions at every stage of database interaction.

[amolinero]

In my case, i have to play with tts table records and after every row, wait for customer action and if there is no action, go to next record. If i use vbScript, it getting complicated.

 

Thanks

[SupportTeam]

Please try this:

Uninstall your current version of VG (backup your scripts first!) then install v5.2.3 - download it here: [old link removed]

Then update v5.2.3 with attached .exe (below) then run the script and capture a copy of VoiceGuide's Debug Printout which captures the problem when trying to read the database, this will allow us to see the error number returned.

You should then be able to use the error number in the path in the DB Query module to branch to a specific module based on that error.

eg. if error number is 12345 then the path would be:

on {12345} goto [Play Error Message]

[amolinero]

Ok. i´ll try it. thanks!