on 10-01-2008 12:19 PM
Hi All
How to store matrix values(used as grid) in database
??
thanks in advance...
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
it's up to you to insert the data to DB.
you have to go through the grid (cells) and save the data in DB.
lg David
but i dont know to do it? I want to save my grid values to database?
In the form u will be having a button on that button click IN the ITem event u need to Insert the values to the data base u can do that using a Record set or User tables object....
Vasu Natari.
Is it System form Matrix? or add On Matrix?
Regards,
Benjamin
it is system form matrix.
Then they will be inserted automatically.... u dont need any coding for that.
Please go through this code. I think it will use for your requirement.
Dim objMatDet As SAPbouiCOM.Matrix
Dim rsTrial As Recordset
Dim objForm As SAPbouiCOM.Form
Dim intCount As Integer
dim valBudjet as edittext
dim strBudjet as string
dim strSql as string
objMatDet = objForm.Items.Item("12").Specific
If objMatDet.RowCount > 0 Then
For intCount = 1 To objMatDet.VisualRowCount - 1
valAcctName = objMatDet.Columns.Item("3").Cells.Item(intCount).Specific
If valBudjet.Value <> "" Then
strBudjet = valBudjet.Value
Else
strBudjet = ""
End If
-
>>>>>>> Here u can write a query to insert in the database
Next
end if
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.