If this is a SetFields action doing a query against another form then my
first question is why do you want to change what ARS automatically creates
as a SQL statement? Is the work flow not executing correctly?
I have not tried this but changing the result list of the form you are
querying may change the columns that are selected. It is possible the form
one server has a different result list than the form on your other server?
On Tue, Dec 21, 2010 at 4:05 AM, koray wrote:
> Hello all,
>
> I have observed a weird issue on 2 different servers. I have an Active
> Link with Set Fields action that retrieves data from another form on
> both of the servers - say with qualification 'A (C3)' = "B". After
> logging, on Server 1 a sample query like below is executed :
>
> select c1, c3 from Txxx where c3='B'
>
> But on the other one,
>
> select c1, c2, c3 from Txxx where c3='B' --> say c1 has value 002
> after the operation.
> select c2 from Txxx where c1='002'
>
> What is the reason for this difference and where is this configurable?
>
> Regards,
> Koray
>
>
> ___
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
>
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
