HI ALL 

Thanks ALL I GET IT TO WORK. 
Thanks again.




> The problem is one of timing.  It takes time for the server to perform 
its
tasks completely and publish the changes for other processes to see.  You
can avoid this pain entirely by using your VB6 app's ADO control as your
data source.  This assumes that your updates are done with the ADO control,
of course.

If your database is MS SQL, consider setting the transaction isolation mode
to SERIALIZABLE.  It runs slower in the sense that no body can mess around
with the recods you are updating until you are entirely done with your
update. But, when the query returns, the next query is very likely to get
the updated data on the first time.  However, even in this case, if the
server is really busy and it is caching a lot of transactions, you will
experience a delay before the transaction results can be reliably returned
from a small query that is launched right after the update.


----- Original Message -----
From: <pd_otoole@h...>
To: "professional vb" <pro_vb@p...>
Sent: Tuesday, July 23, 2002 3:44 PM
Subject: [pro_vb] Re: REPORTS IN DATAREPORTS.


> What is this report and what is dbmain? is this a grid?
> Try rebind.
>
> > Hello All
>  > I have a query in my database in a program in vb 6.0 the program works
> f> ine when i run it the query update but the report that is base on the
> q> uery do not update with the program run i would have to close the
> program
> f> or the report to update. i would like the report update when the
> program
> i> s runing.
>
> > This is the code i'm useing:
>
> > Private Sub cmdReport_Click()
> d> bMain.Recordset.Refresh
> F> orm2.Show VbModal
> E> nd Sub
>
> >
> I>  use this code in some of my program and it work but not with this. 
The
> r> eport is geting information from (3)tables in the database i have, 
It's
> g> rouping the information to show on the report.
>
> > I would like some help with this Please.
> a> ny code would to get this work.
>
> ---
> Visual C# - A Guide for VB6 Developers
> This book will make it easy to transfer your skills
> from Visual Basic 6 to C#, the language of choice
> of the .NET Framework.
> http://www.wrox.com/ACON11.asp?ISBN=1861007175&p2p0059
>
> ---
> Change your mail options at http://p2p.wrox.com/manager.asp or
> to unsubscribe send a blank email to