?
Solved

data report and data environment

Posted on 2003-12-08
7
Medium Priority
?
600 Views
Last Modified: 2013-12-13
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...
0
Comment
Question by:rod4nillos
  • 4
  • 3
7 Comments
 
LVL 4

Expert Comment

by:MobileOakAI
ID: 9911736
A close|open operation could do it but you'd do better to roll-in or post results now. Update.
0
 
LVL 2

Author Comment

by:rod4nillos
ID: 9912675
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...
0
 
LVL 4

Expert Comment

by:MobileOakAI
ID: 9917280
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.
0
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
LVL 2

Author Comment

by:rod4nillos
ID: 9918643
thanks...

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.
0
 
LVL 4

Accepted Solution

by:
MobileOakAI earned 300 total points
ID: 9924772
The following from http://www.a1vbcode.com/snippet.asp?ID=1843
reminds me to also recommend "DoEvents"
and that the ".update" was after the "Wend"
---------------------------------------------------------

With adoField
   
    MousePointer = vbHourglass
    .MoveFirst
    Combo1.Clear
    List1.Clear
    List1.Visible = False
    'Combo1.Visible = False
   
    While Not .EOF
        DoEvents
        List1.AddItem .Fields("Au_ID")
        Combo1.AddItem .Fields("Author")
        .MoveNext
    Wend
   
    .MoveFirst
    .Close
    List1.Visible = True
    'Combo1.Visible = True
       
End With
0
 
LVL 2

Author Comment

by:rod4nillos
ID: 9940363
...thanks for the effort. I really appreciate the suggestions.
0
 
LVL 4

Expert Comment

by:MobileOakAI
ID: 9940896
and Thank you.   I now have itch for Santa to drop the latest Visual Studios into my stocking.
0

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this post we will learn how to make Android Gesture Tutorial and give different functionality whenever a user Touch or Scroll android screen.
This article will inform Clients about common and important expectations from the freelancers (Experts) who are looking at your Gig.
Simple Linear Regression
Six Sigma Control Plans

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question