Information générale
Catégorie:
Codage, syntaxe et commandes
>>>>Thank you. But in my case the cursor already exist. So, I am not sure that the INSERT INTO will work.
>>
>>Works fine. There's also an older/quicker APPEND FROM ARRAY option that also will work well with your 2-D array - APPEND FROM ARRAY only appends one row if it's a 1-D array. APPEND also brings quaint constructs from yester-year, e.g. APPEND FROM ARRAY FIELDS like g*/FIELDS EXCEPT z* that can avoid long field lists or screeds of code.
>
>You know, what a totally amazing language FoxPro is. They made it so easy to manipulate data.
They had even more things where most devs did not realize the options: the innocent looking
SAVE TO FileName | MEMO MemoFieldName [ALL LIKE Skeleton | ALL EXCEPT Skeleton]
which gave you "document data store" looong before XML, REST or JSON were invented.
And going via memo field was exceptionally fast on very early nineties HW - IIRC I blew away competition with IDE drive and 80486 on DOS FP with that specific trick to emulate something we now call "table buffered input": Ability to edit several records and then deciding to save or throw away was unheard of back then - I fell in love with the idea after reading a book on FP-Dos capabilities which included an array-based approach to refrain from binding to .dbf records directly.
I "iust" ran with the concept ballooning it into enabling buffering inside a single table, as work areas were not abundant like today...
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement