Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Update cursor from array
Message
De
14/08/2019 17:42:21
 
 
À
14/08/2019 16:24:39
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
01670075
Message ID:
01670088
Vues:
58
>>>>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
Fil
Voir

Click here to load this message in the networking platform