Hi Everyone! My first post to the forum and my first project!
Being new to Gambas, I have got stuck on trying to use Gambas to create a front-end for a MySQL database created with MySQL Workbench. I have trawled the Internet without much success for an answer. The application that I am working on requires calculated fields. Using MySQL workbench the calculated field has been produced by using a MySQL query. For example: select quantity, price, (quantity * price) as subtotal from components order by quantity, price, subtotal desc Following a Youtube video showing how to "import" data held in a MySQL database into a Gambas front-end, the form is constructed using the DataSource and the DataBrowser options from the Toolbox. While the fields of "price" and "quantity" are shown, being obtained from the table "components", I have not been able to figure out how to source the calculated field i.e. quantity * price and its value (as obtained via the SQL query) in order to place it into the Gambas front end. e.g:- amount price subtotal 10 50 500 Any possible suggestions or reference to an available coding example would be greatly appreciated. Regards William Cape Town South Africa ------------------------------------------------------------------------------ One dashboard for servers and applications across Physical-Virtual-Cloud Widest out-of-the-box monitoring support with 50+ applications Performance metrics, stats and reports that give you Actionable Insights Deep dive visibility with transaction tracing using APM Insight. http://ad.doubleclick.net/ddm/clk/290420510;117567292;y _______________________________________________ Gambas-user mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/gambas-user
