In the previous article found here: Sage 100 2013 ODBC Help I went over the basic function of using SQL commands with a Sage 100 system. In this article I will go over the advanced feature including joins. The first join I will show is what Sage calls the Cross Join:
In needing to write a small program for my company access data from our Sage 100 ERP I found documentation lacking concerning writing SQL commands for the Sage 100 ODBC driver. Here are are some commands that I found useful when writing SQL statements for Sage 100.
After giving the foundation for this in part one I will now show the steps and code for installing MongoDB v2.1.1 on the Raspberry Pi
The Raspberry Pi has reignited the computer/technology DIY crowd of programers, system hackers, and electronic aficionados seen in the early days of computers and amateur radio operators throughout the 20th century.