How would I add the statement where left(Field1,3)='abc' in a TDAWhereBuilder?

Data Abstract
1

How would I add the statement

  1. where left(Field1,3)=‘abc’
  2. where convert(varchar,Field2,23) = ‘2017-02-06’

in a TDAWhereBuilder?

2

you can use something like

with table, table.DynamicWhere do
  Expression := NewBinaryExpression(
                  NewMacro('left', [NewField('','Field1'), NewConstant(3)]),
                  NewConstant('abc'),
                  dboEqual);

and

with table, table.DynamicWhere do
  Expression := NewBinaryExpression(
                  NewMacro('convert', [NewMacro('varchar'), 
                                       NewField('','Field2'), 
                                       NewConstant(23)]),
                  NewConstant('2017-02-06'),
                  dboEqual);

Note: left, convert and varchar are unknown macro for DA and they should be handled in OnUnknownMacroVariable event of DAService.

3

thank you !!!

Best Regards!