The select statement is a single organized statement that has distinct sections (called clauses) in an exact order. A select statement returns a single set of columns and rows known as a dataset. A dataset can be thought of as a two-dimensional spreadsheet. The following sections are the most commonly used. They are listed in the necessary order.
Read More…
Project Management & Accounting Software for Architectural & Engineering Firms | Clearview InFocus
In the previous lesson we learned how to query data from a single table. In this lesson we will learn how to retrieve data from multiple tables. We do this by using what is known as JOINS.
In this lesson our examples will all revolve around querying for project metrics. In order to do that we need to learn the UNION clause. The union clause allows us to take two or more SELECT statements and return them as one dataset. The rule for UNIONS is that each of the select statements must bring back the same number of columns and each column in the order listed must have the same data type . The first example will bring back cost for all projects. In order to bring back cost we need data from the timesheets and three journals; employee reimbursable, purchases and disbursements. This example will bring back the transaction ID, the cost amount, the journal of entry, the project path and the project long name. The project being returned is the top level project node in the WBS.
Behold, we bring you good tidings, and InFocus 1.3.9. This particular release focuses primarily on bug fixes and performance enhancements.
READ FIRST — You will need to run Rebuild All Invoices after applying this update. The option can be found in the toolbar of the Invoice Design applet located in the Utilities module.
New security features have been added in this version. This means that you may need to go in and set some new permissions once you update. This document contains a symbol to designate the new security items.
Read More…
Since you’re reading this blog post, you’ve probably noticed that we have a brand new web site! We’d like to thank the guys over at Viewchange and Out:think for their help in getting the new site up. So…thanks, guys.
Also, I wanted to take a minute to mention what’s new. First off, this blog is new. We are taking a big step here at Clearview as we venture into the blogosphere. So, be sure to check back often as we will begin posting various tips and other “how-to” type articles. Also, we will begin posting the release notes for future versions of InFocus here for continued easy access.
One more thing…it’s been a busy (and hot) summer here at Clearview. While we’ve been working hard on the new site, we’ve also been hard at work on InFocus 1.3.8. It’s nearly complete, so look for it to be released later this summer.