Crystal Report 8.5 / VB6 - New command field is missing

Francois_Tremblay
Francois_Tremblay used Ask the Experts™
on
Hi!

I have a VB6 project using Crystal Report 8.5.  There is a report inside my VB project that is using a Data Environment Command.

I went to the command, modified the SQL query so that it would add a few fields.  When I open my Crystal Report (dsr file), when I toggle the field view and I can see

Database Fields -> DataEnv_Command11 -> My command fields

However, the new fields are missing.  If I add a new database to my project and reselect this command, I can see the new fields.

The problem is all the fields are linked to this object, so if I rename the object, the fields follow.  If I delete the object, all the fields in my report are also deleted.

Is there any way to refresh the existing connection so that it sees the new fields?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Senior Consultant
Most Valuable Expert 2011
Top Expert 2013
Commented:
Try using the VERIFY DATABASE under the DATABASE menu.

Crystal should then update the database to reflect the new fields.

mlmcc

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial