Page tree
Skip to end of metadata
Go to start of metadata

 WARNING: DO NOT CHANGE CLIENT CULTUREINFO WHEN TISERVICE HAD ALREADY BEEN CONNECTED TO THE TISDB!!!

Oracle

A new tenant (Client) can be created by a stored procedure XIMES_DAL.XISP_SAVECLIENT:


Execute in SQL developer:

var clientId varchar2(50)
var clientCompany varchar2(50)
var clientStreet varchar2(50)
var clientPostalCode varchar2(15)
var clientCity varchar2(50)
var clientCountry varchar2(50)
var clientDescription varchar2(200)
var cultureInfoId number
var clientLogo varchar2(255)
var clientFlags number
var insertFlag number
var updatemask number
var retval number

exec :clientId := '01'
exec :clientCompany := 'XIMES'
exec :clientStreet := 'Hollandstrasse 12/12'
exec :clientPostalCode := '1020'
exec :clientCity := 'Wien'
exec :clientCountry := 'Austria'
exec :clientDescription := 'XIMES01'
exec :cultureInfoId := 1
exec :clientLogo := null
exec :clientFlags := 0
exec :insertFlag := 1
exec :updatemask := 0

exec ximes_dal.xiSp_SaveClient(ClientId_in => :clientId, -
                               ClientCompany_in => :clientCompany, -
                               ClientStreet_in => :clientStreet, -
                               ClientPostalCode_in => :clientPostalCode, -
                               ClientCity_in => :clientCity, -
                               ClientCountry_in => :clientCountry, -
                               ClientDescription_in => :clientDescription, -
                               CultureInfoId_in => :cultureInfoId, -
                               ClientLogo_in => :clientLogo, -
                               ClientFlags_in => :clientFlags, -
                               insertflag => :insertFlag, -
                               updatemask => :updatemask, -
                               retval_out => :retval);

commit;


ParameterDescriptionPostgres Sample
CLIENTID_IN
Unique alphanumeric identifier for the tenant (Client). Default is 01.
'01'
CLIENTCOMPANY_IN
Name of the tenant.
'XIMES'
CLIENTSTREET_IN
Address
'Hollandstrasse 12/12'
CLIENTPOSTALCODE_IN
Address
'1020'
CLIENTCITY_IN
Address
'Wien'
CLIENTCOUNTRY_IN
Address
'Austria'
CLIENTDESCRIPTION_IN
Description of the tenant.
'XIMES01'
CULTUREINFOID_IN
Language identifier referes to table CULTUREINFO. 1=en-GB, 2=de-DE
2
CLIENTLOGO_IN
must be <NULL>
null
CLIENTFLAGS_IN
must be 0
2
INSERTFLAG
must be 1
true
UPDATEMASK
must be <DEFAULT>
0

Identifier for Cultureinfo:

MSSQL

MSSQL
DECLARE @RC int
DECLARE @retval_out int

-- TIS 6.0
EXECUTE @RC = [dbo].[xiSp_SaveClient] '01','XIMES','Hollandstrasse 12/12','1020','Wien','Austria','XIMES01',1,null,2,true,0,@retval_out OUTPUT
GO

-- TIS 6.1
EXECUTE @RC = [dbo].[xiSp_SaveClient] '01','XIMES','Hollandstrasse 12/12','1020','Wien','Austria','XIMES01',1,null,2,true,0,'TISAdmin',@retval_out OUTPUT
GO


Postgres

select * from  xisp_saveclient('01','XIMES','Hollandstrasse 12/12','1020','Wien','Austria','XIMES01',1,null,2,true,0);

Afterwards

After successfully updated the table CLIENT the Windows Service TIService must be manually restarted.

A user TISAdmin is created by default.

  • No labels