I used FillWithDASql with condition. If I use TDAMemDataTable.refresh, it will ignore the condition.
TDAMemDataTable.Refresh just closes and opens table and it doesn’t know that
RDA.FillWithDASql was used.
RDA.FillWithDASql instead of
If need to close & FillWithDASql, that means I need to create the procedure to refresh the TDAMemDataTable dataset. Is it possible to use “refresh” in future version?
review possibility to create usual SQL on server-side. in this case, Refresh will work as expected.
SQL script is dynamic SQL. If SQL on server-side, then it can’t using dynamic SQL.
give example of your script.
I think, some things can be solved via DynamicWhere and DynamicSelect features
you can drop email to support@ for keeping privacy