On 14.Mar.2003 -- 04:20 PM, [EMAIL PROTECTED] wrote: > Hi, > This is a part of a query. My problem is that when I make a SELECT right > after an INSERT I don't get the last updated query :
<snip/> > What I mean is that in the last "execute-query" the value "<esql:get-int > column="at_order"/>" returns a value, but in my SQL Profiler I get a > query witch returns another value (the right)!!!! > I think that it is due to the refreshing from the insert, because the > insert value is queried! This is a DBMS specific question. Please refer to your documentation or ask the appropriate support forum. Look out for keywords like isolation mode, transactions Chris. -- C h r i s t i a n H a u l [EMAIL PROTECTED] fingerprint: 99B0 1D9D 7919 644A 4837 7D73 FEF9 6856 335A 9E08 --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]