Master/Detail edit, add, delete

This public forum is for user-to-user discussions of ASPMaker. Note that this is not support forum.

Master/Detail edit, add, delete

Postby darioctas » Mon Oct 09, 2017 4:37 pm

I have a table that has the following field definition in MS SQL

*****MASTER*******
CREATE TABLE [dbo].[names](
[id] [int] IDENTIFY (1,1) NOT NULL,
[name] [nchar](10) NULL,
[state] [bit] NOT NULL,
CONSTRAINT [PK_names] PRIMARY KEY CLUSTERED
( [id] ASC
) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY)

*** DETAIL ***
CREATE TABLE [dbo].[brand](
[id2] [int] IDENTITY(1,1) NOT NULL,
[id_name] [int] NULL,
[brand] [nchar](10) NULL,
CONSTRAINT [PK_brand] PRIMARY KEY CLUSTERED
(
[id2] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

I want that depending on the field "state" in the master table (NAME), if this "true" or "1" will activate editing, deletion and insertion in the detail table (BRAND). And if this "false" or "0" does not activate

Thank you
darioctas
 
Posts: 12
Joined: Wed Feb 25, 2015 2:46 am

Re: Master/Detail edit, add, delete

Postby Webmaster » Mon Oct 09, 2017 5:52 pm

Read:
viewtopic.php?f=4&t=31967

Note that you need to change the PHP codes to ASP.
Webmaster
 
Posts: 10734
Joined: Fri Aug 06, 2004 5:59 pm


Return to General Discussion (ASPMaker)