Press Ctrl / CMD + C to copy this to your clipboard.
This post will be reported to the moderators as potential spam to be looked at
Hello,
I have created a package for Umbraco CMS. In package.xml file, I have included an xml tag to execute sql script during installation:
<Action runat="install" undo="false" alias="ExecuteSql"> <![CDATA[ CREATE TABLE [dbo].[Products]( [Id] [int] IDENTITY(1,1) NOT NULL, [Name] [nvarchar](250) NULL, [Category] [nvarchar](150) NULL, [Price] [float] NULL); INSERT INTO [dbo].[Products] VALUES ('Tomato Soup','Groceries',1); INSERT INTO [dbo].[Products] VALUES ('Yo-yo','Toys',3.75); INSERT INTO [dbo].[Products] VALUES ('Hammer','Hardware',16.99); ]]> </Action>
But the sql script doesn't run and no data table has been created.
Here is my package.xml. Please help me to run the sql script during the installation of package.
is working on a reply...
This forum is in read-only mode while we transition to the new forum.
You can continue this topic on the new forum by tapping the "Continue discussion" link below.
Continue discussion
ExecuteSql doesn't work during installation of a new package
Hello,
I have created a package for Umbraco CMS. In package.xml file, I have included an xml tag to execute sql script during installation:
But the sql script doesn't run and no data table has been created.
Here is my package.xml. Please help me to run the sql script during the installation of package.
is working on a reply...
This forum is in read-only mode while we transition to the new forum.
You can continue this topic on the new forum by tapping the "Continue discussion" link below.