data report and data environment

i added a data environment and a data report in my application. the first time i display the data report at runtime, it works ok. however, f i make changes to the table that is bound to the data environment during runtime, and show the data report again, it seems that the content is not updated, unless i stopped the application and execute it again. if i view the table using the Visual Data Manager, it shows the updated value. how can i make runtime updates to my data report?
please help...
Who is Participating?
MobileOakAIConnect With a Mentor Commented:
The following from
reminds me to also recommend "DoEvents"
and that the ".update" was after the "Wend"

With adoField
    MousePointer = vbHourglass
    List1.Visible = False
    'Combo1.Visible = False
    While Not .EOF
        List1.AddItem .Fields("Au_ID")
        Combo1.AddItem .Fields("Author")
    List1.Visible = True
    'Combo1.Visible = True
End With
A close|open operation could do it but you'd do better to roll-in or post results now. Update.
rod4nillosAuthor Commented:
thanks for the comment... actually, i've already tried the open and close operations but it seems that i can't seem find where in the code should i add the operation. i would encounter errors like, i can't use the operation in this context or something like that. i've also tried to do roll-in, and same thing. when and where do the open|close operations fit in? how bout the roll-in?
wish you could help... or suggest a better solution or perhaps a webpage where i can see the solution... thanks...
Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

I dunno. I haven't programmed in awhile, and have no tools handy for review (bare desktop) so I am not sure the language used even. I thought someone else would have added code by now for many languages - try proper TA.

The way I code is separation of initialization from main body. So that is how, leave main body of code, close, open, then back to main body. May still need one more step such as a 'commit' operation to do a 'roll-in', whatever such terms are. Try using help for whatever language, it should have example.

For Access/VB type code, while I think there is a 'commit' operation, I think the one that worked best for me for what you say you want was actually spelled 'update'. I think tou may need a period in front of the word '.update' and it goes at end of loop but inside. After all code processing of individual record.  I remember it took me awhile to figure it out, after that it was just copy|paste what worked. Sorry, but analogy is best I can do, and not sure on memory. But it is the general idea that resolves it for any language.

The modern languages have many temporary buffers or storage areas to enable backing out of changes, as well as to not change any one thing until all changes are prepared and ready to go, so the trick is, to find the terminology to accept the record or records. Here's another keyword 'transaction'. What you are looking for is the update-now word that says you have validated everything you are going to about the transactions, and the results can be posted as acceptable. Or so I gather.
rod4nillosAuthor Commented:

i'm currently using VB to create the application. i've tried a couple of tweaking including the ".update", which can only be connected to the data environment, and so far, it still won't work. so basically, up to now, i still have to close/end the VB application and run it again, just to see the changes.
rod4nillosAuthor Commented:
...thanks for the effort. I really appreciate the suggestions.
and Thank you.   I now have itch for Santa to drop the latest Visual Studios into my stocking.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.