Hello,

Please help to fix this error in script:

Hi mirip

The column NAME is a string data type, so you need quotes around the parameter value:

... WHERE NAME = ‘“ & SmartTags(“NAME”) & “‘“

...sent from App

Hi, thanks Michael, it's ok!

again one other problème if I use un AND in clause WHERE:

WHERE NAME = ‘“ & SmartTags(“NAME”) & “‘“  AND  NUM = & SmartTags(“NUM”)

Best regards,

mirip.

Hi

Here you will need to be carefull which part of the expression is included in the WHERE clause as constant and which part is a variable:

WHERE NAME = ‘“ & SmartTags(“NAME”) & “‘ AND NUM = “ & SmartTags(“NUM”)

Hello,

here's what I want to look

WHERE NAME = ‘“ & SmartTags(“NAME”) & “‘   (string)

         AND

WHERE NUM = '“ & SmartTags(“NUM”) &"'       (int)

 Best regards,

mirip

Hi mirip,

This is also correct.

When you refer to a string value, it needs quotes (' ') but when you refer to a numering value, then it does not need the quotes, so the actual expression if entered in SQL Manager should look like this:

WHERE NAME = ‘mirip‘ AND NUM = 1

So to replace the parameters with tags, you need to build the string like this:

WHERE NAME = ‘“ & SmartTags(“NAME”) & “‘ AND NUM = “ & SmartTags(“NUM”)

Of course this is just the last part of the SQL statement. If you want the complete statement, then it should be like this:

SQL_Table = "SELECT * FROM TClient WHERE NAME = ‘“ & SmartTags(“NAME”) & “‘ AND NUM = “ & SmartTags(“NUM”)

Hello,
Still a problem with my script (winccflex2008).
I have to subtract two variables (real), but I can not! 

smartTags ("Result") = smartTags ("Tag_1")  -  smartTags ("Tag_2")
please help me

Best regards,

mirip