David,

Ok, you asked so here's the answer.

The cursor created by SQL SELECT in Fox has always been read-only (since FoxPro 2.x introduced the SELECT command). It is that way in order to comply with the ANSI '92 standard for SQL which states that a cursor created by a select command will accurately reflect the values of the data at the time that the select was executed or it will be capable of writing back to the original tables with any changes that have occured to the data.

Since SELECT command does not produce an updateable cursor (views in VFP do this) then the cursor cannot be writeable.

The issue of one tag only is actually a side effect of how VFP works. Technically you should not be able to produce any indexes on the cursor, but because VFP doesn't try to write to the dbf until the second tag is created, you can sneak in one tag. If yu want strictly work within the specs of VFP you shouldn't create any tags on a cursor created with SELECT.

I can understand someone wanting to grouse after discovering what seems like errant behavior, but the fact is you were trying to do something that isn't supposed to be done. The real bug, IMHO, is that we can create any tag on a read-only cursor, not that we can create only one. Read-only should be read-only.