Results 1 to 5 of 5

Thread: Data from desktop app to JSON

  1. #1
    Member Bob Whitaker's Avatar
    Real Name
    Bob Whitaker
    Join Date
    Jun 2000
    Location
    Sutton-Coldfield, UK
    Posts
    690

    Default Data from desktop app to JSON

    We have been asked to extract data from our standard DBF based application and submit it as JSON.
    Anybody able to point me in the right directions.
    Thanks in anticipation.
    Bob
    Bob Whitaker


  2. #2
    Member mixter's Avatar
    Real Name
    Michael Merlin
    Join Date
    Sep 2011
    Location
    Melbourne, Australia
    Posts
    220

    Default Re: Data from desktop app to JSON

    Maybe take a look at this function in the documentation

    a5_mergedataintotemplate

    Description: Merge data into a template. Data source can be:

    - An Xbasic property array,
    - A pointer to an open .dbf table
    - A SQL result set.


    See it in action here
    Watch Video – Part 2
    (video 2 of 3)
    at the bottom of this page

    http://alphasoftware.net/alpha-anywh...hart-controls/
    Last edited by mixter; 04-30-2014 at 10:17 AM. Reason: link to video added

  3. #3
    Member mixter's Avatar
    Real Name
    Michael Merlin
    Join Date
    Sep 2011
    Location
    Melbourne, Australia
    Posts
    220

    Default Re: Data from desktop app to JSON

    Also search the help file for JSON

    This looks interesting
    rsToJSON()

    http://wiki.alphasoftware.com/SQL+Re...yntax+Function

  4. #4
    Member Bob Whitaker's Avatar
    Real Name
    Bob Whitaker
    Join Date
    Jun 2000
    Location
    Sutton-Coldfield, UK
    Posts
    690

    Default Re: Data from desktop app to JSON

    Thanks for your help Michael I shall spend the weekend trying to work out how I use this with dbf files as the data source rather than SQL
    Bob
    Bob Whitaker


  5. #5
    Member
    Real Name
    OMAR SHIMABUKURO
    Join Date
    Apr 2011
    Posts
    29

    Default Re: Data from desktop app to JSON

    Thanks

Similar Threads

  1. How to make grids work with JSON data‏
    By cor_dav in forum Mobile & Browser Applications
    Replies: 3
    Last Post: 11-08-2013, 03:25 PM
  2. How to make grids work with JSON data‏
    By cor_dav in forum Application Server Version 11 - Web/Browser Applications
    Replies: 1
    Last Post: 11-08-2013, 12:07 PM
  3. gathering data in the field for entry into desktop app
    By Mike Wilson in forum General Questions
    Replies: 13
    Last Post: 06-15-2012, 03:23 PM
  4. Json data and http_fetch(). Interesting behaviour with character datatype
    By kkfin in forum Application Server Version 10 - Web/Browser Applications
    Replies: 2
    Last Post: 06-01-2012, 04:03 PM
  5. Getting data entered on VPS into Desktop App
    By Charlain in forum Application Server Version 8
    Replies: 2
    Last Post: 05-22-2008, 08:13 PM

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
  •