Valentina Studio Pro 8.3.3 report keeps on crashing.
Here's the story:
1. In the query I called a stored procedure and tested it (pic 1).
2. Designed a report and preview it (pic 2). So far so good.
3. Now, I disable any calls from the query (pic 3) and
4. Simulate the calls in the pre-build script as I plan to call this from my Xojo app.
When I preview the report, Valentina crashes.
-
Dale
- Report Editor
- 火, 11月 05 2019, 03:29 AM
- メールで購読
コメント
There are no comments made yet.
Sergey Pashkov
承諾済みの回答
Hi Dale,
report.datasource.sqlSelect ("Call genstockcard('2019-06-01', '2019-10-31', 5130, 7608, ‘Location Like "%ware%"',Null,Null,Null,Null, 'C:\\ProgramData\\Clients\\00001\\Images\\baccrea.png'):"
;
The problem must be in the double quotes:
"%ware%"
The string is already in the double quotes, so to use double quotes you must escape them with a slash.
report.datasource.sqlSelect ("Call genstockcard('2019-06-01', '2019-10-31', 5130, 7608, ‘Location Like "%ware%"',Null,Null,Null,Null, 'C:\\ProgramData\\Clients\\00001\\Images\\baccrea.png'):"
;The problem must be in the double quotes:
"%ware%"
The string is already in the double quotes, so to use double quotes you must escape them with a slash.
- ページ :
- 1
- 2
There are no replies made for this post yet.
However, you are not allowed to reply to this post.
However, you are not allowed to reply to this post.