1. James Whitehead
  2. as Valentina DB Server
  3. Sunday, September 24 2023, 03:52 AM
  4.  Subscribe via 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
Comment
There are no comments made yet.
Sergey Pashkov Accepted Answer
Hello James,

There is an issue in the SQL parser, a fix is made and will be available in the next build.
Comment
There are no comments made yet.
  1. more than a month ago
  2. as Valentina DB Server
  3. # 1
James Whitehead Accepted Answer
Thanks Sergey. I'll await the next build.
Comment
There are no comments made yet.
  1. more than a month ago
  2. as Valentina DB Server
  3. # 2
  • Page :
  • 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