Database - Verify Database doesn't work 1

[RSX02]

Hi
I added a new field in my stored procedure. When I try to see this field in the fields explorer in Crystal Report I can't see it. But if I create a new report with this stored procedure I can see the field. I tried to go in the Database menu in crystal report and then do a Verify database. It tell me database is up to date and I go back in the fields explorer and don't see my new field.
Any idea?
Thanks in advance

 

[morriskc]

I have run into this in the past.

A work around to try is to make a copy of the stored proc, set location to the copy, save, then set location back to the old proc & save. You can then delete the copy of the proc that you no longer need. This usually works for me.

 

[synapsevampire]

Verify that the database has the new SP by creating a new report using the SP, it should show the new field, or you're probably not pointing at the right SP.

-k