Sorry, forgot to include that I am using IE5.5 and the ILayer mentioned is 
actually IFrame.

Peter

> Hi all,

> I would appreciate any advice anyone can provide with this strange 
p> roblem. The question isn't really SQL language related but I didn't 
know 
w> here else to put it.

> In my web page I use an ILayer to get and display a recordset with 
several 
c> olumns.  This happens both at page load and at any time the user adds 
or 
d> eletes a record to/from the database table.

> Works great on load; works sometimes when changes are made. The 
(> javascript) function call in both cases is exactly the same. There 
seems 
t> o be no pattern to when it will and when it will not bring back the 
c> hanged table contents.  I know that the table IS changed and that the 
I> Layer SHOULD bring the new data back. Like I said, sometimes yes and 
s> ometimes no.

> It occured to me that maybe SQL 2000 caches newly written records until 
s> ome buffer or something is full and that's why the performance is 
i> ntermittent.  Doesn't sound right but it's the only thing I can think 
of.
B> y the way, the write of a new record is followed immediately by the 
I> Layer SRC page reading the table for changes.  I have no idea if that's 
p> ertinent.

> If anyone can offer a clue I would be most appreciative.  Thanks in 
a> dvance for your help.

> Peter