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 <[email protected]> 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"
