Is there an easy way to import images from mySQL database to a datagrid table?
I want to put images from my database in each row.
I tried it with a code like this:
Code: Select all
put the dgText of group "list" into t
repeat for each line x in t
set the itemDelimiter to tab
put item 1 of x into PId
put "SELECT picture FROM database where id="&PId&"" into sql
put revQueryDatabase (dbid, sql) into tImageData
put revDatabaseColumnNamed(tImageData, "picture", theImage)
set the text of Image "Picture" to theImage
end repeat
Thx for any advice