Need help in Indusoft SCADA VBscript program


#1

Facing some problem while developing SCADA. Kinldy give some solution for below problems.

  1. While using Update statement I want to use tag instead of values e.g
    $DBUpdate(“sajja”,“MFG1_EMPTY_DETAILS”, $Date ,“MFG1_EMPTY_DATE”)
    $DBUpdate(“sajja”,“MFG1_EMPTY_DETAILS”, $Time ,“MFG1_EMPTY_TIME”)
    Its showing “Script is OK “ but it is not showing the current date and time in DB.It copying same $Date and $Time in DB
  2. using Delete statement I want to use tag instead of values e.g
    Query 1:
    $DBDelete( “sajja”, “Recipe”, “REC_Product_Code = $RECIPE_SEL[1]”, “” )

Query 2:

Dim A
A= "Delete from Recipe where REC_Product_Code = $RECIPE_SEL[1] "
$DBExecute(“sajja”,A)
Its showing “Script is OK “ but not working. If I use product code directly instead of $RECIPE_SEL[1] then it I working Ok.