ummer
asked on
XArray and TDBGRID
What are steps to add/delete/update an acess database using XArray and TDBGRID.
ASKER
Hi
In Storage mode with XArrayDB. Which are the steps to add/delete/update records in a Acess database without any data controls.
In Storage mode with XArrayDB. Which are the steps to add/delete/update records in a Acess database without any data controls.
Consider you have 5 columns in TDBGRID
Addition:
TDBGrid1.Update
objXArray.ReDim 0, objXArray.Count(1), 0, 4
For i = 0 To objXArray.Count(1)
rs.addnew ‘Add New Record For each row
For j = 0 To objXArray.Count(2)
Rs.fields(j) = objXArray(i,j)
Next j
rs.update ‘ Update Record for every row
Next i
Addition:
TDBGrid1.Update
objXArray.ReDim 0, objXArray.Count(1), 0, 4
For i = 0 To objXArray.Count(1)
rs.addnew ‘Add New Record For each row
For j = 0 To objXArray.Count(2)
Rs.fields(j) = objXArray(i,j)
Next j
rs.update ‘ Update Record for every row
Next i
ASKER
hi,
I need some more codes from begining with an example
I need some more codes from begining with an example
ASKER
hi Ajexpert,
Please send me the code to update/display an access database record using TDBGRID and XArrayDB (storage mode) alone.
thanking u
Please send me the code to update/display an access database record using TDBGRID and XArrayDB (storage mode) alone.
thanking u
Hi ummer,
It appears that you have forgotten this question. I will ask Community Support to close it unless you finalize it within 7 days. I will ask a Community Support Moderator to:
Accept ajexpert's comment(s) as an answer.
ummer, if you think your question was not answered at all or if you need help, just post a new comment here; Community Support will help you. DO NOT accept this comment as an answer.
EXPERTS: If you disagree with that recommendation, please post an explanatory comment.
==========
DanRollins -- EE database cleanup volunteer
It appears that you have forgotten this question. I will ask Community Support to close it unless you finalize it within 7 days. I will ask a Community Support Moderator to:
Accept ajexpert's comment(s) as an answer.
ummer, if you think your question was not answered at all or if you need help, just post a new comment here; Community Support will help you. DO NOT accept this comment as an answer.
EXPERTS: If you disagree with that recommendation, please post an explanatory comment.
==========
DanRollins -- EE database cleanup volunteer
PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!
No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in Community Support that this question is:
- PAQ/no refund (ajexpert never came back to satisfy questioner's response yet some value was given by initial response)
Please leave any comments here within the
next seven days.
No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in Community Support that this question is:
- PAQ/no refund (ajexpert never came back to satisfy questioner's response yet some value was given by initial response)
Please leave any comments here within the
next seven days.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
XArray is used when it is in Storage Mode.
Please specify the Data Mode you will use.