PC SOFT

WINDEV, WEBDEV AND WINDEV MOBILE
ONLINE HELP

Home | Sign in | English UK
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadApple WatchUniversal Windows 10 AppWindows Mobile
Others
Stored procedures
Configures the management of data for a SaaS site.
Remarks:
  • To use this function, a SaaS management session must have been started beforehand by SaaSAdminConnect.
  • Versions 16 and later
    The use of this function is reserved to the SaaS administrator. A manager of client accounts cannot use this function.
    New in version 16
    The use of this function is reserved to the SaaS administrator. A manager of client accounts cannot use this function.
    The use of this function is reserved to the SaaS administrator. A manager of client accounts cannot use this function.
Example
// Create a SaaS site with a database for each client
S is SaaSSite
CtSite is Connection

S..Name = "Forum"

IF SaaSAdminAddSite(S) = True THEN
CtSite..Server = "localhost"
CtSite..Provider = hAccessHFClientServer
CtSite..User = "admin"
CtSite..Password = "secret"
CtSite..Database = "ForumDatabase"

IF SaaSAdminConfigureSiteData(S, saasBaseClient, CtSite) = True THEN
Info("The site was created and configured.")
END
END
Syntax
<Result> = SaaSAdminConfigureSiteData(<SaaS site> , <Management Mode of Data> [, <Connection Parameters>])
<Result>: Boolean
  • True if the modification was performed,
  • False otherwise. To find out the error details, use ErrorInfo.
<SaaS site>: saasSite variable or character string
Site (or name of site) for which the data management must be configured.
<Management Mode of Data>: Integer constant
Management mode of data, the possible values are:
saasBaseNoneThe site is not using any database.
saasBaseClientThe site is using a single database shared between all client accounts.
saasBaseCommonThe site is using a database for each client account. This database is created by duplicating a default database.
<Connection Parameters>: Optional Connection variable
Depending on the management mode:
No database<Connection parameter> is not required; it will be ignored if it is specified.
Database for each client account<Connection Parameter> indicates the parameters for connecting to the default database.
Common database<Connection Parameter> indicates the parameters for connecting to the common database.
Remarks
If the site was already configured in a database management (example: a database per client), we advise you not to change this management mode. Indeed, the configuration of data is not retroactive. The clients who are already subscribers will keep their database. To modify the connection parameters retroactively, the data management must be modified for each client by SaaSAdminModifyClientConnection.
For a management mode with one database per client, the databases will be automatically created on the same server as the reference database. Their name will be built with the name of the site and the name of the client (for example: ECommerce_Hybrid). A user dedicated to the use of the database by the client will be created.
Component : wd250com.dll
See also
Minimum version required
  • Version 15
This page is also available for…
Comments
Click [Add] to post a comment