Devart Forums

Was the NexusDB provider removed? It is not in the source and D7 package.

Thank you for your fast answer.
SDAC is no option as the database in question is Oracle. The CursorType ctStatic was more an example from my previous work with ADO. Is it possible to get a not changing resultset in Unidac?
Is the disconnected mode not something similar?

I sometimes need a static resultset, which means: the server table is queried and subsequent sql operations don't affect that resultset.
In ADO I used Cursortype ctStatic but in Unidac I can't find something like that.
I have to process very large table sizes and if there is a way to do that without copying to a local VirtualTable it would be helpfull. The resultset is ReadOnly and UniDirectional.

Hello AndreyZ,
I think this is the right way to prioritize the user requests.

But I have to ask another question: I've seen that slow queries with parameters on my previous version which was ADO-based and changed many queries to simple sql-text without parameters (therefore this feature request has not the highest priority for me). If that is a ADO/OLEDB-problem, possibly it's better to make a SpecificOption for MSSQLprovider, which you can faster implement and test?
What is your experience (as devart) in your other products (.Net, DBExpress): Are there parameters on SQLServer-queries also bad?
If not: Can there go something wrong in the implementation of the parameters for the MSSQLProvider?

Can you review http://devart.uservoice.com/forums/1046 ... ?ref=title , if this is what you want and add a vote?
As seen in other feature request's: more votes -> higher priority for implementing!

You can vote for my UserVoice-Entry. Possibly they add it.

A TUniQuery has ApplyUpdates and CancelUpdates.
A TUniConnection has ApplyUpdates and documentation says, it's then "preferred method of updating datasets rather than calling each individual dataset's ApplyUpdates method".
Why is there no equivalent CancelUpdates for TUniConnection?

I'd like to populate a memory-table with data from a complicated query. After that I need the user-changes from this memory-table written to the DB-Server. My first try was a TVirtualTable (perfect for populating) connected to a TUniUpdateSql (perfect for Updating). But that is not possible.
Is there a other way to mirror changes in a TVirtualTable to Sql-Statements?
Can I populate a TUniQuery manually and only use CachedUpdates for userchanges after that point?

Andreas