reopen xBrowse alias resulted in error - PARTIALLY SOLVED

[fraxzi]

Dear All,

This could be a silly question but I think it's worth the try.

I have an SQL query which alias uses by xBrowse. This query resulted to static (views) and I need to refresh it.
I know and i'm aware that static cursors/views are read-only and cannot be update-able and the only solution is to close and re-open it again.

So I looking at re-executing the SQL script if I wish to refresh records.

But active xBrowse with this SQL alias does not allow it to be closed.

Is there a way xBrowse can be paused while I close and reopen again SQL alias?

[fraxzi]

Dear All,

a less complicated solution is to open the SQL alias with different alias used by xBrowse and assign it.

Any more better ideas are welcome.

[nageswaragunupudi]

a less complicated solution is to open the SQL alias with different alias used by xBrowse and assign it.

This is right solution

[Rick Lipkin]

Francis

If you use objects for your recordset .. you can oRs:CLose() and then oRs:Open() with a new query and then oLbx:ReFresh() .. just do not reassign oRs .. leave its properties intact.

Rick Lipkin

[nageswaragunupudi]

Francis

If you use objects for your recordset .. you can oRs:CLose() and then oRs:Open() with a new query and then oLbx:ReFresh() .. just do not reassign oRs .. leave its properties intact.

Rick Lipkin

Mr Rick

That is because the way of your coding. You use oRs directly in all codeblocks.
But we designed xbrowse to safely reassign oRs

In fact in most of the cases, after creating the xbrowse, there is no need to use the oRs variable in our program code.

[fraxzi]

RAO,
Rick,

Thanks for the feedback.

I'm in the middle of earth between shortest code and efficiency.. so far both your recommendations are worth considering.