Loading graphic files in a SQLite database

[Stephan Hennekens]

Hi,
could anyone help me with a Xailer code snippet to load graphic files into a
SQLite database (if possible).
Regards,
Stephan

[Stephan Hennekens]

Ignacio,
is it possible though Xailer to load graphic files in an SQLite db?
Regards,
Stephan
"Stephan Hennekens" <stephan.hennekens@wur.nl> wrote in message
news:[email=4931d7ba@svctag-j7w3v3j....]4931d7ba@svctag-j7w3v3j....[/email]
> Hi,
>
> could anyone help me with a Xailer code snippet to load graphic files into
> a SQLite database (if possible).
>
> Regards,
> Stephan
>

[Stephan Hennekens]

Ignacio,
is it possible though Xailer to load graphic files in an SQLite db?
Regards,
Stephan
"Stephan Hennekens" <stephan.hennekens@wur.nl> wrote in message
news:[email=4931d7ba@svctag-j7w3v3j....]4931d7ba@svctag-j7w3v3j....[/email]
> Hi,
>
> could anyone help me with a Xailer code snippet to load graphic files into
> a SQLite database (if possible).
>
> Regards,
> Stephan
>

[jfgimenez]

Stephan,
sorry for the delay.
> could anyone help me with a Xailer code snippet to load graphic files into
> a SQLite database (if possible).
// Load a image from disk
oPicture := TPicture():LoadFromFile( "MyPicture.jpg" )
// Save it into the field 'image' of the dataset 'oMyTable'
oMyTable:image := oPicture:SaveToStream()
// Retrieve the same image into a TPicture objet
oPicture := TPicture():LoadFromStream( oMyTable:image )
If you are using a TImage control, you may use its property oPicture as the
needed TPicture object.
--
Regards,
Jose F. Gimenez
http://www.xailer.com
http://www.xailer.info

[jfgimenez]

Stephan,
sorry for the delay.
> could anyone help me with a Xailer code snippet to load graphic files into
> a SQLite database (if possible).
// Load a image from disk
oPicture := TPicture():LoadFromFile( "MyPicture.jpg" )
// Save it into the field 'image' of the dataset 'oMyTable'
oMyTable:image := oPicture:SaveToStream()
// Retrieve the same image into a TPicture objet
oPicture := TPicture():LoadFromStream( oMyTable:image )
If you are using a TImage control, you may use its property oPicture as the
needed TPicture object.
--
Regards,
Jose F. Gimenez
http://www.xailer.com
http://www.xailer.info

[Stephan Hennekens]

Thanks a lot Jose,
Regards,
Stephan
"Jose F. Gimenez" <jfgimenez@wanadoo.es> wrote in message
news:[email=4937a78a@svctag-j7w3v3j....]4937a78a@svctag-j7w3v3j....[/email]
> Stephan,
>
> sorry for the delay.
>
>> could anyone help me with a Xailer code snippet to load graphic files
>> into a SQLite database (if possible).
>
> // Load a image from disk
> oPicture := TPicture():LoadFromFile( "MyPicture.jpg" )
> // Save it into the field 'image' of the dataset 'oMyTable'
> oMyTable:image := oPicture:SaveToStream()
>
> // Retrieve the same image into a TPicture objet
> oPicture := TPicture():LoadFromStream( oMyTable:image )
>
> If you are using a TImage control, you may use its property oPicture as
> the needed TPicture object.
>
> --
> Regards,
>
> Jose F. Gimenez
> http://www.xailer.com
> http://www.xailer.info
>

[Stephan Hennekens]

Thanks a lot Jose,
Regards,
Stephan
"Jose F. Gimenez" <jfgimenez@wanadoo.es> wrote in message
news:[email=4937a78a@svctag-j7w3v3j....]4937a78a@svctag-j7w3v3j....[/email]
> Stephan,
>
> sorry for the delay.
>
>> could anyone help me with a Xailer code snippet to load graphic files
>> into a SQLite database (if possible).
>
> // Load a image from disk
> oPicture := TPicture():LoadFromFile( "MyPicture.jpg" )
> // Save it into the field 'image' of the dataset 'oMyTable'
> oMyTable:image := oPicture:SaveToStream()
>
> // Retrieve the same image into a TPicture objet
> oPicture := TPicture():LoadFromStream( oMyTable:image )
>
> If you are using a TImage control, you may use its property oPicture as
> the needed TPicture object.
>
> --
> Regards,
>
> Jose F. Gimenez
> http://www.xailer.com
> http://www.xailer.info
>