unable to get array from calc field

[eoneon123]

I'm at a loss here. The big picture is that I'm trying to filter a portal by way of a calc field that captures id's based on several filters. I'm just pushing the calc field into the global field so I don't have to refresh. But for some reason, I keep getting a "?" in the g field. The correct values are reflected in the data window but regardless of whether I try and capture the array by way of a set field script step or capture the array by variable, I still get the "?". I thought the problem might arise from something related to inserting and deleting records by way of sql (specifically, something to do with updating the g_field with a newly added or removed id) but even when I created a single line script to capture the array by way of set variable, and alternatively, by sql select, I still get the "?". Any ideas?

[bcooney]

it's not a text field?

[eoneon123]

I assume you mean the global field because of sql? yea, it's a global text field. Weird thing I came across is that for some reason when I "double push" the calc into the field, it works. Meaning, If I set a duplicate set field or sql update step after the initial step, it works.