Give Thanks! InFocus 1.4.1 has landed.
As with every release, be sure to back up your database before updating.
Project Management & Accounting Software for Architectural & Engineering Firms | Clearview InFocus
Hello Summer, Hello InFocus 1.4.0. This release brings many additions, performance enhancements and bug fixes.
Once you have run the update, you will need to rebuild the invoices using the Utiltiles / Invoice Design / Rebuild All Invoices option.
As with any major release, make sure you do a database backup prior to upgrading.
This flow chart represents the functional data areas that drive the Infocus basic accounting subsystem.
Read More…
This flow chart represents the functional data areas that drive the Infocus invoicing subsystem.
Read More…
What is SQL?
SQL stands for structured query language and has been around for decades. The primary purpose of SQL is to retrieve and store data from and to a relational database. The database server, itself, must be SQL compliant and while there are many providers of SQL servers the only ones Infocus works with are Microsoft SQL 2005 and Microsoft SQL 2008.
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…