<?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 — why get incompatible error]]></title>
		<link>https://myvisualdatabase.com/forum/viewtopic.php?id=8887</link>
		<atom:link href="https://myvisualdatabase.com/forum/extern.php?action=feed&amp;tid=8887&amp;type=rss" rel="self" type="application/rss+xml" />
		<description><![CDATA[The most recent posts in why get incompatible error.]]></description>
		<lastBuildDate>Sun, 17 Mar 2024 18:40:57 +0000</lastBuildDate>
		<generator>PunBB</generator>
		<item>
			<title><![CDATA[Re: why get incompatible error]]></title>
			<link>https://myvisualdatabase.com/forum/viewtopic.php?pid=50517#p50517</link>
			<description><![CDATA[<p>You mixed everything into one pile.<br />As far as I understand, this is the part about checking the IF... condition.<br />Let&#039;s break down what you wrote:<br /></p><div class="codebox"><pre><code>SQLExecute(&#039;select count(*) from cars where date=&#039;&#039;&#039; + cars.DateTimePicker1.sqlDate + &#039;&#039;&#039;&#039;) &lt;&gt; 0 And (+cars.ComboBox1.SelectedCount+ ) &gt; 0</code></pre></div><p>1.- this query is compared with 0. Ok. </p><div class="codebox"><pre><code>SQLExecute(&#039;select count(*) from cars where date=&#039;&#039;&#039; + cars.DateTimePicker1.sqlDate + &#039;&#039;&#039;&#039;) &lt;&gt; 0</code></pre></div><p> <br />2. Do you think this is the correct spelling of the ComboBox function?<br />- what is this? </p><div class="codebox"><pre><code>(+cars.ComboBox1.SelectedCount+ ) &gt; 0</code></pre></div><p>&nbsp; &nbsp;Maybe just </p><div class="codebox"><pre><code>cars.ComboBox1.SelectedCount &gt; 0</code></pre></div><p>3. An IF with several conditions should look like this:</p><div class="codebox"><pre><code> IF (x&gt;y) and (a &lt;&gt; b) THEN ....</code></pre></div><p>4.- are you sure that in your cars table in the date column the time consists of 0? </p><div class="codebox"><pre><code>where date=&#039;</code></pre></div>]]></description>
			<author><![CDATA[null@example.com (sparrow)]]></author>
			<pubDate>Sun, 17 Mar 2024 18:40:57 +0000</pubDate>
			<guid>https://myvisualdatabase.com/forum/viewtopic.php?pid=50517#p50517</guid>
		</item>
		<item>
			<title><![CDATA[why get incompatible error]]></title>
			<link>https://myvisualdatabase.com/forum/viewtopic.php?pid=50513#p50513</link>
			<description><![CDATA[<p>I have this SQL but i get incompatible </p><p>SQLExecute(&#039;select count(*) from cars where date=&#039;&#039;&#039; + cars.DateTimePicker1.sqlDate + &#039;&#039;&#039;&#039;) &lt;&gt; 0 And (+cars.ComboBox1.SelectedCount+ ) &gt; 0&nbsp; &nbsp;then</p><p>the error in the last condition , and as i see that selected count is integer !!! why this happen</p>]]></description>
			<author><![CDATA[null@example.com (lara.0080)]]></author>
			<pubDate>Sun, 17 Mar 2024 14:29:41 +0000</pubDate>
			<guid>https://myvisualdatabase.com/forum/viewtopic.php?pid=50513#p50513</guid>
		</item>
	</channel>
</rss>
