1. cid lopes
  2. Report Editor
  3. 木, 4月 12 2018, 11:58 AM
  4.  メールで購読
Hello, how do I set a variable session in sql Ex: SET SESSION group_concat_max_len = 1000000;
When I associate in the datasource, it returns an error :
08:55:34 SELECT * ,extravios AS InternalReportField0 FROM (
SET SESSION group_concat_max_len = 100000;
SELECT......
コメント
There are no comments made yet.
Sergey Pashkov 承諾済みの回答
Hello Cid,

Please try to use the pre_build SQL script of the report.

1. Click on the empty space of the report
2. Edit the pre_build property
3. Switch script language to SQL
4. Input text
添付ファイル
コメント
There are no comments made yet.
cid lopes 承諾済みの回答
It worked !!
Thanks Sergey Pashkov.
コメント
There are no comments made yet.
  • ページ :
  • 1


There are no replies made for this post yet.
However, you are not allowed to reply to this post.

Categories

Announcements & News
  1. 0 subcategories
Valentina Studio
  1. 2 subcategories
Valentina Server
  1. 4 subcategories
Valentina Database ADK
  1. 0 subcategories
Valentina Reports ADK
  1. 0 subcategories
Other Discussions
  1. 0 subcategories
BETA Testing
  1. 0 subcategories
Education & Research
  1. 0 subcategories
Omegabundle
  1. 0 subcategories