1. Roddney Colman
  2. Valentina Reports ADK
  3. 土, 2月 08 2020, 02:59 PM
  4.  メールで購読
Problems to deploy valentina reports with xojo 2018 r4
dont do anything just crash and close xojo wep app
some solution
コメント
There are no comments made yet.
Roddney Colman 承諾済みの回答
this is the log say in test proyect

V4RB: PluginEntry()
V4RB: DisableRBDB file IS NOT found. Enabling RBDB.
コメント
There are no comments made yet.
Sergey Pashkov 承諾済みの回答
Hello Roddney,

Please add more details.

What is the version of V4RB plugin?
On what OS do you compile the application?
And OS you’re trying to deploy to?
コメント
There are no comments made yet.
Roddney Colman 承諾済みの回答
tks sergey for reply
OS Windows 10 64 bit
OS Deploy Windows 10 64 Bit
Xojo 2018 r4 64 bit
plugin version i dont now buy last year omega bundle

this is the line when crash
Dim report as VReport = Proj.MakeNewReport("rptingresomer", DataSource )
コメント
There are no comments made yet.
Roddney Colman 承諾済みの回答
this is my code


try

dim ProjPath as FolderItem = GetFolderItem("rptingreso.vsp")
dim Proj as VProject = new VProject( ProjPath )
Proj.Open()

Dim DataSource as String = "mssql://host='xxxxxxxxx' port = 1433 user='xxxxxxx' password= 'xxxxxxxxx' dbname= 'xxxxxxxx'"

Dim report as VReport = Proj.MakeNewReport("rptingresomer", DataSource )
Dim data as String = report.PrintToBuffer(EVReportPrintType.kToPDF,1)

mPDF= new WebFile
mPDF.MIMEType = "application/pdf"
mPDF.Filename= "repingremer.pdf"
mPDF.ForceDownload = False
mPDF.Data= data

Proj.Close

ShowURL(mPDF.URL)

catch err as VException
dim errNumber as Integer = err.ErrorNumber
Dim errString as String = err.Message

end try
コメント
There are no comments made yet.
Sergey Pashkov 承諾済みの回答
So when you run it on your system - it works, but when you copy compiled application to another system - it crashes.
Or crashes everywhere?

Did you try to output values of errNumber or errString to get the reason?
dim errNumber as Integer = err.ErrorNumber
Dim errString as String = err.Message
コメント
There are no comments made yet.
Roddney Colman 承諾済みの回答
Not run in debug mode not run compile mode
コメント
There are no comments made yet.
Sergey Pashkov 承諾済みの回答
You run the application and it crashes on this line
Dim report as VReport = Proj.MakeNewReport("rptingresomer", DataSource )

Is it because of the exception? Can you debug step by step to check the errString/errNumber values?
コメント
There are no comments made yet.
Roddney Colman 承諾済みの回答
somebody have sample xojo code to call a valentina report using sql server
Tks
コメント
There are no comments made yet.
Roddney Colman 承諾済みの回答
You run the application and it crashes on this line
Dim report as VReport = Proj.MakeNewReport("rptingresomer", DataSource )

Is it because of the exception? Can you debug step by step to check the errString/errNumber values?

Yes i think is my adk problem where i can update my adk or i need to buy again ?
コメント
There are no comments made yet.
Roddney Colman 承諾済みの回答
コメント
There are no comments made yet.
Sergey Pashkov 承諾済みの回答
If you get to MakeNewReport call most likely there is no problem with ADK. The problem in the discussion you found was due to not updated Xojo cache after V4RB plugin was upgraded to a new version.

1) Please describe when you run it in the debugger does it stop with an exception on the MakeNewReport line?
Can you click the VException variable to check its value? (Selected on screenshot)
Or does it just stop debugging?

2) You can generate the datasource string within the Valentina Studio - select the datasource on the project tab and click Show Datasource String context menu item. Then you can paste it to MakeNewReport call.

3) You can install any version released during a year after the day of purchase. Previously released versions can be found here: http://valentina-db.com/download/prev_releases/
添付ファイル
コメント
There are no comments made yet.
Roddney Colman 承諾済みの回答
If you get to MakeNewReport call most likely there is no problem with ADK. The problem in the discussion you found was due to not updated Xojo cache after V4RB plugin was upgraded to a new version.

1) Please describe when you run it in the debugger does it stop with an exception on the MakeNewReport line?
Can you click the VException variable to check its value? (Selected on screenshot)
Or does it just stop debugging?

2) You can generate the datasource string within the Valentina Studio - select the datasource on the project tab and click Show Datasource String context menu item. Then you can paste it to MakeNewReport call.

3) You can install any version released during a year after the day of purchase. Previously released versions can be found here: http://valentina-db.com/download/prev_releases/


just stop dont give a exeption some time close the xojo
コメント
There are no comments made yet.
Sergey Pashkov 承諾済みの回答
Let's try to add more debug information to the log, change Valentina.DebugLevel after the Valentina.InitReports:

Valentina.InitReports(...

Valentina.DebugLevel = EVDebugLevel.kLogParams

That produces a file like vlogs/V4RB_Log_20200211_143841.log in the project folder.
コメント
There are no comments made yet.
Roddney Colman 承諾済みの回答
Valentina_SetDebugLevel...
PARAM: inLevel = 3
return

VProject_Ctor_Local...
PARAM: instance = 13672136
PARAM: inFi = 13946104
return

VProject_Open...
PARAM: instance = 13672136
return

VProject_MakeNewReportByName...
PARAM: instance = 13672136
PARAM: inName = "rptingresomer"
PARAM: inDatabaseSource = "mssql://host='192.165.85.47' port = 1433 user='tes' password= 'tes' dbname= 'tes'"
PARAM: inQuery = ""
コメント
There are no comments made yet.
Sergey Pashkov 承諾済みの回答
Usually, it should not be a problem, but what if you specify a query as an empty string "" and if it doesn't help - as a full text of the query.
コメント
There are no comments made yet.
Roddney Colman 承諾済みの回答
i put the query now and get this log

V4RB: PluginEntry()
V4RB: DisableRBDB file IS NOT found. Enabling RBDB.
コメント
There are no comments made yet.
Sergey Pashkov 承諾済みの回答
And does vlogs/V4RB_Log_xxx.log contain these lines? And nothing changes?

That's strange, maybe there's something wrong in the installation

As I wrote all versions are here
http://valentina-db.com/download/prev_releases/

The latest 9.8.1 version:
http://valentina-db.com/download/prev_releases/9.8.1/win_32/v4rb_9_win.exe

Maybe you need an older version, released 1 year after purchase.
コメント
There are no comments made yet.
Roddney Colman 承諾済みの回答
Hi sergey finally we solve the issue
the issue was the name of the report in this line

Dim report as VReport = Proj.MakeNewReport("rptingresomer", DataSource )

now we want to test deployin it in windows server what file y need to put with my xojo app to show the report
tks
コメント
There are no comments made yet.
Sergey Pashkov 承諾済みの回答
コメント
There are no comments made yet.
Roddney Colman 承諾済みの回答
Tks Surgey now i have to test i really apreciated your help tks again
コメント
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