MySQL++ Utilization
Mr. Arch Brooks, Software Engineer, Brooks Computing Systems, LLC authored this article.
Category: SQL
QT Tree View App
Our header file is below. [codesyntax lang=”cpp-qt”] #ifndef MAINWINDOW_H #define MAINWINDOW_H #include <QTreeWidgetItem> #include <QMainWindow> #include <QtSql> QT_BEGIN_NAMESPACE namespace Ui { class MainWindow; } QT_END_NAMESPACE class MainWindow : public QMainWindow { Q_OBJECT public: MainWindow(QWidget *parent = nullptr); ~MainWindow(); private slots: void on_pushButton_clicked(); void on_treeWidget_itemDoubleClicked(QTreeWidgetItem *item, int column); private: Ui::MainWindow *ui; void addRoot(QString cats, QString id1); […]
BCS Yii Populate Array With Database Content
To fetch an array containing database values the Yii active record facility offers a nifty solution for achieving the desired overall effect. [codesyntax lang=”php”] $sql = ‘SELECT * FROM slnk t order by t.lkn’; $query = Yii::app ()->db->createCommand ( $sql )->queryAll (); foreach ( $query as $row ) { ?> // […]
BCS ADO Support Replacement
The ActiveX Data Objects (ADO) has been useful in database management systems for connectivity and data manipulation. Many past application utilize this level of technology. Microsoft has announced that it will drop support for this ADO DBMS technology in the near future. I have decided to leverage the component architecture of Delphi’s Visual Control Library […]
BCS Select Distinct Date From DateTime
There are those occasions when the distinct date needs to be displayed from date time values. Considerable coding and displaying results via a list box control is one way to accomplish this feat. On the other hand you could let SQL handle the gory details. In an ADO situation the following statement handles the request […]