Using "e_qscardcode" in QC Item-Inspection plan linkage Answered

Fabio

Hi all,

According to the Beas manual

http://www.beascloud.net/docs/help/online_eng/index.html?qc_item_link.htm

I can use some variables in the "condition script" field, how do I use the e_qscardcode variable in an SQL function? my function already returns success or failure

 

Example:

select [dbo].[GeneratePlanBeas] ('C000399')  return "failure"

select [dbo].[GeneratePlanBeas] ('C0003991)  return "sucess"

 

I tried to use it like this but it didn't work.

select [dbo].[GeneratePlanBeas] (e_qscardcode)

 

Rgs

Fabio.

 

 

return invalid column name, he didn't interpret it as the PN code

Comments

2 comments

Date Votes
  • Comment author
    Yaremi Miranda Lopez
    • Official comment

    Hello Fabio,

    I'm afraid that you can't set a value by default in the QC windows, the only option is using beas script.

  • Comment author
    Fabio
    • Edited

    I did it, but I wanted to use the SQL return to use in the "return" but I couldn't, I had to do an "IF"


    select [dbo].[GeneratePlanBeas] (N'<e_qscardcode>')
    if <wert1> = 'failure' then return failure else return success end if


    Is there no way to leave this default command for all inspection plans?

    Rgs,

    Fabio

    0

Please sign in to leave a comment.