Skip to Content
0
Former Member
May 04, 2005 at 07:25 AM

Formatted search issue on user table

108 Views

Hi,

appreciate if anyone can help me with this.

I have a user table (say "UT"). I have additional fields in it too.

In any case I need to refer to one of the columns using the $ notation we can use on other grids such as Invoice line.

eg: $[$3.2.0] will get me the value on the column number 2, and $3 being the item id of the matrix.

However the columns on the user table don't have a number, they have a string id. I tried using

$[$3.ColumnName.0] but does not work. Even $[$3.2.0] did not give me column 2 value.

THIS SQL HERE FAILED.

SELECT 'a' WHERE $[$3.2.0] = 1027

could I be doing something wrong here ???

Thanks,

Indika.