parky Member P Join Date Oct 2004 Location Midlands Posts 5,779 Jun 2, 2021 #31 It would be good to see the video if it was not private ?
ndzied1 Lifetime Supporting Member Join Date Aug 2002 Location Chicago, Illinois Posts 2,857 Jun 2, 2021 #32 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.
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 Member OP L Join Date Jul 2008 Location Summerside Posts 210 Jun 2, 2021 #33 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: Code: Dim sql sql="Select * FROM meerer12.recipe_list Where scan_code = '" & $RecipeScan & "'" $numCur=$DBCursorOpenSQL("MySqlDB",sql) Works perfectly...
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: Code: Dim sql sql="Select * FROM meerer12.recipe_list Where scan_code = '" & $RecipeScan & "'" $numCur=$DBCursorOpenSQL("MySqlDB",sql) Works perfectly...
Phrog30 Member P Join Date Dec 2006 Location Montgomery, Alabama Posts 1,048 Jun 2, 2021 #34 ndzied1 said: This whole thread is getting pretty squirrely. https://youtu.be/gLspi3UscUk Click to expand... You aren't kidding. It shouldn't be that complicated.
ndzied1 said: This whole thread is getting pretty squirrely. https://youtu.be/gLspi3UscUk Click to expand... You aren't kidding. It shouldn't be that complicated.
drbitboy Lifetime Supporting Member Join Date Dec 2019 Location Rochester, NY Posts 8,153 Jun 2, 2021 #35 Phrog30 said: You aren't kidding. It shouldn't be that complicated. Click to expand... 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.
Phrog30 said: You aren't kidding. It shouldn't be that complicated. Click to expand... 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 Member OP L Join Date Jul 2008 Location Summerside Posts 210 Jun 2, 2021 #36 ndzied1 said: This whole thread is getting pretty squirrely. https://youtu.be/gLspi3UscUk Click to expand... Very true, but a good/frustrating learning experience.... thanks to all
ndzied1 said: This whole thread is getting pretty squirrely. https://youtu.be/gLspi3UscUk Click to expand... Very true, but a good/frustrating learning experience.... thanks to all
ndzied1 Lifetime Supporting Member Join Date Aug 2002 Location Chicago, Illinois Posts 2,857 Jun 2, 2021 #37 Glad you got it working.