Xataface Forums

Hello, I want to do something, but I don't find informations about this.

I have a sql select like :


__sql__ = "SELECT ID_Event, CONCAT(name, ' (' , status, ')') FROM Event;"

--> status is a int and is associated with a value from the valuelists.ini

My question is : Can I display directly the value from the valuelist.ini ?

Thank you and sorry for my English

Do you want to get the result of this query (i.e. all rows of the valuelist), or just the value of a field that uses this valuelist?

I want to display the result of this query and replace the "status" (int) to the value from the valuelist.ini...

Do you understand ?

I need some context to know what you're trying to do. The answer is invariably 'YES' you can do that. I just don't know what you're trying to do specifically.

e.g. Are you using a Dataface_Record object trying to get a field display value rather than the id value... or are you wanting to display it somewhere in the app, or are you trying to list out all values of a valuelist....


-Steve