Forms. How to correctly process prices (fractional numbers) on the form

1. In columns, the price column type is a fractional number

2. In the checkItem and saveItem procedures, the parameter type @fieldprice is nvarchar(16)

3. In saveItem we start a variable:

declare @price decimal(18,2)

select @price = try_cast(replace(@fieldprice, ',', '.') as decimal(18,2))

And write the @price variable to the database

Falcon Space is a functional web development platform on a narrow stack MS SQL/Bootstrap. Falcon Space Gettting started
{sp-shortDemostandLinks}

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

Note