Devart Forums

hi,
I am using MIDAS with SDAC TMSQuery for DB access. At design time, I create "base" sql query (TMSQuery.SQL). Then, I modify it (adding constraints using additional "where" SQL) every time SQL is requested (onBeforeGetRecords event).
Base SQL also have parameters in "where" section, which types are set in designtime.
Is there any way to set TMSQuery.SQL unouched with all types declaration (initial section) and adding additional conditons (e.g. "and Qty > 0")?

Frenk

You can call TCustomDADataSet.AddWhere to add condition to WHERE clause of SELECT statement in SQL property.