Framework:FKT SqlQuery: Difference between revisions
From CoPlanner 11
Jump to navigationJump to search
No edit summary |
No edit summary |
||
| (One intermediate revision by the same user not shown) | |||
| Line 1: | Line 1: | ||
==[[Framework: | ==[[Framework:Formulae#Functions|Function]]== | ||
<span {{CoPFormel}}>FKT_SqlQuery(<Query>) </span> | <span {{CoPFormel}}>FKT_SqlQuery(<Query>) </span> | ||
| Line 25: | Line 25: | ||
__NOEDITSECTION__ | __NOEDITSECTION__ | ||
[[Category:Functions| | [[Category:Functions|SqlQuery]] | ||
[[Category:Functions_-_server-side|SqlQuery]] | [[Category:Functions_-_server-side|SqlQuery]] | ||
[[de:Framework:FKT_SqlQuery]] | [[de:Framework:FKT_SqlQuery]] | ||
Latest revision as of 14:49, 4 May 2016
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
