Valentina Report with MySQL in Xojo Web

General
1

Hello

I have the following sourcode for valentina report using MySQL with xojo web.

The buil is fine but when I try to run in the web nothing happen.

try

//Open Valentina Project
dim projPath as FolderItem = GetFolderItem(“Ercdtt.vsp”)
dim proj as VProject = new VProject(projPath)
proj.Open

//Print Report into PDF to RAM
dim datasource as String = “mysql://host=‘127.0.0.1’ port=‘3306’ dbname=‘databaseName’ user=‘userName’ password=‘userPassword’”
dim query as String = "Select * from tableName "

dim report as VReport = proj.MakeNewReport(“ValentinaReportName”,datasource,query)
dim data as string = report.PrintToBuffer(EVReportPrintType.kToPDF, 1 )

// Preparate the file for Download
mPDF = new WebFile
mPDF.MIMEType = “application/pdf”
mPDF.Filename = “report.pdf”
mPDF.ForceDownload = False
mPDF.Data = data

//Close Project and Connection
proj.Close

// Show PDF in Browser
showURL(mPDF.URL)

exception err as VException
dim errNumber as Integer = err.errorNumber
dim errString as String = err.Message

end

Thanks