Length of Database field in Crystal Report

[manush]

Hi,

My package has a query as below.

Select 'NFE A' "nfe" from dual

This pkg is called from crystal report and in field explorer the field comes as below.

NFE: String[5]

And the value comes in the report as ..... NFE A

Now I change my query and recompile the package

Select 'Primary' "nfe" from dual

I then reopen the SAME crystal report. The problem comes at this point. I don't get any data at this time. I check the field explore where it is still coming

NFE: String[5]

But the length has been changed from 5 to 7.

Please help

Manoj

 

[IdoMillet]

Use the menu item:
Database, Verify Database
in Crystal.

Cheers,
- Ido

CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[manush]

Hi Ido,

Thanks a lot. It solved.

cheers,
Manoj