Caption from the table.. 1

[Brezhnev]

Hi all!
I have a little question.I am working on Audit report ... so i record changes in one table into the other.So for ex. you changed employee name , so i am storing field name(EMPNAME) and changes.But on the report I would like to show "Employee Name" .. so I found table property Caption and trying to use it . Some problems with the syntax
Can anybody point me out how to access property programatically ?

thank you

 

[ramani]

HI

If the table belongs to DBC, then you can use the fields caption you have set.
This can be obtained as..

myCaption =
DBGETPROP(cTable+"."+lcField,"FIELD","CAPTION&quot)
OR
myCaption = DBGETPROP(fieldName,"FIELD","CAPTION&quot



ramani
(Subramanian.G)

http://winnersoft.coolfreepages.com/

 

[ramani]

HI

If the table belongs to DBC, then you can use the fields caption you have set.
This can be obtained as..

myCaption =
DBGETPROP(cTable+"."+lcField,"FIELD","CAPTION&quot)
OR
myCaption = DBGETPROP(cFieldName,"FIELD","CAPTION&quot



ramani
(Subramanian.G)

http://winnersoft.coolfreepages.com/

 

[Brezhnev]

thanks ..that'll do..