Framework:FKT SqlQuery

Function

FKT_SqlQuery(<Query>)

Parameter	Description
Query	Query, which should be executed.

This function belongs to server-side functions.

Result

Provides the result of the SQL Query. If the query is not valid or provides no value the function returns 0. The database connection is always the coplanner database connection, which is defined in the svrconfig.xml. It is not possible to use SQL-functions like LEFT('xy',1), GETDATE(), etc.. Using them will provide a red cube.

Example

FKT_SqlQuery(select copsys_id from dbo.Produkte where copsys_dim_name='Produkte') -> liefert 1