Back in March, I requested some advice for using Basic4PPC to develop commercial desktop applications and Erel advised me to develop a prototype system and test it.
It took some time but I did just that and the results exceeded all my expectations. The response time for database queries is truly awesome!
I converted the SQLite wrapper to MySql in order to use high concurrency and an ACID compliant engine (InnoDB) and I have included a copy in the attached. I made no changes to the existing methods so that programs written for SQLite will also work on MySql by simply changing the connection open string. I have added a data adapter class but it does nothing more than return a data table at the moment.
My problem is the lack of data alignment in the Table control (you simply can't show a Profit/Loss Statement with left aligned numbers ). The ListView.dll by Filippo would work just fine but I cannot find any source code and the existing DLL only supports SQLite!
Is it possible to obtain a copy of the ListView source code or to prevail upon Filippo to include the attached MySqlDeskTop.dll?
Thank you in advance for your assistance.
Regards,
Ed Sharp
NB. Although the ExecuteTable only returns double or string (as per SQLite) the MySql database supports ALL datatypes as does ListView.
It took some time but I did just that and the results exceeded all my expectations. The response time for database queries is truly awesome!
I converted the SQLite wrapper to MySql in order to use high concurrency and an ACID compliant engine (InnoDB) and I have included a copy in the attached. I made no changes to the existing methods so that programs written for SQLite will also work on MySql by simply changing the connection open string. I have added a data adapter class but it does nothing more than return a data table at the moment.
My problem is the lack of data alignment in the Table control (you simply can't show a Profit/Loss Statement with left aligned numbers ). The ListView.dll by Filippo would work just fine but I cannot find any source code and the existing DLL only supports SQLite!
Is it possible to obtain a copy of the ListView source code or to prevail upon Filippo to include the attached MySqlDeskTop.dll?
Thank you in advance for your assistance.
Regards,
Ed Sharp
NB. Although the ExecuteTable only returns double or string (as per SQLite) the MySql database supports ALL datatypes as does ListView.