Null Or Empty Database Table

[JBeck]

Hi, I have a problem with my script and hopefully someone can explain to me what I'm doing wrong.

 

With my application (rental listings), properties can be added, updated, or deleted from an Access database via VG. The problem I run into is when a query is run on the DB when it has no records, the caller is disconnected despite any actions I define for Success, Fail, or Timeout results. It is not that the query is returning nothing, but the database is actually empty.

 

I believe this is happening at the Query module, because I tried putting a module to play the Query_RowCount return variable after the actual query, with all paths leading to it, and nothing is played.

 

I am not a programmer and am trying to build this app using Voiceguide modules and SQL statements.

 

I would like to figure out a way for it to say "Zero records found" instead of disconnecting the call. Any help would be greatly appreciated!!

 

Thanks.

[SupportTeam]

Could you please post a copy of VoiceGuide's Debug Printout which captures the problem, this will allow us to see what is going wrong.

 

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.

 

You can enable the automatic saving of the logs to files in \log\ directory as well.

[JBeck]

Thanks to the event log feature I was able to resolve the problem. There was a typo I didn't catch in the SQL query. Thanks!