Need help in Indusoft SCADA VBscript program

Industrial Automation
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.