Images in TDBBrowse column

[Nick Hilder]

Hi Guys
I have a TDBBrowse. I'm trying to work out how to put an image in a column
based on the underlying database value
For example I have a field called Status, it can be 1, 2 or 3
I would like to use Green, Amber and Red circle bmp's .
If the status is 1, then display green.
I had a look through the sample and help. I'm hoping someone has done it
before and can paste some code.
Nick

[Dionisis Divaris]

TBrwColumn:OnGetData
Event that is produced when the browse requires information or data for
this column to be shown.
Parameters:
<oSender>:
Object that triggers the object (Self).
<@Value>:
Value with the information. This parameter is received by
reference.
<@nImage>:
Image number to show according to the object from the container
Browse. This parameter is received by reference. Its default value zero (no
image).
Return value:
NIL or value. If the returned value is not NIL, its value will be
used to be shown by the container Browse even if the Value variable has been
modified.
Description:
This event is produced every time that the Browse tries to recover
information from the column to display it. You can define this event to
change the information to be shown on the column.
Best Regards
Dionisis
Ο "Nick Hilder" <nick_n0_spam_atcapsol.com.au> έγραψε στο μήνυμα
news:485af9a3$[email=1@ozsrv2.ozlan.local...]1@ozsrv2.ozlan.local...[/email]
> Hi Guys
>
> I have a TDBBrowse. I'm trying to work out how to put an image in a column
> based on the underlying database value
>
> For example I have a field called Status, it can be 1, 2 or 3
>
> I would like to use Green, Amber and Red circle bmp's .
>
> If the status is 1, then display green.
>
> I had a look through the sample and help. I'm hoping someone has done it
> before and can paste some code.
>
> Nick
>
--

Attached files

[Xailer]

TBrwColumn:OnGetData
Event that is produced when the browse requires information or data for
this column to be shown.
Parameters:
<oSender>:
Object that triggers the object (Self).
<@Value>:
Value with the information. This parameter is received by
reference.
<@nImage>:
Image number to show according to the object from the container
Browse. This parameter is received by reference. Its default value zero (no
image).
Return value:
NIL or value. If the returned value is not NIL, its value will be
used to be shown by the container Browse even if the Value variable has been
modified.
Description:
This event is produced every time that the Browse tries to recover
information from the column to display it. You can define this event to
change the information to be shown on the column.
Best Regards
Dionisis
Ο "Nick Hilder" <nick_n0_spam_atcapsol.com.au> έγραψε στο μήνυμα
news:485af9a3$[email=1@ozsrv2.ozlan.local...]1@ozsrv2.ozlan.local...[/email]
> Hi Guys
>
> I have a TDBBrowse. I'm trying to work out how to put an image in a column
> based on the underlying database value
>
> For example I have a field called Status, it can be 1, 2 or 3
>
> I would like to use Green, Amber and Red circle bmp's .
>
> If the status is 1, then display green.
>
> I had a look through the sample and help. I'm hoping someone has done it
> before and can paste some code.
>
> Nick
>
--

Attached files

[Dionisis Divaris]

Hi Nick again
The @value parameter return the current value of the your field Status (1,
2 or 3) and the @nImage is what image you want to display on the column.
But previously the images must be inserted on the TDBBrowse ImageList.
With a simple DO CASE or IF THEN ENDIF structure, you can easily display any
kind of icon you want.
Hope that is help you.
Again best regards
Dionsis
Ο "Dionisis Divaris" <info@sgs-soft.gr> έγραψε στο μήνυμα
news:485b3c7c$[email=1@ozsrv2.ozlan.local...]1@ozsrv2.ozlan.local...[/email]
> TBrwColumn:OnGetData
>
>
>
> Event that is produced when the browse requires information or data
> for
> this column to be shown.
>
>
>
> Parameters:
> <oSender>:
> Object that triggers the object (Self).
> <@Value>:
> Value with the information. This parameter is received by
> reference.
> <@nImage>:
> Image number to show according to the object from the container
> Browse. This parameter is received by reference. Its default value zero
> (no
> image).
>
> Return value:
> NIL or value. If the returned value is not NIL, its value will
> be
> used to be shown by the container Browse even if the Value variable has
> been
> modified.
>
>
>
>
>
> Description:
>
> This event is produced every time that the Browse tries to recover
> information from the column to display it. You can define this event to
> change the information to be shown on the column.
>
>
>
> Best Regards
> Dionisis
>
>
>
> Ο "Nick Hilder" <nick_n0_spam_atcapsol.com.au> έγραψε στο μήνυμα
> news:485af9a3$[email=1@ozsrv2.ozlan.local...]1@ozsrv2.ozlan.local...[/email]
>> Hi Guys
>>
>> I have a TDBBrowse. I'm trying to work out how to put an image in a
>> column
>> based on the underlying database value
>>
>> For example I have a field called Status, it can be 1, 2 or 3
>>
>> I would like to use Green, Amber and Red circle bmp's .
>>
>> If the status is 1, then display green.
>>
>> I had a look through the sample and help. I'm hoping someone has done it
>> before and can paste some code.
>>
>> Nick
>>
>

