Mwp.Reid at Queens-Belfast.AC.UK
Mwp.Reid at Queens-Belfast.AC.UK
Tue Mar 11 13:56:00 CST 2003
LOL You know what I meant. Martin Quoting Charlotte Foust <cfoust at infostatsystems.com>: > >>Allow you to sue prepared statements > > Lawyers are everywhere these day!! ROTFL > > Charlotte Foust > > -----Original Message----- > From: Mwp.Reid at Queens-Belfast.AC.UK > [mailto:Mwp.Reid at Queens-Belfast.AC.UK] > Sent: Tuesday, March 11, 2003 11:09 AM > To: accessd at databaseadvisors.com > Subject: Re: [AccessD] ADO Command object > > > Command objects allow you to work with Stored Procedures containing > output > parameters. > > Allow you to sue prepared statements > > YOu can call a command multiple times > > Command Objects can be reused within an application > > IS this what your after? > > > martin > > Quoting Susan Harkins <harkins at iglou.com>: > > > Hmmm... my understanding was that you needed the Command object to > use > > > CommandType, so how would using a Connection object to connect be an > > > advantage with parameters? > > > > Susan H. > > > > > > > One major one is that the Command object has the parameters > > collection > > that > > > is vital to either passing parameters to a Stored Procedure or a > > > paramterized Query. > > > > > > Chris Mackin > > > www.denverdb.com > > > Denver Database Consulting, LLC > > > > > > > > > -----Original Message----- > > > From: accessd-admin at databaseadvisors.com > > > [mailto:accessd-admin at databaseadvisors.com]On Behalf Of Susan > > Harkins > > > Sent: Tuesday, March 11, 2003 10:56 AM > > > To: AccessD at databaseadvisors.com > > > Subject: [AccessD] ADO Command object > > > > > > > > > I see a lot of code that uses the Command object but connects via a > > > > Connection object, when a Command object can do the same thing. I > > assume > > > this arrangement nets advantages -- can someone name a few? > > > > > > Susan H. > > > > > > > > > > > > > > > _______________________________________________ > > > AccessD mailing list > > > AccessD at databaseadvisors.com > > > http://databaseadvisors.com/mailman/listinfo/accessd > > > Website: http://www.databaseadvisors.com > > > > > > > > > > > > _______________________________________________ > > > AccessD mailing list > > > AccessD at databaseadvisors.com > > > http://databaseadvisors.com/mailman/listinfo/accessd > > > Website: http://www.databaseadvisors.com > > > > > > > > > > _______________________________________________ > > AccessD mailing list > > AccessD at databaseadvisors.com > > http://databaseadvisors.com/mailman/listinfo/accessd > > Website: http://www.databaseadvisors.com > > > _______________________________________________ > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > _______________________________________________ > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com >