MySQL: query with joining two tables

Posted on 7 December 2017 by pawel

50

In my last project had to compare two different tables. Table ‘itemsaldo’ contained whole warehouse stock and in table ‘holdlist’ were products blocked by Quality Department.

Continue reading →

Creation installation file in Inno Setup

Posted on 29 November 2017 by pawel

48

In Visual Studio Express Edition there is no possibility to create instalation file for our projects. There is not such a function? In order to create exe file help us Inno Setup Compiler. This is free tool to create installation files.

Continue reading →

Remote connection to MySQL

Posted on 24 August 2017 by pawel

281

Few months ago I’ve tested connection between Excel and MySQL database on local computer. Test hasn’t been performed with database located on external server – I think it should works too.

Continue reading →