MSSQL Forward Only Navigation

After having to adopt an app I have to work on MSSQL It is with much chagrin I find that there is only forward only navigation. What is the status on getting a more feature rich plugin for xojo? I would hope that it would support OLEDB drivers or the sql native client.

@Christian Schmidt might be able to help

I use the MBS SQL plugin for all my database work including MSSQL, but if you don’t want to use MBS, and if the RowSet is small, load the RowSet into an in-memory SQLiteDatabase and access it in any direction you want.

For MBS SQL Plugin, please set Scrollable property to true to get a scrollable cursor.

If not supported, you can use our cache feature, where the plugin does the local record set caching.