1. James Whitehead
  2. as Valentina DB Server
  3. Воскресенье, Сентябрь 24 2023, 03:52 AM
  4.  Подписаться через email
I'm trying out the Mail function on VServer. I've cut and pasted from the document examples to create a stored procedure. Here's my code:


Create Procedure SendReport()
BEGIN
DECLARE query_report VARCHAR( 256 ) DEFAULT
'REPORT "universal_report"."Report_Event_Artist"
FROM \"mssql://host = 10.0.0.117 port = 1433 dbname = eios user = eios password = eios timeout=10 datalimit=65535 \"
USING \'SELECT * FROM Event_Artist\'
AS PDF ENCODE BASE64';

DECLARE cursor_report CURSOR FOR query_report;

OPEN cursor_report;
FETCH FIRST cursor_report INTO @report_data;
CLOSE cursor_report;

__MAIL
__FROM 'brad.whitehead@gmail.com'
__TO 'tom@luckymanonline.com'
__SUBJECT 'The Artist List'
__BODY 'View attachment, please.'
__ATTACH @report_data AS 'event_artist.pdf'
__SMTP 'smtp://smtp.gmail.com'
__PORT 465
__USER 'brad.whitehead@gmail.com'
__PASSWORD 'ZZZZZZZ'
__SSL TRUE;

END



When I try to create the procedure, I receive the error: Expecting "__smtp", Found "__SMTP". and the log has: "Kernel error: 0x71000. line 19:9: expecting "__smtp", found '__SMTP' "

This is Vserver 13.3 running on Ubuntu 22.04, with VStudio Pro 13.3.3. The VServer sees and can access the MS SQL database.

What am I doing wrong? Thanks
Комментарий
There are no comments made yet.
Sergey Pashkov Ответ принят
Hello James,

There is an issue in the SQL parser, a fix is made and will be available in the next build.
Комментарий
There are no comments made yet.
James Whitehead Ответ принят
Thanks Sergey. I'll await the next build.
Комментарий
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. 2 subcategories
BETA Testing
  1. 0 subcategories
Education & Research
  1. 0 subcategories