When using Sage 100 with the ProvideX database ODBC scalar functions can be useful in our SQL statements for date conversions, data check, and data manipulation.
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