Question:
How can I update or delete a selected record in E3Browser?
Solution:
To do so, you must first add a script to E3Browser‘s Click or DblClick events using GetColumnValue method to pass the fields’ values to SetPoints. For example:
Screen.Item(“Text1”).Value = GetColumnValue(1)
Screen.Item(“Text2”).Value = GetColumnValue(2)
Screen.Item(“Text3”).Value = GetColumnValue(0)
After editing the values at the SetPoints, you must run a Query to update the selected record according to its timestamp. For example:
UPDATE Table
SET Field1 = Var1, Field2 = Var2
WHERE E3TimeStamp = #<%VarTime%>#
To determine VarTime‘s value, you must use SetVariableValue method before Execute.
To delete a selected record, you can write a Query as follows:
DELETE FROM Table1
WHERE E3TimeStamp = #<%VarTime%>#
For further details, see the attached demo application, developed with Elipse E3 v 3.2 b. 260.