![Delphi-PRAXiS [en]](https://en.delphipraxis.net/uploads/monthly_2018_12/logo.png.be76d93fcd709295cb24de51900e5888.png){kind=logo}
Search the Community
Showing results for tags 'sql'.
Found 5 results
-
Help connecting D11.3 Community Edition FireMonkey Android app to Azure SQL database
GrumpyNoMore posted a topic in Databases
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. F... -
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...
-
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...
-
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 o...
-
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 *...
