Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 How to call a webservice

Author  Topic 

abhi201
Starting Member

2 Posts

Posted - 2010-01-13 : 23:44:18
Hi experts,

I am stuck in a scenario:

My client wants to check the validity of data entered in 2 UDF from another crm dynamically.i.e. when we enter data in two udf they want me to verify this data from the anthoer crm for which they have given me the url and the user id and pswd.now if the data is validated no error should be shown and a success message appears but if the data is not correct then a error should be shown and user should not be allowed to continue.

Please help me as i am reallly stuck in this scenario.Can i do this through a stored procedure or should i use crystal.

Many thanks in advance...Please helpppppppppp

Any help would be highly appreciated

Thanks
Abhishek


Thanks
Abhishek Kumar

Sachin.Nand

2937 Posts

Posted - 2010-01-14 : 01:12:01
I dont understand what you want?
If the data is not invalid then it should be validated in the web service itself.Probably in the SoapHeader of the webservice.

PBUH
Go to Top of Page
   

- Advertisement -