1. cid lopes
  2. Report Editor
  3. Donnerstag, April 12 2018, 11:58 AM
  4.  Abonnieren via E-Mail
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......
Kommentar
There are no comments made yet.
cid lopes Akzeptierte Antwort
It worked !!
Thanks Sergey Pashkov.
Kommentar
There are no comments made yet.
Sergey Pashkov Akzeptierte Antwort
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
Anhänge
Kommentar
There are no comments made yet.
  • Seite :
  • 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. 2 subcategories
BETA Testing
  1. 0 subcategories
Education & Research
  1. 0 subcategories