>>When I APPEND BLANK, my new record is inserted at the bottom of the GRID. I would like to insert a blank record right below the
>>current record.
>>How do you APPEND BLANK a record right below the current record?
>
>You could play with INSERT BLANK if your table is small. However, the better way is to SET ORDER to Tag1, and append new record (using INSERT-SQL) with the key fields (part of Tag1 expression) providing necessary location of this record in index sequence. For example, if you have cursor field listorder with record values 1,5,7, you could insert record with listorder=6 and this record will appear between '5' and '7' records.
I don't think that INSERT BLANK would work. You can't really insert. This isn't a spreadsheet. This is exactly the reason for keys and primary keys. An index tells the pointer where to find the next item in a list.
As Edward said, appending/inserting are identical in function. The new record is given the recno: reccount+1. The only time FP allows you to mess with record numbers is when you PACK or ZAP. FoxPro allows you to collapse data tables, but not expand it from within. Besides, with SET ORDER, you don't need to be concerned with recno().
Matt McDonnell
...building a better mousetrap with moldy cheese...