DASQL refresh issue

Hi,
I used FillWithDASql with condition. If I use TDAMemDataTable.refresh, it will ignore the condition.

Hi,

as expected.
TDAMemDataTable.Refresh just closes and opens table and it doesn’t know that RDA.FillWithDASql was used.

workaround: use table.Close & RDA.FillWithDASql instead of table.Refresh

Hi,
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?

Hi,

review possibility to create usual SQL on server-side. in this case, Refresh will work as expected.

Hi,
SQL script is dynamic SQL. If SQL on server-side, then it can’t using dynamic SQL.

Hi,

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

Email sent.