V11.0.003 Picture Problem 3

[pauldb]

The field in the DBF has the path + filename to a JPG file which is located on the server share in a folder called Pictures. This is a mapped M: drive on the local workstation.____The DBF is located at:__M:Files\__So in the file the value is e.g.__M:PicturesWolf.JPG____When this field is used as a "Picture from File" field, no picture is printed.____When using a local folder, it works. ____Somehow R&R doesn^t seem to handle the M: path correctly__

[kfleming]

I will see if I can reproduce this problem and will submit it to development for review.____Kathleen__R&R Support

[pauldb]

Kathleen,____I think I have narrowed this problem. The path is not the culprit. ____The problem seems to be that the field in which the path is stored, is a memo field, not a character field. __When I use a DBF with a character field, it works, R&R prints the pics. However this is not an option. The paths are often very long and character fields are limited to 254 chars. That^s why we use a memofield. ____R&R should be able to handle a memofield for the "Picture from field" function. When I insert a picture the R&R Designer shows me a list of fields to choose from: only character and memofields, no logic, date or numeric fields. So obviously the Designer was made for it, but it doesn^t work. ____My first idea was to pass the value of the memofield into a calculated CHARACTER field and use that for the "picture to field". __But I seem to be unable to do this, I always end up with a (calculated) memofield again. And performing a function on a memofield such as Alltrim(MField) is equally impossible!!!____So how do I do go on? ____Paul ______________

[pauldb]

Liveware "support" please react!__Question is one week old now. ____How do I use a memofield as a "picture from field" ?

[kfleming]

You cannot use a memo field for a picture from field UNLESS you want to set up an ODBC data source and use the SQL report designer in place of the Xbase designer.____Kathleen__R&R Support

[pauldb]

ODBC Not possible in this case. __I will try to work something out.____Remark 1: if a memo field cannot be used, then memos should not be presented to the user in the fields election box when creating a "picture from field". ____Remark 2: it would be nice to make the use of memeo fields possible, because these days file (picture) paths can be very long and surpass the 256 character limit of traditional XBase char fields____Paul______