Query

[Guest force]

hi

 

when write the oracle sql statment as

select empno ,ename

from emp

where empno=444;

if there is no empno = 444 the sql engine output this message

'no data found '

how to deal with this messag in Evaluate Expression module.

is this message = null ,

1.vgs

[SupportTeam]

Could you please post a copy of VoiceGuide's Debug Printout which captures this sceanrio, this will allow us to see what happened.

 

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.

 

When posting traces/scripts please .ZIP them up and post them as attachements.

[Guest Guest]

hi

i attched 4 log files in the log1 succesd to retrive data , the log2 no data becaus the employe number 444 alredy not found in database schema, in log3 i write select statment ,it must be retrive data form schema , log4 the employe number 7934 already in database but the 444 wrong number

log.zip

[Guest force]

the log files and script

log.zip

[SupportTeam]

Use:

 

ModuleTitle_RowCount

 

This will return the number of entries which were returned.

If no data was retried the RV above will hold the value of 0.

[Guest force]

hi

i already use ModuleTitle_RowCount for check the row count, but the same

when input employe number 7788 the script sucess, if input empn=999

the script exit, attached scribt , s4,s5 log file

t5.zip

[SupportTeam]

Have you tried adding a fail path from the DBQuery module to the Evaluate expression module?

 

If the database query does not get any results it looks for a fail path. If there is no fail path then VoiceGuide will end the call - which is what's happening here.

[Guest force]

yes i know this what happen ! but the voice guide must be deal with no data retrived from database. so when the ModuleTitle_RowCount will equal to 0,

[SupportTeam]

If the database query does not get any results it looks for a fail path. If there is no fail path then VoiceGuide will end the call - which is what's happening here.

 

You must specify the 'fail' path if you want to handle a situation where no data is retrieved.