Crystal drilldown length

[JasonKaufman]

I am trying to link to pics that are buried within multiple folders.
I know that I get an error because it is too long a string.

So I am needing to find out the max length of the searched string

For example it could be
Q:/CustomerA/Spring 2011/Product xyz/front pics/pic.jpg

The error message is:
Database Connector Error: 'HY000:[DataDirect][ODBC Progress OpenEdge Wire Protocol driver][OPENEDGE]Column image-file-1 in table PUB.product has value exceeding its max length or precision.
[Database Vendor Code: -210012]'

Thanks

 

[lbass]

Why not move/copy them to a folder that isn't nested and identify their origin in some other way? e.g., a short folder name that is unique to this set.

-LB

 

[JasonKaufman]

Why not move/copy them to a folder that isn't nested and identify their origin in some other way? e.g., a short folder name that is unique to this set.

-LB

I have stated that we need to do this to the users.
But we have a large product line and thus a large amount of pictures that are scattered amongst customers, seasons, styles etc.

If I knew the max drilldown length, then I could convey that to the users and they can work on making sure that the max is not reached and then the Crystal report I write would function as desired.