Dynamic Where in Schema

Data Abstract
1

Hello,

I’m trying to set an XML expression for dynamic where in the editor schema. If I write the XML expression on a single line, without additional spaces it works correctly.
Like this:

<query version="5.0" xmlns="http://www.remobjects.com/schemas/dataabstract/queries/5.0"><where><binaryoperation operator="Equal"><field>IDSOCIETATE</field><parameter type="Integer" null="-1">IDSOCIETATE</parameter></binaryoperation></where></query>

If I try to format it for easier reading, there are errors in interpreting the expression.
Like this:

<query version="5.0" xmlns="http://www.remobjects.com/schemas/dataabstract/queries/5.0">
  <where>
    <binaryoperation operator="Equal">
      <field>IDSOCIETATE</field>
	  <parameter type="Integer" null="-1">IDSOCIETATE</parameter>
    </binaryoperation>
  </where>
</query>

I am using DataAbstract for Delphi version 10.0.0.1469

4

Logged as bugs://D19104.

5

bugs://D19104 was closed as fixed.

6

Hi,

pls update uDAWhere.pas as

class procedure TDAWhereBuilder.RemoveEmptyNodes(const ANode: IXMLNode);
..
    if (lNode.Name = '#text') and (lNode.LocalName = '') and (Trim(VarToStr(lNode.Value)) = '')  then //changed

for recompiling DAD packages you can launch C:\Program Files (x86)\RemObjects Software\Build\install_DA.cmd with admin rights.