2 part question:
1. Has anyone ever been able to display a JPG in a picture field? I am currently selecting a BLOB from the database, writing it to a file locally, then dynamically setting a picture in a window on the application. It will not show up as a JPG, but I can get BMPs to be displayed. Is there a function to convert? Or is there a function that can handle displaying JPG format?
2. How do I get around the 32k limitation on pictures? I have employee pictures that need to be displayed and are in the database as JPGs atm, but larger than 32k. In searching my temporary directory after FileRead() and FileWrite() functions, the JPG is placed in the directory, but only about the top 5th of the picture is displayed.
Thanks much in advance
(Code for my OPEN event on a window with a picture box appears below)
WHERE card_id = '001983703'
li_FileNum = FileOpen( "C:\TEMP\IDCARD.JPG")
IF li_filenum <> -1 THEN
ll_FLength = FileLength("C:\TEMP\IDCARD.JPG")