There shouldn't be any spaces in between the name of the alias.
>Hello all,
>
>I was trying to run a select statement to get data into an array. I got an error saying " 'Field name' is not a memory variable."
>
>That 'field name' is actually a field in one of my alias I use in the SQL. Why did I get this error?
>
>Any help would be greatly appreciated.
>
>Thanks.
- Jayesh