Indusoft (Aveva Edge) VbScript to find a string in a column and return line values

[parky]

It would be good to see the video if it was not private ?

 

[ndzied1]

Whoops. I fixed the visibility on the video. You should be able to use the same link to see it now. Sorry for the confusion.

 

[lunenburger]

Thanks everyone for the help, especially Norm and drbitboy....

It was the syntax of the Indusoft HMI tag RecipeScan that I had wrong...

Here is the working code:

Dim sql
sql="Select * FROM meerer12.recipe_list Where scan_code = '" & $RecipeScan & "'"
$numCur=$DBCursorOpenSQL("MySqlDB",sql)

Works perfectly...

 

[Phrog30]

This whole thread is getting pretty squirrely.
https://youtu.be/gLspi3UscUk

You aren't kidding. It shouldn't be that complicated.

 

[drbitboy]

You aren't kidding. It shouldn't be that complicated.

Yah that was my bad when I added the "...=?" conjecture, in addition to more or less the working solution the OP ended up with, in Post #2.


If I had not added that conjecture, and OP had not tried it, then this might have been solved a few days ago.

 

[lunenburger]

This whole thread is getting pretty squirrely.

https://youtu.be/gLspi3UscUk

Very true, but a good/frustrating learning experience....

thanks to all

 

[ndzied1]

Glad you got it working.