We've Moved! Please visit our new and improved forum over at our new portal: https://portal.plumvoice.com/hc/en-us/community/topics

Query database

Questions and answers about Plum Fuse development

Moderators: admin, support

Locked
wrothman@dealermagic.net
Posts: 69
Joined: Wed Feb 24, 2010 5:59 pm
Location: Chagrin Falls, OH
Contact:

Query database

Post by wrothman@dealermagic.net »

In filtering for a valid unique number in the table I have the caller entering the number he has, then, if it matches one of the rows containing that same number, we pull the row to initiate the call. If however, the caller enters the number he has incorrectly but, when we announce it back to him, he incorrectly answers that the number is correct, we get an unwired node message. Clearly there is no filtered data that matches and the caller should not be able to proceed. How would I branch that instance to take the caller back to the enter prompt or, alternatively, give him a prompt that the data does not match any open files. I tried branching, to no avail. I think my issue is that this error occurs before I've actually selected a row. Any suggestions?
DMIVS

support
Posts: 3632
Joined: Mon Jun 02, 2003 3:47 pm
Location: Boston, MA
Contact:

Branching when no rows are pulled

Post by support »

Hi,

You would want to branch when the query returns no matching rows. This could be done in two different places. The first would be within the Query Database module. If you select 'Error handling' from the drop-down menu the nodes for "No matching rows" and "Invalid query" should be visible. The second location would be "No row to fetch" within the Get Row from Stack module.

Regards,
Plum Support

Locked