limelect

FINALY I got it ProjectsFDTable.Filter := 'Category LIKE ' +QuotedStr('Tools'); Thanks everybody

OK and thanks . Guies am i stack?. which mean redesign with SQL I guess.

How come you have the source???? and I do not

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