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.
| Author |
Topic |
|
raami
Starting Member
1 Post |
 Posted - 2005-07-06 : 08:12:53
|
| i have done a validation in back end.. now i have to pass a value from backend to frontend(VB).. Is there any possibilites>???I have tried with OUTPUT parameters also.. but its not working. can any one guide me.. |
|
|
SamC
White Water Yakist
3467 Posts |
Posted - 2005-07-06 : 08:17:16
|
| The SQLTeam home page - use SEARCH to find articles on passing OUTPUT parameters. |
 |
|
|
vipinspg
Starting Member
12 Posts |
Posted - 2005-07-06 : 08:18:18
|
| OUTPUT parameters will work fine. If you are fetching any records also with the output param, close the data reader (or what ever in tehe front end) and get the output parameter value.. |
|
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2005-07-06 : 08:58:21
|
| >>I have tried with OUTPUT parameters also.. but its not working.Do you think we can really help you figure out what is "not working" based on that information? What does "not working" mean? You get syntax errors? Run-time errors? You get wrong data? You get Nulls?- Jeff |
|
|
|
ramana123
Yak Posting Veteran
57 Posts |
Posted - 2005-07-06 : 10:05:59
|
| Yes you can pass through the OUT Params in SQLserver or Oracle !!!you can recive that correct data type and types should be match and parameter name should be same in your codebhind and SP param name.Make sure this then it you can definitly pass values to the SP. |
|
|
|
|
|
|
How to pass a value ..