Originally posted by Vaibhav Deshpande: I want to know cachedRowset is reliable to use with complex quries.In case of cachedRowset update and insert happens in rowset set itself or in database.
Are you asking about update and inserts in a disconnected / cached set? If so, sorry but I've not tried using a CachedRowSet while disconnected to add or update records. I used it purely for select queries, for which it is totally reliable. Adam
I have seen things you people would not believe, attack ships on fire off the shoulder of Orion, c-beams sparkling in the dark near the Tennhauser Gate. All these moments will be lost in time, like tears in the rain.