----------------------------------------------------------- New Message on BDOTNET
----------------------------------------------------------- From: shri Message 3 in Discussion Hi, Thanks a lot....I had not used this before. Anyways I found a way out in a single line: Select name from systypes where xusertype=(select xusertype from syscolumns where name like 'Order_Qty') This will return me the datatype. But now I realized that this requirement was for a variable that is passed as object in .NET and depending upon its data, I need to find the datatype in the SP. But this will be difficult, as the data of the variable will be stored as string and for example if the variable has a value '1' then it can be treated as string, number or even a boolean(TRUE). I think I need to resolve this in .NET itself. If you have done anything of this sort to find a datatype of the variable depending upon its data, please let me know. Thanks once again, shri ----------------------------------------------------------- To stop getting this e-mail, or change how often it arrives, go to your E-mail Settings. http://groups.msn.com/bdotnet/_emailsettings.msnw Need help? If you've forgotten your password, please go to Passport Member Services. http://groups.msn.com/_passportredir.msnw?ppmprop=help For other questions or feedback, go to our Contact Us page. http://groups.msn.com/contact If you do not want to receive future e-mail from this MSN group, or if you received this message by mistake, please click the "Remove" link below. On the pre-addressed e-mail message that opens, simply click "Send". Your e-mail address will be deleted from this group's mailing list. mailto:[EMAIL PROTECTED]
