>Nadya;
>
>A minor point for those that are not aware of the behavior Create Cursor.
>
>CREATE CURSOR creates a temporary table that is opened exclusively regardless of the setting of SET EXCLUSIVE.
>
>If you are on a local machine that is not a problem. On a network it can bite you depending upon what you are doing.
The dbf() of such a cursor is always a {blabla}.tmp on your tmpfiles directory. The bite may come if you index it using a non-structural index, and that index somehow remains on the disk, or you give it a name which may be already in use by someone. At least, that's where it bit me in 2.6. Any other gotchas that you know of?