Link to home
Start Free TrialLog in
Avatar of ummer
ummer

asked on

XArray and TDBGRID

What are steps to add/delete/update an acess database using XArray and TDBGRID.

Avatar of ajexpert
ajexpert
Flag of United States of America image

There are different Data Modes of operation for TDBGRID namely Bound, Unbound, Unbound Extended, Storage

XArray is used when it is in Storage Mode.

Please specify the Data Mode you will use.
Avatar of ummer
ummer

ASKER

Hi
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
Avatar of ummer

ASKER

hi,
I need some more codes from begining with an example
Avatar of ummer

ASKER

hi Ajexpert,
Please send me the code to update/display an access database record using TDBGRID and XArrayDB (storage mode) alone.
thanking u
Avatar of DanRollins
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
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.
ASKER CERTIFIED SOLUTION
Avatar of SpideyMod
SpideyMod

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial