1. Dale
  2. Valentina Reports ADK
  3. 水, 6月 10 2020, 03:26 PM
  4.  メールで購読

I have the following MySQL Schemas:
- Branch01
- Branch02
- Branch03

They have the same tables and corresponding structures. I have a report that calls a stored procedure that pulls the data for the report. I designed my report using Branch01. At runtime, the user may select Branch01 or Branch02 or Branch03, depending upon the given situation. However, my report still calls the data of Branch01.

How to work around this? I am using MySQL and Xojo.
There are no comments made yet.
Sergey Pashkov 承諾済みの回答
Hi Dale,

How do you generate a report?

Usually we specify the schema name in the datasource string passed to MakeNewReport:
"host = '', port = 3306, user = 'sa', password = 'sa', dbname = 'Branch01'",
"SELECT *.....
There are no comments made yet.
Dale 承諾済みの回答
Hi Sergey,

Please see attachment for my report's datasource at design time. I am calling the right schema from Xojo but my select statement is a call to the stored proc. If I use the first branch (in this case "bw01";), everything is okay but if I use another, it only shows a blank report.
There are no comments made yet.
Dale 承諾済みの回答
Sergey, I got it now. Since my stored proc that is being called creates a temporary table, I included a "Select * from tempTable" at the end of the stored proc.

Sorry to bother. Cheers for your support!
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.