Search the Community

Hello everyone, My name is Andry RALIJAONA, I am a software developer based in Antananarivo, Madagascar, with more than 26 years of experience in software development, mainly with Delphi. Throughout my career I have worked both as a freelancer and as an in-house developer, often in remote setups, for clients in France, Switzerland, Belgium, and Madagascar. My main expertise includes: Desktop application development with Delphi Modernization of legacy code and migration to recent Delphi versions Database design and administration: SQL Server, PostgreSQL, SQLite, MySQL, Interbase, Advantage Database Reporting & BI: Crystal Reports, FastReports, Power BI, Power Query Automation: VBA, data processing tools System & server administration (Windows) What I am looking for I am open to remote collaborations as a Delphi developer, especially in: Developing new desktop or client/server applications Enhancing or maintaining existing software Migrating legacy Delphi systems to newer versions Integrating external services, databases, and reporting solutions If you have a project where my experience could add value, feel free to get in touch. 📧 andry.ralijaona@yahoo.com 📞 +261 34 77 297 27 CV ANDRY - ENG.docx

I am a hobby developer so I use CE. I have an Android app developed in the FireMonkey framework. I want to connect it to an Azure SQL database but I have found the Community Edition restrictions seem to prevent it. CE contains ADO components in the normal Delphi IDE but the FireMonkey IDE doesn't. FireMonkey in CE contains many of the FireDAC components but not an MSSQL driver. There are some 3rd party components but the ones I have found are too expensive for me. Does anyone know any way I can connect my Community Edition FireMonkey Android app to an Azure SQL database without paying hundreds of dollars?

I try using old FreeReport with new Delphi. Fr examples use BDE which is not in my new RAD. It uses BDE dataset and query. I am starting write own dataset. But still query. It seems to be problematic due to SQL interpreter. I can use other query, for example standard query with my dataset? Or can be standard TQuery but dataset must handle SQL?

Hi In Interbase, does anybody know how to use an expression in the "group by" clause, e.g.: select extract (month from HIRED_DATE) HIREDMONTH, count(*) EMPLOYEECOUNT from employee group by extract (month from HIRED_DATE) or select extract (month from HIRED_DATE) HIREDMONTH, count(*) EMPLOYEECOUNT from employee group by 1

Hi, I have searched for 'simple' stuff in using FireDac but havn't found the answer to the following, which would save me lots of keying ... I have a datamodule with a fdQuery & Datasource, and the fdQuery has the following: 'Select * from tTable where Company = :pC order by oOrderName' - so a parameter is created in the query. If in my code I want to set the query to different values do I have to do the select statement again in it's entirety, like: dm.fdc.Open( 'Select * from tTable where Company = :pC order by oOrderName', [ 'Debenhams'] ); Or can I simply specify the new parameter value like: dm.fdc.Open( '', [ 'Woolworths' );

Hi I'm having great difficulty in getting the syntax correct on a query I need to make via a Firedac Q!uery. Basically I want to set a WHERE clause that picks up all records that have a 'S' or 'R' in a certain field. In 'normal' SQL this codes like this: SELECT * FROM tTableName WHERE Status IN ('S', 'R') ORDER BY EventDate ... which works fine on the SQL Server, but how do I do this via a Firedac query? It may look something like this: qQueryName.Open('SELECT * FROM tTableName WHERE Status IN :pSR ORDER BY EventDate',[ ('S','R') ] ); The issue is how do I format the parameter - the above doesn't work, nor any of the different ways I can think of of setting the parameter to 'S','R'. Any help would be appreciated.