1. cid lopes
  2. Report Editor
  3. Четверг, Апрель 12 2018, 11:58 AM
  4.  Подписаться через email
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