>>Others may disagree but I generally keep the path to a picture in a character field and point the picture property to the path when needed. General fields are more trouble than they are worth IMO. HTH
>
>I'm fully agree with you, storing the pictures in the table is a pain. The table will grow and grow, and search times will be going down. I always store only the path.
Pablo, I disagree with you. I use 2 separate tables to store binary data. First table (documents) is main and used for search. Second table is binary data only related with documents table by ID. And space such data storing takes is not more than space that stored files takes on disk - no difference.
You may store binary data in VFP using memo fields. There are some tricks with binary data storing on SQL server using VFP. Search threads here for more information, this was already discussed during last 2 weeks.
Vlad Grynchyshyn, Project Manager, MCP
vgryn@yahoo.comICQ #10709245
The professional level of programmer could be determined by level of stupidity of his/her bugs
It is not appropriate to say that question is "foolish". There could be only foolish answers. Everybody passed period of time when knows nothing about something.