Just wanted to entertain a discussion on the pros and cons of using attachment fields vs Binary Large Objects (BLOBs).

I have a pretty simple code that imports and exports BLOBs with ease. I just call the appropriate file dialogs and go from there. Using this method, I can store the file name, filter files, limit file size, etc.

Can this be done with the attachment field? I am more so thinking of file size limits and filtering.

Granted there is less code using attachments, but is one method better than the other? How so?

What are your preferences and why?



Thanks,
Craig