<?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 — hide empty rows]]></title>
		<link>https://myvisualdatabase.com/forum/viewtopic.php?id=9241</link>
		<atom:link href="https://myvisualdatabase.com/forum/extern.php?action=feed&amp;tid=9241&amp;type=rss" rel="self" type="application/rss+xml" />
		<description><![CDATA[The most recent posts in hide empty rows.]]></description>
		<lastBuildDate>Mon, 28 Apr 2025 07:55:41 +0000</lastBuildDate>
		<generator>PunBB</generator>
		<item>
			<title><![CDATA[Re: hide empty rows]]></title>
			<link>https://myvisualdatabase.com/forum/viewtopic.php?pid=52389#p52389</link>
			<description><![CDATA[<p>The error occurs due to incorrect use of the property&nbsp; .Cell[1, i]. <br />If you want to analyze a string value, you should use&quot;<strong>.Cells[1, i] = &#039;&#039;</strong>&nbsp; or <strong>.Cell[1, i].AsString = &#039;&#039;</strong> . <br />See the component properties <a href="https://myvisualdatabase.com/help_en/script_tablegrid.html">https://myvisualdatabase.com/help_en/sc … egrid.html</a> .</p><br /><p>In your case, the situation is as follows:<br />You want to analyze a column for which the result is displayed as a currency (floating). <br />In your example, the SQL query returns one value 12000 and three NULL values. <br />Although you see empty cells, in fact, the table internally substitutes 0 (zero). Therefore, your analysis on an empty cell will not give a result.<br />There can be two ways out:<br />1. Use the property <strong>.Cell[1, i].Empty = True</strong> for analysis in your example.<br />2. Create a calculated field that will output 0 instead of ZERO and then parse <strong>.Cell[1, i].AsFloat = 0</strong> in your example.</p>]]></description>
			<author><![CDATA[null@example.com (sparrow)]]></author>
			<pubDate>Mon, 28 Apr 2025 07:55:41 +0000</pubDate>
			<guid>https://myvisualdatabase.com/forum/viewtopic.php?pid=52389#p52389</guid>
		</item>
		<item>
			<title><![CDATA[Re: hide empty rows]]></title>
			<link>https://myvisualdatabase.com/forum/viewtopic.php?pid=52380#p52380</link>
			<description><![CDATA[<p>expense tab in the frmMain has empty fields</p><p>i used a script but it shows an error</p>]]></description>
			<author><![CDATA[null@example.com (identity)]]></author>
			<pubDate>Sun, 27 Apr 2025 09:49:01 +0000</pubDate>
			<guid>https://myvisualdatabase.com/forum/viewtopic.php?pid=52380#p52380</guid>
		</item>
		<item>
			<title><![CDATA[Re: hide empty rows]]></title>
			<link>https://myvisualdatabase.com/forum/viewtopic.php?pid=52379#p52379</link>
			<description><![CDATA[<p>Hi<br />Can you attach an example of your project.<br />Derek.</p>]]></description>
			<author><![CDATA[null@example.com (derek)]]></author>
			<pubDate>Sun, 27 Apr 2025 08:18:22 +0000</pubDate>
			<guid>https://myvisualdatabase.com/forum/viewtopic.php?pid=52379#p52379</guid>
		</item>
		<item>
			<title><![CDATA[hide empty rows]]></title>
			<link>https://myvisualdatabase.com/forum/viewtopic.php?pid=52378#p52378</link>
			<description><![CDATA[<p>hi<br />is there anyway that an empty row in a tablegrid is not shown?</p>]]></description>
			<author><![CDATA[null@example.com (identity)]]></author>
			<pubDate>Sun, 27 Apr 2025 05:23:28 +0000</pubDate>
			<guid>https://myvisualdatabase.com/forum/viewtopic.php?pid=52378#p52378</guid>
		</item>
	</channel>
</rss>
