General information
Category:
Coding, syntax & commands
>>>>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...
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only