Solved

data report and data environment

Posted on 2003-12-08
7
582 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
How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

 
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 100 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

Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Problem to adjust sheet 1 82
squareUp  challenge 22 107
WMI, model #, retrieving information 10 94
Adoquery sql  left join does not work 25 50
Go is an acronym of golang, is a programming language developed Google in 2007. Go is a new language that is mostly in the C family, with significant input from Pascal/Modula/Oberon family. Hence Go arisen as low-level language with fast compilation…
Whether you've completed a degree in computer sciences or you're a self-taught programmer, writing your first lines of code in the real world is always a challenge. Here are some of the most common pitfalls for new programmers.
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 …
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

760 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now