I'm using ADO 2.7 to manage a disconnected database in a VB6 app. I want a really fast method of cutting and pasting records.
The ADO Filter property is good for the cut/copy and delete stages but the real bottleneck is in pasting.
The GetRows method provides a fast way of getting records into a 2D variant array which can then be manipulated. But there is no SetRows method to take the "pasted" 2D array so I'm forced, one way or another, to iterate through the edited array to update the recordset field by field - slow !
One tempting alternative is to use streams. No problem saving a recordset to a stream using str.Save, but I can't find a way of writing several blocks of records to the same stream.
Each stream Save adds an ADO header, so that I can only read back from the stream the first recordset I saved.
I'd be quite happy to tackle the problem using direct memory transfers with objPtr/varPtr etc. but can't find any information on how to do this.
Grateful for any help you can give on what must be an increasingly common problem for "disconnected " ADO users.
Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.
This Article will show you how to validate number with TEdit control,
What's the TEdit control?
TEdit is a standard Windows edit control on a form, it allows to user to write, read and copy/paste single line of text.
Raise your hands if you were as upset with FireMonkey as I was when I discovered that there was no TListview. I use TListView in almost all of my applications I've written, and I was not going to compromise by resorting to TStringGrid…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code.