>>>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.
>
It works for a cursor. Try quick test:
Create Cursor test (q I)
Insert into test values(3)
Insert into test values(7)
go top
Insert Blank
Browse