Dardo: Thanks for the data base you sent me. It allowed me to do a good test of large binary data, and the scenery in the images is beautiful. I assume they are images from the Canary Islands. Also thanks for the VB sample program. Why does anyone use Visual Basic? Python is so much simpler, as you will see from the examples I am attaching.
I am attaching three Python programs, each is a simple example of inserting, updating, or selecting a .jpg image. The database, image file names, and the record to update are hard coded in two of them, you can figure out how you want to specify them. The showpix.py program accepts a single command line argument, the record number (Codigo) of the image you want to see. It uses your computer's default image viewer to display the image. I've tested them on several versions of Python, 2.6 to 3.1, and they work as intended. BUT -- you MUST get a copy of the latest adodbapi from http://sourceforge.net/projects/adodbapi/ . There is a bug reading large binary fields in the older versions. -- Vernon On Feb 3, 2011 4:24 AM, "Dardo Schuster Glez" <dardoschus...@hotmail.com> > wrote: > > > > > > > > > > Dear Sir > > > > How can y show a jpg that is in a SQL Server image field in a Qlabel > object ??? and how to change and save it in the image field ??? > > > > Thanks > > Dardo Schuster > > Tenerife - Canary Islands - Spain > > > >
showpix.py
Description: Binary data
modifypix.py
Description: Binary data
storepix.py
Description: Binary data
_______________________________________________ python-win32 mailing list python-win32@python.org http://mail.python.org/mailman/listinfo/python-win32