1. Scott
  2. Report Editor
  3. 土, 2月 18 2017, 11:50 PM
  4.  メールで購読
Using the 7.0.1 VStudio for both a local VDB an VReport (On Windows):

In studio the Locale starts out blank and I can't set a specific Locale. I click on the editing pencil and set it to en_US but it will not persist. It remains blank.

Design a local DB - one of the fields (sDate) is a date field (MM/DD/YYYY) set for each record.

Query: SELECT * FROM tblCOPP WHERE sDate BETWEEN $P(startDate) AND $P(endDate)

Then I use the new interactive function in VStudio for parameters, I set two: (same parameter names as in the DB query)

startDate (inDate)
endDate (inDate)

Run the report and set the two dates via the popup in the MM/DD/YYYY format and the report errors out telling me the date parameter is invalid (illegal character at position yada yada) because the interactive parameter date has been encoded in the YYYY-MM-DD format instead of the MM/DD/YYYY I am using.

In the query editor if I set a default date for my two parameter fields it works fine when you click the test tab.

Any idea what I am doing wrong?

Scott
コメント
There are no comments made yet.
Scott 承諾済みの回答
I also just connected to our VServer (7.0.1) and again the Locale is blank and cannot be set.
コメント
There are no comments made yet.
Scott 承諾済みの回答
I disabled the interactive feature in the parameter section of VStudio and hard coded two dates in the startDate and endDate parameters as 02/10/2017 and 02/28/2017 and now the report works as expected.

The dates must default to the YYYY-MM-DD format in the interactive popup when sent to the report.
コメント
There are no comments made yet.
Sergey Pashkov 承諾済みの回答
Hello Scott,
Thank you, I've reproduced these issues
コメント
There are no comments made yet.
Sergey Pashkov 承諾済みの回答
Fixes will be available in the version 7.0.2.
コメント
There are no comments made yet.
Scott 承諾済みの回答
Thanks Sergey for your help!
コメント
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. 0 subcategories
BETA Testing
  1. 0 subcategories
Education & Research
  1. 0 subcategories
Omegabundle
  1. 0 subcategories