Method:Classic General Q&A

Re: Get custom SQL value when looping grid

Method_Justin — Mon, 15 Dec 2014 21:59:55 GMT

Hi furrywombat,

This is not possible because SQL overrides are not stored. There is no way to retrieve them because there is nowhere to retrieve them from, they function only as a means to manipulate the way data is represented on screen.

- Justin

Re: Get custom SQL value when looping grid

furrywombat — Sun, 14 Dec 2014 15:01:17 GMT

I did, and that value was the value of the database entry underneath the custom SQL override (i.e. NOT the override value).

Is there a way to get the custom SQL override value when looping through a grid?

Re: Get custom SQL value when looping grid

fran — Sun, 14 Dec 2014 05:44:21 GMT

Did you change action to Get the VALUE from ROW - since you are in a loop?

Get custom SQL value when looping grid

furrywombat — Sat, 13 Dec 2014 13:31:15 GMT

When I get the value of a grid element from the current row using VALUE FROM SCREEN, I am able to get the result of the custom SQL value for that cell. However, when I am looping a grid, it seems this is not possible. Is there a way around this that I am not seeing?

Best,

Furry