B4J Question SOLVED -JRDC: creating a command to fetch a BLOB

[Cableguy]

Hi guys:

I'm adding sql commands to my config file as I need them... And now I need to fetch a blob depending of a list selection...
So in plain english it would be something like:

Get me the flag(this is the blob) whose countryName is Portugal

an aproximative sql Statement I guess would be something like:

SELECT 'CountryFlag' FROM 'xpto' WHERE 'CountryName'="Portugal"

"Portugal" is a variable given by a listview...

Any help is welcomed

[SORRY, SOLVED]

 

[Harris]

[SORRY, SOLVED]

But how?

Some of us know, but others don't. A link to where you found the solution would be helpful (or your code snippet).

When we search, we often run into these dead ends... I know you do too.

In my mind, [solved] should include the solution. Yes, I am guilty of supplying the same... but yet Mr. Faulty - I learn, I learn...

 

[Cableguy]

For Each row() As Object In result.Rows
If result.Rows.Size = 0 Then Exit
For Each record As Object In row
FlagContainer.SetImage(reqManager.BytesToImage(record))
Next
Next

FlagContainer is an ImageView