I'm talking about the 'query text' field. I just spent about a weeks worth of hours trying to figure out why valid SQL (ran fine in SSMS) would not produce results from a "VA Inqueries" assigned to a workcenter GRID.
It turns out that (a) you can't use stored procedures, even though "Update Columns" works fine, and (b), you can't use functions unless they declare the table at the start of the function. Both of which work fine within the SQL world, but fail silently in the VP world.
Doing any of the forbidden things results in no error messages at all, just a blank work center tab.
Viewpoint: Please consider REDUCING the amount of code you use to check the QUERY TEXT window, and instead, run it as is and pump the results to whatever area is asking for them. By "Results", I'm talking about the first result set.
If this is a bug on the WORK CENTER side of things, please consider tweaking that side to allow usage of a VA Inquery with any valid SQL.
Thanks.
Nathan Sutherland
| Company | A-1 Plumbing |
| Job Title / Role | Developer |
| I need it... | 3 months |
Dear Viewpoint Suggestion Box contributor;
We at Viewpoint sincerely thank you for your contribution to Suggestion Box on how we can improve Viewpoint products. While we can’t do everything at once, we rely upon your feedback to help guide the prioritization of our product improvements, and Suggestion Box is a critical tool for us to understand and prioritize our customers’ needs.
Viewpoint reviews Suggestion Box regularly for all of our products and updates statuses, adds comments, and performs various house-keeping (including deleting) as needed to ensure that Suggestion Box is maintained as a productive environment for product enhancements requests.
© 2023 Trimble Inc. All Rights Reserved. Viewpoint®, Vista™, Spectrum®, ProContractor™, Jobpac Connect™, Viewpoint Team™, Viewpoint Analytics™, Viewpoint Field View™, Viewpoint Estimating™, Viewpoint For Projects™, Viewpoint HR Management™, Viewpoint Field Management™, Viewpoint Financial Controls™, Vista Field Service™, Spectrum Service Tech™, ViewpointOne™, ProjectSight® and Trimble Construction One™ are trademarks or registered trademarks of Trimble Inc. or its affiliates in the United States and other countries. Other names and brands may be claimed as the property of others.