Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Code Block
languagesql
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 userid varchar2(50)
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 :userid := null
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, -
                               UserId_in => :userId, -
                               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

  • 0 = XIMES
  • 2 = Qmetrix (warning) APPID must be unique on host for MSMQ usage
0
USERID_INmust be <NULL>null
INSERTFLAG
must be 1
true
UPDATEMASK
must be <DEFAULT>
0

...

Code Block
languagesql
titleMSSQL
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,0,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,0,'TISAdmin',true,0,'TISAdmin',@retval_out OUTPUT
GO


Postgres

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

Afterwards

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

...