Showing results for 
Search instead for 
Do you mean 
Community Home Request Access Read Blogs Share Your Ideas Search Community View My Settings
Reply
Highlighted
Astute Commentator
Posts: 13
Registered: ‎02-07-2011

Need to push SQL function change to remotes

Running SLX 7.5.0 with MS SQL Server.

 

I have a SQL function update that I need to push out to my remote users. I tried using Tools->Execute SQL... to create an "alter function" command, but SLX Admin didn't like that. Is this possible to do this in an automated fashion? Thanks for any input here.

Highlighted
Employee
Posts: 79
Registered: ‎06-25-2009

Re: Need to push SQL function change to remotes

You should be able to do this in Admin with the ExecuteSQL dialog.  You will need to wrap your SQL in the following to prevent the provider from trying to parse it.

 

Exec('<your sql>')

 

 

Paul Zeimet
Development Manager
Infor CRM
Highlighted
Gold Super Contributor
Posts: 3,087
Registered: ‎03-19-2009

Re: Need to push SQL function change to remotes

Nice!.. did not know you could use Exec(....) in the ExecuteSQL function in Admin.

--
RJ Ledger - rjledger@rjlSystems.net +1 603.369.3047 x101

".. Innovators in Mobility - Experts in Workflow Automation..."
http://www.rjlSystems.net - blog: www.rjlSystems.net/blog.html