picture in dbf file

General Help regarding HMG, Compilation, Linking, Samples

Moderator: Rathinagiri

Post Reply
User avatar
fouednoomen
Posts: 188
Joined: Sun Oct 14, 2012 8:33 am
DBs Used: DBF, MySQL, MariaDB, SQLite, PostgreSQL, Oracle, ODBC
Location: Tunisia

picture in dbf file

Post by fouednoomen »

Hi all Friends

Can some one help me :
Can i store picture in DBF file ?????

Thanks in Advance

Foued
User avatar
Czarny_Pijar
Posts: 172
Joined: Thu Mar 18, 2010 11:31 pm
Location: 19.2341 E 50.2267 N

Re: picture in dbf file

Post by Czarny_Pijar »

AFAIK, no.

This fact shouldn't stop you. You can use a DBF file as a container for any kind of file.

Think of the internet packets (which can bear all kind of data, like the pictures, musics, movies) as a records in the database. Then your application should act like a browser, which can assemble these records together into the meaningful unit.
User avatar
danielmaximiliano
Posts: 2612
Joined: Fri Apr 09, 2010 4:53 pm
Location: Argentina
Contact:

Re: picture in dbf file

Post by danielmaximiliano »

fouednoomen wrote:Hi all Friends

Can some one help me :
Can i store picture in DBF file ?????

Thanks in Advance

Foued
Hello: the model would use in a table dbf memo field is used to hold the name of the image file, and its location in a particular folder on the disk.
the image folder structure will have to be designed and maintain odern if you need to retrieve an image without help of the application.
eg using Windows Explorer.

simple and effective without the aid of database engines.
if the need is to work with engines, the friend Jair Pinho Blob fields does work with a tempo and maybe if you read this post can give you a hand.

Hola : el modelo que utilizaria en una tabla dbf es utilizar el campo memo para contener el nombre del archivo de image, y su ubicacion en una determinada carpeta dentro del disco.
la estructura de la carpeta imagen tendra que ser pensada y mantener un odern por si es necesario recuperar una imagen sin ayuda de la aplicacion.
por ejemplo el uso del explorador de windows.

algo simple y efectivo sin la ayuda de motores de bases de datos.
si la necesidad es trabajar con motores , el amigo Jair Piñho trabajo con campos Blob hace un tempo y puede ser que si lee este post pueda darte una mano.
*´¨)
¸.·´¸.·*´¨) ¸.·*¨)
(¸.·´. (¸.·` *
.·`. Harbour/HMG : It's magic !
(¸.·``··*

Saludos / Regards
DaNiElMaXiMiLiAnO

Whatsapp. := +54901169026142
Telegram Name := DaNiElMaXiMiLiAnO
User avatar
tave2009
Posts: 61
Joined: Tue Jul 14, 2009 3:33 am
Location: San Francisco, Córdoba, Argentina.

Re: picture in dbf file

Post by tave2009 »

Hola Foued:

Espero que te sirva este ejemplo. :D

Saludos
Walter
Attachments
Image2Dbf.zip
(7.5 KiB) Downloaded 425 times
Nada se pierde. Todo se transforma. (Lavoussier)
Nothing is lost. Everything changes.
User avatar
esgici
Posts: 4543
Joined: Wed Jul 30, 2008 9:17 pm
DBs Used: DBF
Location: iskenderun / Turkiye
Contact:

Re: picture in dbf file

Post by esgici »

Hola Walter

Good implementation, thanks to share. :)

Saludos
Viva INTERNATIONAL HMG :D
User avatar
fouednoomen
Posts: 188
Joined: Sun Oct 14, 2012 8:33 am
DBs Used: DBF, MySQL, MariaDB, SQLite, PostgreSQL, Oracle, ODBC
Location: Tunisia

Re: picture in dbf file

Post by fouednoomen »

Hola Walter ,

Many thanks for this sample

it's exactly that I need


Regards

Foued
User avatar
mol
Posts: 3723
Joined: Thu Sep 11, 2008 5:31 am
Location: Myszków, Poland
Contact:

Re: picture in dbf file

Post by mol »

Very nice sample!
Thanks for sharing!
Regads, Marek
User avatar
esgici
Posts: 4543
Joined: Wed Jul 30, 2008 9:17 pm
DBs Used: DBF
Location: iskenderun / Turkiye
Contact:

Re: picture in dbf file

Post by esgici »

Good implementation :arrow:

Thanks Walter :)

Happy HMG'ing :D
Viva INTERNATIONAL HMG :D
User avatar
Czarny_Pijar
Posts: 172
Joined: Thu Mar 18, 2010 11:31 pm
Location: 19.2341 E 50.2267 N

Re: picture in dbf file

Post by Czarny_Pijar »

Once upon a time (PC-AT 16MHz, HDD 40MB), memo fields were a serious performance hit, also the garbage problems, so I'm used to avoid these 'goodies' at any cost.
Now, after a little checking of the example provided by tave2009, looks like these problems are the past.


tave2009 , thank you very much.

I would like to slightly expand the capabilities of tave2009 example, so the question:
Is this program capable to manipulate, without unacceptable slowdown (3 secs and more), lets say, 500 photos, total 1 GB? (on the average 4-5 years old machine). :?:
I assume, the solution of #0 and #26 problem, although not 'rock solid', is 'good enough'. :)
User avatar
esgici
Posts: 4543
Joined: Wed Jul 30, 2008 9:17 pm
DBs Used: DBF
Location: iskenderun / Turkiye
Contact:

Re: picture in dbf file

Post by esgici »

Hi

For a continuation of this topic please look at here.

esgici
Viva INTERNATIONAL HMG :D
Post Reply