[Xailer]

Hi Nick again
The @value parameter return the current value of the your field Status (1,
2 or 3) and the @nImage is what image you want to display on the column.
But previously the images must be inserted on the TDBBrowse ImageList.
With a simple DO CASE or IF THEN ENDIF structure, you can easily display any
kind of icon you want.
Hope that is help you.
Again best regards
Dionsis
Ο "Dionisis Divaris" <info@sgs-soft.gr> έγραψε στο μήνυμα
news:485b3c7c$[email=1@ozsrv2.ozlan.local...]1@ozsrv2.ozlan.local...[/email]
> TBrwColumn:OnGetData
>
>
>
> Event that is produced when the browse requires information or data
> for
> this column to be shown.
>
>
>
> Parameters:
> <oSender>:
> Object that triggers the object (Self).
> <@Value>:
> Value with the information. This parameter is received by
> reference.
> <@nImage>:
> Image number to show according to the object from the container
> Browse. This parameter is received by reference. Its default value zero
> (no
> image).
>
> Return value:
> NIL or value. If the returned value is not NIL, its value will
> be
> used to be shown by the container Browse even if the Value variable has
> been
> modified.
>
>
>
>
>
> Description:
>
> This event is produced every time that the Browse tries to recover
> information from the column to display it. You can define this event to
> change the information to be shown on the column.
>
>
>
> Best Regards
> Dionisis
>
>
>
> Ο "Nick Hilder" <nick_n0_spam_atcapsol.com.au> έγραψε στο μήνυμα
> news:485af9a3$[email=1@ozsrv2.ozlan.local...]1@ozsrv2.ozlan.local...[/email]
>> Hi Guys
>>
>> I have a TDBBrowse. I'm trying to work out how to put an image in a
>> column
>> based on the underlying database value
>>
>> For example I have a field called Status, it can be 1, 2 or 3
>>
>> I would like to use Green, Amber and Red circle bmp's .
>>
>> If the status is 1, then display green.
>>
>> I had a look through the sample and help. I'm hoping someone has done it
>> before and can paste some code.
>>
>> Nick
>>
>

[Nick Hilder]

