About ADO

[zallen]

Hi,friends
Someone said it is better to use TADODataSet instead of TADOQuery,TADOTable and TADOStoredProc!But i donnot know how to use TADODataSet to call a stored procedure which will not return recordset!
If i use MyADODataSet.Activer := True then an error will raise saying the SP canot return record set.
Are there an ExecProc procedure similar to TADOStoredProc in TADODataSet?

Any suggestion are appreciated! [sig][/sig]

 

[cmwDelphiGuy]

As I understand the Ado components, you have to use an AdoQuery or AdoCommand to execute a query with no result set.

 

[gyu]

From what I understand, TADOCommand is most often used for executing DDL SQL commands or to execute a stored procedure that does not return a result set.
For those SQL statements that do return a result set, a TADODataSet, TADOQuery, or TADOStoredProc is better suited to the task.

 

[zallen]

Thanks for all your response!


Regards!