<?xml version="1.0" encoding="utf-8"?>
<rss version="2.0" xmlns:atom="http://www.w3.org/2005/Atom">
	<channel>
		<title><![CDATA[My Visual Database — How to Sort Order by Name value in JSonArray and add to Memo1]]></title>
		<link>https://myvisualdatabase.com/forum/viewtopic.php?id=8983</link>
		<atom:link href="https://myvisualdatabase.com/forum/extern.php?action=feed&amp;tid=8983&amp;type=rss" rel="self" type="application/rss+xml" />
		<description><![CDATA[The most recent posts in How to Sort Order by Name value in JSonArray and add to Memo1.]]></description>
		<lastBuildDate>Mon, 01 Jul 2024 15:56:38 +0000</lastBuildDate>
		<generator>PunBB</generator>
		<item>
			<title><![CDATA[Re: How to Sort Order by Name value in JSonArray and add to Memo1]]></title>
			<link>https://myvisualdatabase.com/forum/viewtopic.php?pid=51182#p51182</link>
			<description><![CDATA[<p>Hi,</p><p>Your code is not working.</p><br /><p>Something like this.</p><br /><div class="codebox"><pre><code>procedure Form1_Button1_OnClick (Sender: TObject; var Cancel: boolean);
var
  JArray : TJsonArray  ;
  i         : Integer     ;
  TStrL     : TStringList;
  js_name   : string ;
  js_color  : string ;
  str       : string = &#039;[{&quot;Name&quot;: &quot;Cat&quot;,&quot;Color&quot;: &quot;White&quot;},{&quot;Name&quot;: &quot;Ant&quot;,&quot;Color&quot;: &quot;Red&quot;},{&quot;Name&quot;: &quot;Zebar&quot;,&quot;Color&quot;: &quot;Black&quot;}]&#039;;
begin
  TStrL := TStringList.Create;
  TStrL.Sorted := true;
  JArray := TJSONarray(TJsonObject.ParseJSONValue(str));
  for i := 0 to JArray.Size -1 do
  begin
    js_name := TjsonObject(JArray.Get(i)).GetPairByName(&#039;Name&#039;).JsonValue.ToString;
    js_color := TjsonObject(JArray.Get(i)).GetPairByName(&#039;Color&#039;).JsonValue.ToString;
    TStrL.add(js_name+&#039;,&#039;+js_color);
  end;
  frm_main.Memo1.Lines.Text := TStrL.text;
  TStrL.Free;
end;</code></pre></div>]]></description>
			<author><![CDATA[null@example.com (sparrow)]]></author>
			<pubDate>Mon, 01 Jul 2024 15:56:38 +0000</pubDate>
			<guid>https://myvisualdatabase.com/forum/viewtopic.php?pid=51182#p51182</guid>
		</item>
		<item>
			<title><![CDATA[How to Sort Order by Name value in JSonArray and add to Memo1]]></title>
			<link>https://myvisualdatabase.com/forum/viewtopic.php?pid=51181#p51181</link>
			<description><![CDATA[<p>How to Sort Order by Name value in JSonArray and add to Memo1</p><br /><p>Example<br /></p><div class="codebox"><pre><code>[
    {
        &quot;Name&quot;: &quot;Cat&quot;,
        &quot;Color&quot;: &quot;White&quot;
    },
    {
        &quot;Name&quot;: &quot;Ant&quot;,
        &quot;Color&quot;: &quot;Red&quot;
    },
    {
        &quot;Name&quot;: &quot;Zebar&quot;,
        &quot;Color&quot;: &quot;Black&quot;
    }
]</code></pre></div><p>I will To result<br /></p><div class="codebox"><pre><code>Ant,Red
Cat,White
Zebar,Black</code></pre></div><br /><br /><br /><br /><br /><br /><p>------------------------------------------------------------</p><p>Try Easy Code But&nbsp; Result&nbsp; Not Order By Name<br /></p><div class="codebox"><pre><code>Cat,White
Ant,Red
Zebar,Black</code></pre></div><p>How To Edit Code ???</p><div class="codebox"><pre><code>procedure MyProcedure();
var
JsonArray : TJsonArray  ;
i         : Integer     ;
JS_temp   : TJsonObject ;
js_name   : TJsonString ;
js_color  : TJsonString ;
begin
    JsonArray := TJsonArray.ParseJSONValue(
    &#039;[
    {
        &quot;Name&quot;: &quot;Cat&quot;,
        &quot;Color&quot;: &quot;White&quot;
    },
    {
        &quot;Name&quot;: &quot;Ant&quot;,
        &quot;Color&quot;: &quot;Red&quot;
    },
    {
        &quot;Name&quot;: &quot;Zebar&quot;,
        &quot;Color&quot;: &quot;Black&quot;
    }
    ]&#039;
    );
    for i := 0 to JsonArray.Size -1 do
    begin
        js_temp := TJSONObject (TJSONObject(JsonArray.Get(i))) ;
        js_name := TJSONString(JS_temp.GetPairByName(&#039;balance&#039;).JsonValue);
        js_color := TJSONString(JS_temp.GetPairByName(&#039;color&#039;).JsonValue);
        Form1.Memo1.Lines.add(js_name.Value+&#039;,&#039;+js_color.Value)
    end;
end;</code></pre></div>]]></description>
			<author><![CDATA[null@example.com (prahousefamily)]]></author>
			<pubDate>Mon, 01 Jul 2024 07:12:08 +0000</pubDate>
			<guid>https://myvisualdatabase.com/forum/viewtopic.php?pid=51181#p51181</guid>
		</item>
	</channel>
</rss>
