Mark Breen
marklbreen at gmail.com
Fri Nov 27 04:00:01 CST 2009
Hello John, that Shamil has said is that you can use one param to pass in a value, and use the same param to accept back a value, which may be different to when it was passes in. You can pass in ProductId, and get back, ProductCode, or pass in username and get back fullname, or pass in product code and get back zero if the product code does not exist, else you get back the code you passed in or pass in productid and get back qty in stock, all with one param. My examples are not great, but there are plenty of times where you need to somehow inspect a value and it may not be ideal to have two params named paramOriginal paramNewValue with inputout you can have just one param named paramToBeVerified Thanks again to Shamil, Stuart and Mr Colby for asking the question. Mark 2009/11/26 jwcolby <jwcolby at colbyconsulting.com> > > System.Data.ParameterDirection.InputOutput > > Thanks Shamil, > > What do you do with this? Set it to true? Set something else equal to > this (is this a constant)? > > John W. Colby > www.ColbyConsulting.com > > > Shamil Salakhetdinov wrote: > > Hi Mark, > > > >> assume that you cannot have bi-directional. > > You can: > > > > System.Data.ParameterDirection.InputOutput > > > > -- > > Shamil > > > > On 26 Nov 2009 at 9:04, Mark Breen wrote: > >> afaik, a param can be input (the default direction) or output. I have > > not > >> heard of an inputoutput param so unless anyone here says different, > assume > >> that you cannot have bi-directional. > >> > > > > > > > > > > > > __________ Information from ESET NOD32 Antivirus, version of virus > signature > > database 4638 (20091126) __________ > > > > The message was checked by ESET NOD32 Antivirus. > > > > http://www.esetnod32.ru > > > > > > _______________________________________________ > > dba-VB mailing list > > dba-VB at databaseadvisors.com > > http://databaseadvisors.com/mailman/listinfo/dba-vb > > http://www.databaseadvisors.com > > > > > _______________________________________________ > dba-VB mailing list > dba-VB at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/dba-vb > http://www.databaseadvisors.com > >