Wednesday, January 16 2019
By George on Wednesday, January 16 2019, 08:30 - Python
I love any opportunity to solve a problem. Creating a small program to get it done, bring it on!
Using Turtle to plot G-Code.
Code chunks to follow.
Friday, November 16 2018
By George on Friday, November 16 2018, 15:33 - Critical Equipment
My link to critical equipment assessment.
Thursday, November 15 2018
By George on Thursday, November 15 2018, 07:49
to configure email to work with outlook365 and EM use the following settings Server name: smtp.office365.com Port: 587 Encryption method: TLS or STARTTLS (this will be set to explicit TLS in EM)
By George on Thursday, November 15 2018, 07:35 - Node-Red
Note and links links for me to revisit when I see something that may be helpful to me or others I communicate with.
By George on Thursday, November 15 2018, 06:33 - Report Development
I have found calculations and accessing variables not intuitive in the RAP environment so these are my notes to help eliminate some pain between tasks.
Basics: SQL = "Structured Query Langauge" Variable = "A container to hold a specific value, this could be an integer, string, etc.."
By George on Thursday, November 15 2018, 04:54 - Express Maintenance SQL
To get a good report out of Express Maintenance it starts with a good SQL query and how you join the tables to get the data you are looking for.
This example has several queries working together
To do that you first need to know what tables have the data you need.
JoinsFrom Code Project Website
https://www.codeproject.com/Articles/33052/Visual-Representation-of-SQL-Joins
https://stackoverflow.com/questions/448023/what-is-the-difference-between-left-right-outer-and-inner-joins
Inner JOIN
This is the simplest, most understood Join and is the most common. This query will return all of the records in the left table (table A) that have a matching record in the right table (table B). This Join is written as follows:
SELECT <select_list> FROM Table_A A INNER JOIN Table_B B ON A.Key = B.Key
Example: Table A is units and Table B is WorkOrders. The output would be all of the WorkOrders where the Units from Table A matched.
Left JOIN
This query will return all of the records in the left table (table A) regardless if any of those records have a match in the right table (table B). It will also return any matching records from the right table. This Join is written as follows:
SELECT <select_list> FROM Table_A A LEFT JOIN Table_B B ON A.Key = B.Key
Right JOIN
This query will return all of the records in the right table (table B) regardless if any of those records have a match in the left table (table A). It will also return any matching records from the left table. This Join is written as follows:
SELECT <select_list> FROM Table_A A RIGHT JOIN Table_B B ON A.Key = B.Key
Outer JOIN
This Join can also be referred to as a FULL OUTER JOIN or a FULL JOIN. This query will return all of the records from both tables, joining records from the left table (table A) that match records from the right table (table B). This Join is written as follows:
SELECT <select_list> FROM Table_A A FULL OUTER JOIN Table_B B ON A.Key = B.Key