Delphi EDataBaseError - Operation Not Supported. How can I solve it?
<p>I'm trying to query data from MySQL5 db, but when I use some other features from SQL code, I have the following error returned: [0x0005]: Operation Not Supported.</p>

<p>My SQL code query:</p>

<pre><code>Select 
  s.nome, s.id_sistema, s.st_sis 
from 
  perm_usuar as p 
inner join 
  sistemas as s 
on 
  s.id_sistema = p.id_sistema 
where 
  p.id_usuario = "' + idusuario + '"'
</code></pre>

<p>When I don't use those features, it works just as well:</p>

<pre><code>Select 
  sistemas.nome, sistemas.id_sistema, sistemas.st_sis 
from 
  perm_usuar 
inner join 
  sistemas 
on 
  sistemas.id_sistema = perm_usuar.id_sistema 
where 
  perm_usuar.id_usuario = "' + idusuario + '"'
</code></pre>

<p>Also, if I try to use WHERE of a joined table, I get the same error... I'm using DBExpress on Delphi XE8, with the following components: SQLConnection, SQLDataSet and SQLQuery.</p>

<p>When I use the code directly on MySQL, it works fine.</p>

<p>Why is it being returned and what's the solution?</p>