slxdeveloper.com Community Forums

The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!

Administration Forums - General Administration
Forum to discuss general administration topics for SalesLogix (including LAN & remote topics). View the code of conduct for posting guidelines.

Forums RSS Feed

Back to Forum List | Back to General Administration | New Thread

View: Search:

Author

Thread: Bundle and Execute SQL step

Rick Smith
Posts: 96

Bundle and Execute SQL step Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 20 Jan 08 9:43 PM

Wondering if this ought to work via the Execute SQL command in a bundle... I have a batch of SQL statements which include CREATE FUNCTION and CREATE PROCEDURE all contained in a single (.sql) file with GO statements after each item. The statement works via SQL Management Studio. I tried copying the contents and pasting it into the (rather tiny) textbox that is displayed when you choose Execute SQL as a step in building a bundle. This is a 6.2 bundle that I am moving to 7.2. Preceding this step in the bundle are various Insert Plugin steps, and when I apply the bundle in 7.2 all of the forms, scripts, lookups are created, but the Execute SQL seems to be ignored. There is no error displayed, but neither are the FUNCTIONS or PROCEDURES created. Should this work? Is there a different way to create these via a bundle?

[Reply][Quote]

Bob (RJ)Ledger
Posts: 1103

Re: Bundle and Execute SQL step Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 21 Jan 08 6:39 AM

Quote:

Originally posted by Rick Smith

Wondering if this ought to work via the Execute SQL command in a bundle... I have a batch of SQL statements which include CREATE FUNCTION and CREATE PROCEDURE all contained in a single (.sql) file with GO statements after each item. The statement works via SQL Management Studio. .......Should this work? Is there a different way to create these via a bundle?

Use of "GO" is not supported....

You need to make these individual SQL statements and maybe it will work.. in a bundle.
--
RJLedger - rjlSystems

[Reply][Quote]

Rick Smith
Posts: 96

Re: Bundle and Execute SQL step Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 31 Jan 08 5:41 PM

OK, I finally had time to test this. I split all of my SQL statements into separate Execute SQL steps and put them in a separate bundle. The steps first delete the stored procedure if it exists, then creates it, e.g.

- First Execute SQL step:
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[SYSDBA].[C_AllMultiTierAppsWithTier]')
AND OBJECTPROPERTY(id,N'IsProcedure') = 1) DROP PROCEDURE [SYSDBA].[C_AllMultiTierAppsWithTier]

- Second (separate) Execute SQL step:
CREATE PROCEDURE [SYSDBA].[C_AllMultiTierAppsWithTier]...

And, well, nothing happens. I tried simply executing the first one to see if a procedure would be deleted, but again nothing happens. I copy/paste this into SQL Server Mgmt Studio and everything works fine...

Should this work? What am I missing?

[Reply][Quote]

Ryan Farley
Posts: 2265

Re: Bundle and Execute SQL step Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 31 Jan 08 5:58 PM

The SLX provider likely doesn't like the SQL statements. Try executing them via the Execute SQL tool in the administrator. At least then maybe it will give you an error to confirm (not that the error will be much help, probably just "Failed to parse SQL"). Have you tried that yet with the "GO" parts taken out?

-Ryan

[Reply][Quote]

Phil Parkin
Posts: 819

Re: Bundle and Execute SQL step Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 31 Jan 08 6:47 PM

Also try removing the SYSDBA prefix - you are already logged in as sysdba, so this is unnecessary and may even cause problems.

When you executed in Management Studio, were you connected as user sysdba? Just need to make sure that you have appropriate permissions to create and drop db objects.

--edit-- stupid idea - of course the permissions are there, otherwise DB Manager would not work

Phil

[Reply][Quote]

Page 1 of 1

You can subscribe to receive a daily forum digest in your user profile. View the site code of conduct for posting guidelines.

Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!

slxdeveloper.com is brought to you courtesy of Ryan Farley & Customer FX Corporation. This site, and all contents herein, are Copyright © 2025 Customer FX Corporation. The information and opinions expressed here are not endorsed by Sage Software.	code of conduct \|

page cache (param): 7/10/2025 1:48:43 PM