Solve problems. The nuance with the correct select in the stored procedure (The problem of extra select in queries GetItems)
Your storage must output select sets strictly according to the Protocol of the component
(i.e. strict order of SELECT 1, SELECT 2, SELECT 3 and correct column names).
IMPORTANT. If another storage is called in your store, this may lead to the fact that it may also have its own unnecessary select inside it.
To avoid this, use the following solution (https://stackoverflow.com/questions/1492411/sql-server-select-from-stored-procedure):
INSERT INTO #tab EXEC MyProc
The alternative is to call only the stores without the output select (i.e. create some of your own system stores and use them).
Another example of an error is that you wanted to assign a variable via select, forgot about it, and as a result, your output stream gets selected and is incorrectly interpreted by the program.
Examples of how Falcon Space platform components workExamples of convenient tables and forms Examples of dashboards Examples of graphs and charts Example of a calendar Table with API data Example of displaying a map with points Types of form fields Example of a statistics widget Example of a hierarchy tree Example of the Time line component Example of a product card Example of resource load tracking Example of a Kanban board Example of a master form Example of uploading Excel/Word documents Example of filling in TIN data
- Falcon Space Foundation
- Basic components
- Falcon Space Features
- Additional component
- HOWTO Tables
- HOWTO Forms
- Working with SQL
- HOWTO JS
- HOWTO CSS
- HOWTO Layout
- Solve problems Solve problems. The nuance with the correct select in the stored procedure (The problem of extra select in queries GetItems) Solve problems. Do not use system names of variable username, langID Solve problems. The file is not loaded through the resource Manager Solve problems. Displays the outdated content of the stored procedure in the program. Renaming stored procedures Solve problems. What should I do when there is an unclear error? Solve problems. Common mistake How to solve falcon app speed optimization problems How to solve the problem with SPAM mail filters Special symbols on the page are displayed as question marks Feedback form for errors, suggestions Как включить системный лог в Core версии платформы No sockets available. Solving the problem with 6+ tabs in the browser Логирование событий в приложении (trace)
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