?
Solved

data report and data environment

Posted on 2003-12-08
7
Medium Priority
?
593 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

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

Today, the web development industry is booming, and many people consider it to be their vocation. The question you may be asking yourself is – how do I become a web developer?
Q&A with Course Creator, Mark Lassoff, on the importance of HTML5 in the career of a modern-day developer.
In this fifth video of the Xpdf series, we discuss and demonstrate the PDFdetach utility, which is able to list and, more importantly, extract attachments that are embedded in PDF files. It does this via a command line interface, making it suitable …
Introduction to Processes

762 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