One issue supporting speculative purchasing strongly in a panel shop is an urgent project request. The ideal supported is, “There should be enough components available to assemble one standard panel.” Most major components can be acquired quickly. The caveat on acquisitions occurred strongly soon after the 2020 pandemic started. There were signs of material availability
Speculative Purchasing – The Problem (2) Read More »
The Requisition program was designed to do all of the work prior to issuing purchase orders. Issues to consider for purchase orders: Supplier Cost Correct component information – manufacturer, model, and description Supplier: A multitude of suppliers represent the same products. Establishing good working relationships with preferred suppliers helps with ensuring purchase order accuracy. Cost:
Speculative Purchasing – Inspection (3) Read More »
Find the SQL Server Management Studio (SSMS) icon and click to open. Detail 1: Find the SQL Server Management Studio icon and click to open. Clicking the icon will open a connection window. Detail 2: Clicking the icon will open a connection window (A). With the SSMS Connection window, if there are no databases attached,
Open the SQL Server Management Studio Read More »
Example 1b – Collecting the Unprocessed Requisitions Previously, the command ExecuteReader was used to collect a list of current projects because there was more than one record, along with more than one column. The same command will be used to collect a list of Requisitions by using the PK collected with the project numbers Referencing
SQL Command Executions : Example 1b Read More »
To date, the three most common execution commands used are ExecuteReader, ExecuteScalar, and ExecuteNonQuery. ExecuteReader can be used to retrieve a considerable quantity of data from the database. As its name implies, it is used to read the database by rows. Though ExecuteReader can return a single value, ExecuteReader may not be the best choice
SQL Command Executions : Intro Read More »
To date, the three most common execution commands I have used are ExecuteReader, ExecuteScalar, and ExecuteNonQuery. Reference the following detail for examples on using the three common SQL execution commands. As an example, the following will address the database tables handling information with the ExecuteReader method. The SQL Management Studio shows A: Table List, B:
SQL Command Executions : Example 1a Read More »
Incorporating a database in industrial programming allows for data retention and access. If the database is placed on the corporation server, back-up can be established by the IT department. Some of these examples will be on a local machine, such as a desktop or a laptop. Ensure the development machine has the following software installed.
SQL Server Database Startup Read More »
An understanding of the database tables will be developed herein. The following detail is a series of linked tables via Primary Keys referenced in stepped tables. Notice in Detail 1 below, the table in the top left is the beginning of the series of linked tables. Note the Primary Key is signified by the key
SQL – The Database Tables Read More »
Synopsis: An example of the usefulness of the function in programming. There are many sources and videos on the internet discussing the function. The function should be a single purpose program action. If the intent is to return more than one result, consider using a class. One aspect of a function is reuse of a
Visual Studio : The Function Read More »
Synopsis: Understanding how the Visual Studio Code View and Designer View function together. Visual Studio operates in a hand shaking technique. There are two layers commonly used with each form: The Designer View and the Code View. Programming with Visual Studio requires a basic understanding on how the data is processed between the two. The
Visual Studio : Handshaking Read More »
