Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Update a Stored procedure 1

Status
Not open for further replies.

RSX02

Programmer
May 15, 2003
467
CA
I have a stored procedure that I modify to add a field in it. I already had a report build with this stored procedure. With this report I can not see the changes that I made (the new field) But when I build a new report with the same stored procedure I can see my field. Do I have to do something that I don't know to see my new field in the report that already exist?
Thank you
 
Thank you!!! It's working! Exactly what I wanted!
Thanks!
 
Hi RSX02,
I created my first stored procedure populating from and to temp tables. They exec properly in sql. But when I select the sp in Crystal, it gave me an error 'crw32.exe has generated errors and will be closed by Windows'.

But when I populate an actual table rather than temp table, it works. I'm not sure why I can't use temp tables? I did set nocount on.

Thanks
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top