limelect

Sure I am legitimate. Nice idea OOOpes i do not have FireDAC.Comp.DataSet.pas

Thank The project is on 10. P.S using your suggestion I get Error 104 mismatch exspresion

@Lajos Juhász D10.2.3 Read and see I did try it !!! My tries ProjectsFDTable.Filtered:=false; ProjectsFDTable.Filter:='Category =' +QuotedStr('Tools'); OR ProjectsFDTable.Filter:='Category = Tools'; ProjectsFDTable.Filtered:=True;

@Koru Do not forget thousand of computers are OK. This way will be too complicated to execute. I would scrounge my components and source. But maybe the computers we are talking about are in customer location then you have a huge problem of getting customer corporation.

@PrinzAxel You are correct with your assumption but if you have the problematic computer under your hand (Even though the program runs on many computers) I still go my way. (Unless the computer is far away). In my long long career with Delphi (since #1) I have seen things you cannot believe. Well good luck

@PrinzAxel I do not say that this is your solution but. When I have crazy staff to debug I copy the project and start by taking off staff from the project (compile) until I find the problem. Yes, I take off components and lines of code. I know it is hard work but no other choice. Some time components are hidden under some others. Look also at your DFM it might help too.

My record has a time date field. (This cannot change). Looking with a database program I see 2021-10-03 10:09:23.411 On my database grid, I see 03-10-2021 10:09:23 All above is not important. I put it for clarity. I have this FDQuery2.SQL.Add('Select * from Projects'); FDQuery2.SQL.Add('WHERE MyDateTime=:MyDate');<<<<?????? FDQuery2.SQL.Add('ORDER BY MyDateTime'); FDQuery2.Params.ParamByName('MyDate').AsDateTime := StrToDateTime('03/10/2021 10:09:23.411'); FDQuery2.Open; My PROBLEM I want to filter only the date 03/10/2021. Although I have also the time in the record. Any suggestion?

Ok thanks

As i said it is more then meet the eye. this is just part of the table FDConnection1.ExecSQL('CREATE TABLE IF NOT EXISTS Projects (MyDateTime DateTime,ProjectName TEXT,ProjectrealName TEXT,Category TEXT NULL,FileMask TEXT NULL,Description BLOB,FilesIndex INTEGER)'); (MyDateTime DateTime <<<<< Thanks in any case

Thanks

Becouse the whole project is more complicated then just one line of code.Sorry. That is a very simplified line of code

@mvanrijnen I am using FileInfo.TimeStamp where FileInfo: TSearchRec and >>> DateTimeToStr(FileInfo.TimeStamp)); >>> this to tree > to DB your knoledge ?

Well i will explain what I do and tel me that I am worng. I take FILE date time and put it in a DB. I guess every country has its format. (so I do not care) Then I SQL (search DB grid) Date. Thats it. why do I need this when I do not know where program will be used? function StrToDate(const S: string; const AFormatSettings: TFormatSettings): TDateTime;

@Fr0sT.Brutal Yes as my original question this answer it. FDQuery2.SQL.Add('WHERE {fn CONVERT(MyDateTime,DATE)}=:MyDate');

@mvanrijnen @Fr0sT.BrutalWhat is your suggestion then?. I know of the date problem month before day The above date is just for the test. However, in the real world DATE TIME will be stored in a database and taken from there. Is there any problem? you think?

@Josep Thanks it gave me a lead It is FDQuery2.SQL.Add('WHERE {fn CONVERT(MyDateTime,DATE)}=:MyDate');

@Josep No, it did not work D10.2.3 FDQuery2.SQL.Add('WHERE cast(MyDateTime As Date) =:MyDate'); FDQuery2.SQL.Add('ORDER BY MyDateTime'); //=''03/10/2021'''); FDQuery2.Params.ParamByName('MyDate').AsDate := StrToDate('03/10/2021'); I also tried ('MyDate').AsDateTime

Working with D10.2.3 I made a NEW TOPIC !! Start FMX project with nothing !!! JUST FORM !!! Run. Phone Android S21 " cannot attach to lwp 14777 no such process (3) exiting" changing <uses-sdk android:minSdkVersion="26" android:targetSdkVersion="26" /> to 26 did not help Now what? Any suggestions? Obviously, I am stack P.S I return C:\Users\Public\Documents\Embarcadero\Studio\19.0\CatalogRepository\AndroidNDK-9c_19.0.27659.1188\platforms\android-14 from 19 Now I got "class segmention fault (11)" I took off all uses except FMX.Forms still "cannot attach... " Guies be careful not to rely on Delphi 10.2 . I do not know what about above that. Luckily I have Android Studio

@Dalija Prasnikar S21 ultra is the most advanced Samsung phone on the market. If every phone I have to spend top $$$ to keep Embarcadero alive. This is not good. I am NOT going to change Delphi every time a new Android phone is out there. I am a private company that does not spend money as if I am Microsoft. I use Android Studio too without any problem except that after over 30 years I prefer Delphi IDE. Android Studio IDE is bad. But the choice between spending top $$$ just to be updated sorry I do not agree. So my next Android project will be Android Studio with all the sorrow of it. As I have no other choise. P.S can I download a command line compiler so I will compile a project up to date?

Last comment for your knowledge. APK's done with Android Studio workes on Samsung S21 without any problems. Delphi is great for Windows. I will still use it there.

Working with D10.2.3 (and plz do not sell me a new Delphi). My Android application worked up to my Samsung S6. Now I have a new phone Galaxy 21 and my application does not start. !. I made sure I have API 26. 2. I changed AndroidManifest.template.xml to <uses-sdk android:minSdkVersion="26" android:targetSdkVersion="26" /> 3. To make sure my application is OK i changed minSdk=14 build and run on S3!!! it is OK 4. Build and run application and made sure all my AndroidManifest.template.xml have 26. 5 still after running, I get " cannot attach to lwp 16457 no such process (3) exiting" Any help?

It will be my next resort In the meantime, I check some of my old programs on Android studio also there I found problems but fixing some As I have a large number of projects on both IDE. So it takes time Thanks any how

Still a problem but On the option, I changed the NDK to the max platform. It was 14 now it is 19 C:\Users\Public\Documents\Embarcadero\Studio\19.0\CatalogRepository\AndroidNDK-9c_19.0.27659.1188\platforms\android-19 So now I get "class segmentation fault (11)" problem Any advice on how to debug this?

@Pat Foley The program loads to the phone. See the icon see splash and program stops Does not even start form create

@Lars Fosdal How to do that "for the rights to access the API before use?" I think I checked all things. Like making sure I have the API 26 Checked min and max SDK OR I suspect that I do not use API 26 C:\Users\Public\Documents\Embarcadero\Studio\19.0\CatalogRepository\AndroidSDK-2433_19.0.27659.1188 Android 8.0.0 (API 26) is installed here I can see C:\Users\Public\Documents\Embarcadero\Studio\19.0\CatalogRepository\ platform 22 26 27 29 are installed So what else have I to do to ensure I am using 26?