swillhite (mrswoop) wrote
Knew it couldn't be THAT simple ;)
I've not tested the following SQL, but these two statements SHOULD be about what you need... you can run it from the Host SQL window or do this via Enterprise Manager or with whatever access you have:
INSERT INTO [dbo].[ModuleControls]
([ModuleDefID]
,[ControlKey]
,[ControlTitle]
,[ControlSrc]
,[IconFile]
,[ControlType]
,[ViewOrder]
,[HelpUrl])
VALUES
(
,NULL
,NULL
,'Admin/Vendors/DisplayBanners.ascx'
,NULL
,0
,NULL
,NULL)
INSERT INTO [dbo].[ModuleControls]
([ModuleDefID]
,[ControlKey]
,[ControlTitle]
,[ControlSrc]
,[IconFile]
,[ControlType]
,[ViewOrder]
,[HelpUrl])
VALUES
(
,'Edit'
,'Edit Banners'
,'Admin/Vendors/BannerOptions.ascx'
,NULL
,1
,NULL
,NULL)
thank u so much for the response but when it comes to that SQL code, I don't know where to begin... please forgive my ignorance on this one.
where can i find the Host SQL window????
thank u again