on 05-21-2009 12:32 PM
Hi All,
I am facing a problem while updating a new in row in a matrix. The problem is i have a row in matrix which contains some data. i want to add another row in the same matrix and i want to update it but when click the add row button the row is getting added but it is displaying the same data that is its displaying the same data in the previous row but the newly added row should be empty. pls suggest some solution.
Regards,
Vijay Kumar.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Edy,
Thanks for the reply. Still its not working this is the code m using,
If pVal.MenuUID = "1288" Or pVal.MenuUID = "1289" Or pVal.MenuUID = "1290" Or pVal.MenuUID = "1291" Then
Try
oForm = SBO_Application.Forms.ActiveForm
If oForm.Type = "320" Then
oEdit = oForm.Items.Item("74").Specific
oForm.DataSources.DataTables.Item("SALES").ExecuteQuery("SELECT T0.[U_code], T0.[U_desc], T0.[U_purchase] FROM [dbo].[@SALES] T0 WHERE T0.[U_salescode] ='" & oEdit.Value & "'")
omatrix = oForm.Items.Item("productmat").Specific
omatrix.Columns.Item("item").DataBind.Bind("SALES", "U_code")
omatrix.Columns.Item("itemdes").DataBind.Bind("SALES", "U_desc")
omatrix.Columns.Item("check").DataBind.Bind("SALES", "U_purchase")
omatrix.Clear()
omatrix.LoadFromDataSource()
omatrix.AutoResizeColumns()
End If
Catch ex As Exception
SBO_Application.MessageBox(ex.Message)
End Try
Two rows are getting added with the same data.
User | Count |
---|---|
108 | |
12 | |
11 | |
6 | |
5 | |
4 | |
4 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.