Solved

data report and data environment

Posted on 2003-12-08
7
585 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
Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

 
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

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Sorting in Excel with Group Headers if the Exist 2 89
allswap challenge 6 96
Adoquery sql  left join does not work 25 89
simplest php form 3 77
This article will show, step by step, how to integrate R code into a R Sweave document
Does the idea of dealing with bits scare or confuse you? Does it seem like a waste of time in an age where we all have terabytes of storage? If so, you're missing out on one of the core tools in every professional programmer's toolbox. Learn how to …
An introduction to basic programming syntax in Java by creating a simple program. Viewers can follow the tutorial as they create their first class in Java. Definitions and explanations about each element are given to help prepare viewers for future …
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…

813 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

11 Experts available now in Live!

Get 1:1 Help Now