Appending/Inserting Records from JSON

[HankFay]

I have a little builder that lets me set the properties for all the items in a section from a browse grid. Very handy, even in its alpha state.

It stores everything in a cursor created on the spot.

I am saving the settings in JSON, using SELECT ... into JSON <filename>, which works great.

What I am wondering: is there a command that will insert/append directly from the JSON file? If not, no big deal, as writing a library routine with a few lines of code to iterate the rows of the array and then performing an INSERT ... from OBJECT ... is easy enough. But I try not to duplicate Lianja built-ins where there is no additional functionality to bundle up, so I thought I'd ask.

thanks,

Hank

[barrymavin]

Hi Hank,

SQL INSERT ... FROM NAME
https://www.lianja.com/doc/index.php/INSERT

Theres nothing that will insert from a JSON file.

[HankFay]

Hi Barry,

thanks. Like I said, no problem. Without graceful error handling it's < 10 lines of code.

Hank