Shapes. How to create a form for editing an entity

  • Creating a page and throwing a snippet of the form  
<div class="as-form" data-code="myEditForm" data-itemid="formy--kak-sozdat-formu-dlya-redaktirovaniya-sushchnosti"></div>​
  • As a result, the URL parameter itemID is passed to the stored procedure.
  • Custom form
  • Custom shape column
  • Creating stored procedures with the itemID parameter passed to you

Example GetItem

CREATE PROCEDURE [dbo].[fm_editForm_getItem]
  @itemID int,
  @username nvarchar(256)

AS
BEGIN
    select * from as_forms where id = @itemID

    select 'Editing form parameters "'+title+'"' Title, '" Subtitle
    from as_forms where id = @itemID
END

Example saveItem

CREATE PROCEDURE [dbo].[fm_editForm_saveItem]
  @username nvarchar(256),
  @itemID int,
  @fieldcode nvarchar(256) = '',
  @fieldtitle nvarchar(256) = '',
  @fieldsubtitle nvarchar(256) = '',
  @fieldresultMessage nvarchar(256) = '',
  @fieldsuccessURL nvarchar(256) = '',
  @fieldmakeup nvarchar(max) = '',
  @fieldhideFormAfterSubmit bit = 0,
  @fieldbuttonText nvarchar(256) = '',
  @fieldusers nvarchar(256) = '',
  @fieldroles nvarchar(256) = ''
AS
BEGIN
    update as_forms
    set
        code = @fieldcode,
        title = @fieldtitle,
        subtitle = @fieldsubtitle,
        resultMessage = @fieldresultMessage,
        successURL = @fieldsuccessURL,
        makeup = @fieldmakeup,
        hideFormAfterSubmit = @fieldhideFormAfterSubmit,
        buttonText = @fieldbuttonText,
        users = @fieldusers,
        roles = @fieldroles
    where id = @itemID

    select 1 Result, 'Form saved' Msg
END
Falcon Space is a functional web development platform on a narrow stack MS SQL/Bootstrap. Falcon Space Gettting started
{sp-shortDemostandLinks}

SQL-tool for creating personal accounts on the site

The essence of the approach and the history of the creation of Falcon Space
Web platform for creating personal accounts

Falcon Space Platform

This is a reduction in the cost of ownership

at the expense of fewer people to support

This is a quick change

while using the program

This is a modern interface

full adaptation for mobile devices

MS SQL web applications. Affiliate program for developers and web studios

You can develop on your own or collaborate with us on Falcon Space web development using only SQL and HTML.
See examples with SQL code
Platform documentation
Working on MS SQL Server
Note