From: mynamehere@comcast.net   
      
   "Joe-Paul"  wrote in message   
   news:DKKdnSA9vdRB87XZnZ2dnUVZ_tudnZ2d@comcast.com...   
   > Hi Ralph:   
   >   
   >   So I "append" the frist set of data from table one into table two...then   
   > update table two with the info from an SQL getting the corresponding data for   
   > the second part of the comparison.  ONce in the second table, I use another   
   > SQL to bring the data into a datagrid.  But when I do that, the first time   
   the   
   > process runs, the second amount of data does not show up in the grid... I   
   > refresh it, but that doesn't change anything.  If put a "msgbox" in the   
   > procedures just before the grid is loaded...all data shows...without the   
   > "msgbox"...the second half of the data is dropped.   
   >   
      
   This is clearly a timing problem, which the msgbox "fixes" by putting in a big   
   fat delay. It has something to do with the way you are using the grid, not with   
   SQL or the database. Refreshing does not always mean the same thing as Requery,   
   and sometimes just means the display is repainted. After you are done with all   
   data modifications, be certain that you are re-running the query that pulls the   
   data into the grid.   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)