Results 1 to 3 of 3

Thread: Appending/Inserting Records from JSON

  1. #1
    Lianja MVP
    Join Date
    Feb 2012
    Location
    Berea, KY, USA
    Posts
    1,941

    Appending/Inserting Records from JSON

    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

  2. #2
    Lianja Development Team barrymavin's Avatar
    Join Date
    Feb 2012
    Location
    UK, USA, Thailand
    Posts
    5,769
    Hi Hank,

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

    Theres nothing that will insert from a JSON file.
    Principal developer of Lianja, Recital and other products

    Follow me on:

    Twitter: http://twitter.com/lianjaInc
    Facebook: http://www.facebook.com/LianjaInc
    LinkedIn: http://www.linkedin.com/in/barrymavin

  3. #3
    Lianja MVP
    Join Date
    Feb 2012
    Location
    Berea, KY, USA
    Posts
    1,941
    Hi Barry,

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

    Hank

Bookmarks

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Journey into the Cloud
Join us