Thanks Dionsis
I will give that a try
Nick
"Dionisis Divaris" <info@sgs-soft.gr> wrote in message
news:485b3e02$[email=1@ozsrv2.ozlan.local...]1@ozsrv2.ozlan.local...[/email]
> Hi Nick again
>
> The @value parameter return the current value of the your field Status
> (1, 2 or 3) and the @nImage is what image you want to display on the
> column. But previously the images must be inserted on the TDBBrowse
> ImageList.
> With a simple DO CASE or IF THEN ENDIF structure, you can easily display
> any kind of icon you want.
>
> Hope that is help you.
>
> Again best regards
> Dionsis
>
>
> Ï "Dionisis Divaris" <info@sgs-soft.gr> Ýãñáøå óôï ìÞíõìá
> news:485b3c7c$[email=1@ozsrv2.ozlan.local...]1@ozsrv2.ozlan.local...[/email]
>> TBrwColumn:OnGetData
>>
>>
>>
>> Event that is produced when the browse requires information or data
>> for
>> this column to be shown.
>>
>>
>>
>> Parameters:
>> <oSender>:
>> Object that triggers the object (Self).
>> <@Value>:
>> Value with the information. This parameter is received by
>> reference.
>> <@nImage>:
>> Image number to show according to the object from the
>> container
>> Browse. This parameter is received by reference. Its default value zero
>> (no
>> image).
>>
>> Return value:
>> NIL or value. If the returned value is not NIL, its value will
>> be
>> used to be shown by the container Browse even if the Value variable has
>> been
>> modified.
>>
>>
>>
>>
>>
>> Description:
>>
>> This event is produced every time that the Browse tries to recover
>> information from the column to display it. You can define this event to
>> change the information to be shown on the column.
>>
>>
>>
>> Best Regards
>> Dionisis
>>
>>
>>
>> Ï "Nick Hilder" <nick_n0_spam_atcapsol.com.au> Ýãñáøå óôï ìÞíõìá
>> news:485af9a3$[email=1@ozsrv2.ozlan.local...]1@ozsrv2.ozlan.local...[/email]
>>> Hi Guys
>>>
>>> I have a TDBBrowse. I'm trying to work out how to put an image in a
>>> column
>>> based on the underlying database value
>>>
>>> For example I have a field called Status, it can be 1, 2 or 3
>>>
>>> I would like to use Green, Amber and Red circle bmp's .
>>>
>>> If the status is 1, then display green.
>>>
>>> I had a look through the sample and help. I'm hoping someone has done it
>>> before and can paste some code.
>>>
>>> Nick
>>>
>>
>

[Nick Hilder]

Thanks Dionsis
I will give that a try
Nick
"Dionisis Divaris" <info@sgs-soft.gr> wrote in message
news:485b3e02$[email=1@ozsrv2.ozlan.local...]1@ozsrv2.ozlan.local...[/email]
> Hi Nick again
>
> The @value parameter return the current value of the your field Status
> (1, 2 or 3) and the @nImage is what image you want to display on the
> column. But previously the images must be inserted on the TDBBrowse
> ImageList.
> With a simple DO CASE or IF THEN ENDIF structure, you can easily display
> any kind of icon you want.
>
> Hope that is help you.
>
> Again best regards
> Dionsis
>
>
> Ï "Dionisis Divaris" <info@sgs-soft.gr> Ýãñáøå óôï ìÞíõìá
> news:485b3c7c$[email=1@ozsrv2.ozlan.local...]1@ozsrv2.ozlan.local...[/email]
>> TBrwColumn:OnGetData
>>
>>
>>
>> Event that is produced when the browse requires information or data
>> for
>> this column to be shown.
>>
>>
>>
>> Parameters:
>> <oSender>:
>> Object that triggers the object (Self).
>> <@Value>:
>> Value with the information. This parameter is received by
>> reference.
>> <@nImage>:
>> Image number to show according to the object from the
>> container
>> Browse. This parameter is received by reference. Its default value zero
>> (no
>> image).
>>
>> Return value:
>> NIL or value. If the returned value is not NIL, its value will
>> be
>> used to be shown by the container Browse even if the Value variable has
>> been
>> modified.
>>
>>
>>
>>
>>
>> Description:
>>
>> This event is produced every time that the Browse tries to recover
>> information from the column to display it. You can define this event to
>> change the information to be shown on the column.
>>
>>
>>
>> Best Regards
>> Dionisis
>>
>>
>>
>> Ï "Nick Hilder" <nick_n0_spam_atcapsol.com.au> Ýãñáøå óôï ìÞíõìá
>> news:485af9a3$[email=1@ozsrv2.ozlan.local...]1@ozsrv2.ozlan.local...[/email]
>>> Hi Guys
>>>
>>> I have a TDBBrowse. I'm trying to work out how to put an image in a
>>> column
>>> based on the underlying database value
>>>
>>> For example I have a field called Status, it can be 1, 2 or 3
>>>
>>> I would like to use Green, Amber and Red circle bmp's .
>>>
>>> If the status is 1, then display green.
>>>
>>> I had a look through the sample and help. I'm hoping someone has done it
>>> before and can paste some code.
>>>
>>> Nick
>>>
>>
>