How to remove old dict procedures in forms and tables
old dict procedures are not saved correctly.
The fact is that both types are supported, for new procedures, only the new type of automatic naming is used. Previously, you could specify any name for the stored procedure.
It's just that the procedure is not deleted by the old name (because in sys.procedures it is stored under the new name, but object_definition is used for it with the old name).
deleting the procedure by the new name в sql
drop proc [fm_notificationType_alertTypeName_dict]
We check that it was deleted (by the new name):
declare @sp nvarchar(218) = 'fm_notificationType_alertTypeName_dict' select object_definition(object_id) from sys.procedures where name = @sp; select name, type_name(user_type_id) [typename], max_length [maxLength] from sys.parameters where object_id = object_id(@sp) order by parameter_id
Clearing the server cache in the control panel (checking for the existence of the procedure is cached).
Automatically re-create the procedure as usual via the column or form editing interface.
- Falcon Space Foundation
- Basic components
- Falcon Space Features
- Additional component
- HOWTO Tables Tables. How to do sorting in AS CRUD Tables. How to make Editable for a tick (Yes/No) in AS CRUD Tables. How to edit a date column Tables. How to link 2 tables Tables. How to make a table in a modal window (opens in a dialog window) Tables. How can I remove the display of the number of result rows in the table header? Tables. How to link a table and edit an entity (dependent page) Tables. How to use comments in tables Tables. How to add a value Not selected with the value in the filter Tables. How to set the column width in a table Tables. How to add a range of dates or numbers to the filter Tables. How to execute operations only for certain lines Tables. How to make a different set of columns in the same table for different roles Tables. How to implement a sub-table (nested table), a subform in a table Tables. How to hide row operations in a table for specific lines Tables. How to make manage files (images or documents) in the table column) Tables. How to add a callback after loading a table Tables. How to make a table on your smartphone in the form of cards Tables. How to work with checkboxes in a table Tables. Common errors when configuring the table (why the table doesn't work) Tables. How to update a sub-table after performing an operation Tables. How to process group operations via the modal form Tables. How to create preset filters for a table Tables. How to output data from a remote source (via the API) in the Table component How to make collapse a table Tables. Loading the table by link How to remove old dict procedures in forms and tables Table. Excel styling when uploading a table to MS Excel Table. How to make a filter with a checkmark tree Tables. How to disable saving table state (filters) Tables. How to make a link to the entire table line Tables. How to pass the filter value via URL Tables. How to crop table cells Sorting lines in a table Table. Creating an entity based on filter values SQL query Optimization-extracting data for a table Custom markup in the table Tables. How to set up additional header and footer for a table Table. How to make dependent filters in a table Импорт данных в формате файлов txt,csv через таблицу
- HOWTO Forms
- Working with SQL
- HOWTO JS
- HOWTO CSS
- HOWTO Layout
- Solve problems
SQL-tool for creating personal accounts on the site
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