Code:
{"RecordCount":26,"Fields":[{"Name":"code","Type":"TEXT","PrimaryKey":false,"Nullable":false,"DefaultValue":"NULL"},{"Name":"value1","Type":"INTEGER","PrimaryKey":false,"Nullable":false,"DefaultValue":"NULL"},{"Name":"value2","Type":"INTEGER","PrimaryKey":false,"Nullable":false,"DefaultValue":"NULL"},{"Name":"value3","Type":"REAL","PrimaryKey":false,"Nullable":false,"DefaultValue":"NULL"}],"RowsCols":[["A",90,42,412038147449493],["B",29,79,796712756156921],["C",44,95,721228301525116],["D",48,20,432099103927612],["E",30,95,385743200778961],["F",42,98,226647019386292],["G",93,89,423794209957123],["H",57,14,821462154388428],["I",28,35,939591228961945],["J",19,11,22318971157074],["K",49,31,60527628660202],["L",43,5,291807413101196],["M",0,56,990513384342194],["N",79,82,341699719429016],["O",14,9,833484590053558],["P",82,42,324763298034668],["Q",20,77,597042381763458],["R",97,1,314293742179871],["S",38,69,903768241405487],["T",78,79,258403539657593],["U",7,91,693687498569489],["V",88,46,221721291542053],["W",64,71,198390424251556],["X",60,96,584122180938721],["Y",31,28,7.53095746040344E-02],["Z",6,70,915239691734314]]}
Now I want to convert the Json data into an ADO Recordset and load it into the FlexGrid. I wonder if there is any way to convert Json data directly to an ADO RecordSet or load Json data directly into FlexGrid?
