Vote UpVote

Returning multiple datasets with ADO and Delphi

The Road to Delphi – Maybe when you’ve used the SQL Server Management studio ‘ve noticed that you can run multiple queries at once. ADO supports this feature, and you can include it in your applications. the key is to use the function NextRecordset and then assign it to any TCustomADODataSet descendent. see this simple example. program MultiDataSetsADO; {$APPTYPE CONSOLE} uses ActiveX, ADODB, SysUtils; const //the connection string StrConnection='Provider=SQLOLEDB.1;Password=%s;Persist Security Info=True;User ID=%s;Initial Catalog=%s;Application Name=MyApp;' + 'Data ...
Favorite? Off-Topic? Rodrigo @ 2010-06-17 10:11


Visits: 561
Votes: 2
Favorites: 0
Off-Topic: 0

Visits by Source

User Actions

Users who voted for this posting

Charles Ardour
Primoz Gabrijelcic
Contact us to advertise on DelphiFeeds.com

Community Links

Torry Firebird News


Please login or register to use this functionality.
(click on this box to dismiss)