API CreateCurrency: Porovnání verzí

Z Podpora.nextis.cz
Přejít na: navigace, hledání
(Založena nová stránka s textem „==== Description ==== Method allows You to create new currency in system. ==== Exact name ==== <code>API_CreateCurrency</code> ==== Type ==== Standard ex…“)
 
Řádka 16: Řádka 16:
 
!Relation
 
!Relation
 
|-
 
|-
|@Title
+
|@Name
 
|nvarchar(50)
 
|nvarchar(50)
 
|
 
|
|Title
+
|Name
 +
|
 +
|-
 +
|@Code
 +
|nvarchar(50)
 +
|
 +
|Code
 +
|
 +
|-
 +
|@Symbol
 +
|nvarchar(50)
 +
|
 +
|Symbol
 
|
 
|
 
|}
 
|}
Řádka 25: Řádka 37:
 
==== Example ====
 
==== Example ====
 
<syntaxhighlight lang="sql">
 
<syntaxhighlight lang="sql">
EXEC [API_CreateCurrency] @Name= 'Name' ,@Code= 'Code' ,@Symbol= 'Symbol'
+
EXEC [API_CreateCurrency] @Name= 'Polish złoty' ,@Code= 'PLN' ,@Symbol= ''
 
</syntaxhighlight>
 
</syntaxhighlight>
  
 
==== Notices ====
 
==== Notices ====
 
None.
 
None.

Verze z 1. 8. 2017, 09:39

Description

Method allows You to create new currency in system.

Exact name

API_CreateCurrency

Type

Standard executable stored procedure.

Specification

Parameter Data type Value range Description Relation
@Name nvarchar(50) Name
@Code nvarchar(50) Code
@Symbol nvarchar(50) Symbol

Example

EXEC [API_CreateCurrency] @Name= 'Polish złoty' ,@Code= 'PLN' ,@Symbol= 'zł'

Notices

None.