Attach A Photo

Hi

Is there a way that I can store a photo in a SQLite database?

What I want to do is to take a photo of any object while I am busy with a tachy survey. If I log the coordinates (Y,X & Z) of say a manhole cover and I take a photo of the manhole cover, then it would be nice to save this photo together with the coordinates in the database. If I ID this point on my screen, then the option must be there to show the photo as well.:sign0085:

Thanks
Michael

Probably if you are feeling masochistic but I think you are better off storing the filename of the photo and keeping the photo separately otherwise you will end up with a huge and unwieldy database file as SQLlite doesn't store binary data very efficiently.

You can use Command.FileToBlob to save the image. See the example in the manual: SQL

Thanks Erel:sign0188:

Regards
Michael