The 'P' field type cannot be used for anything because it is not implemented. You choices is to store pictures in the memo/binary or keep them on disk and store only file name in the table. The second one is preferable because it allows to avoid memo bloat and corruption.
>I need to store an image for each person in a table of users. I was going to use a binary memo field (fieldname m nocptran) but noticed that Fox had a data type of P that I've never used.
>
>In experimenting with this, I created a cursor with one field of p data type. However, I can't figure out what it wants. I've tried the following:
>
>create cursor temp (pix p)
>
>append blank
>replace pix with filetostr("c:\temp\image1.jpg")
>replace pix with getpict()
>
>... and even
>
>oImage = createobject("Image")
>oImage.Picture = getpict()
>repl pix with oImage
>
>
>Each time I get an data type mismatch. The Fox 8.0 help seems to be pretty quiet on the subject of the picture memo type.
>
>Can someone help me understand what it is used for and how to use it? Also, is there an advantage/disadvantage to storing an image in a binary memo as opposed to a picture memo?
>
>Thanks for your help!
--sb--