Hiroshi Inoue wrote: > > > If the cursor is INSENSITIVE, it mustn't see the row ? > > > > Right. > > If so, isn't the difference between SENSITIVE and INSENSITIVE extreme ?
Yes. > Why do you or Peter refer to ASENSITIVE little ? Not sure --- ASENSITIVE seems to be "do whatever you want", which is always good. > And what does the following mean ? It is placed just before the sentences > you quoted first. > > If a cursor is open, and the SQL-transaction in which the cursor was > opened makes a significant change to SQL-data, then whether that > change is visible through that cursor before it is closed is determined > as follows: There seem to be two sections, one dealing with seeing change made by the same transaction: If a cursor is open, and the SQL-transaction in which the cursor was opened makes a significant change to SQL-data, then whether that change is visible through that cursor before it is closed is determined as follows: and then another talking about holdable cursors after the cursor transaction completes: If a holdable cursor is open during an SQL-transaction T and it is held open for a subsequent SQL-transaction, then whether any significant changes made to SQL-data (by T or any subsequent SQL- transaction in which the cursor is held open) are visible through that cursor in the subsequent SQL-transaction before that cursor is closed is determined as follows: -- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]