KB-14046: Updating or deleting a selected record in E3Browser.

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.

Attachments:

EditRecordOnDbClick.zip

Print Friendly, PDF & Email

Este artigo foi útil? Was this helpful?

Classificação média - Average rating 0 / 5. Count: 0

Leave a Reply

Your email address will not be published.Required fields are marked *