Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
A GRID question:
Message
De
19/08/1997 14:17:32
 
 
À
19/08/1997 14:14:53
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00045581
Message ID:
00045614
Vues:
48
>>>>>>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
>>
>>Thanks Ed - I will try it... again.. this message was not in my message box.
>>I only found cause I was reading all the message..
>
>Rob, it was just a reference. Basically, you shouldn't use Insert Blank for real table (e.g. it requires exclusive usage). However, if you have elaborated grid populated by small cursor, then you could try.

thanks Ed - I got you this message in my message box. I am more worried
about not getting all my message (answers to my questions) in
my mail box. I do not always read all the threads.
Robert Keith
Independent Developer
San Antonio, Texas
E-mail address:
rebelrob1@yahoo.com
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform