limelect

@Dalija PrasnikarLet me point a few things In the old days, ver 7 was very stable and I am still happy to use it on some old projects. As of today, 10.2.3 is very stable and I am glad to use it. As for Android "Android Studio" give me a solution even with the old OS on the new phone. I do not need to have the new update (although I do) to work on a new phone. With Embarcadero I have to pay lots of $ and still not satisfied. Android Studio is free. And works almost without a glitch. After my experience with D.4.2 I will definitely not evaluate 11 (maybe I will change my mind) to be sure that the product is not perfect. I do not expect 100% as we are all in the software business and we know what is all about. But to have a bad product like D4.2 is totally unacceptable.

No, sorry to say that what you think is that 10.4 is buggy that why we have 11? Sorry, I do not agree. With all those software guys it should have been almost good. I do not say that a big company is free of bugs. But to have such a product (10.4) from Embarcadero is bad practice. And they will not survive.

Let me clarify some things. First, I love Delphi. I am with it since #1 Yes, I am grown by now. For windows, it is a great product. However, for Android it is bad. Huge application size. I love its IDE. I have been working with Android Studio and I hate its IDE However small application size and it works without a glitch. No matter which phone I take it works. Its software language (java) is fairly complicated. Not the java itself. Java is OK but its use for Android development is complicated. But compere to Delphi it works without any problem. I which Embarcdero takes some of us, users, into consideration and thinks of the future if they want to keep existing.

Whoever downloaded the document projects There is VER 3 with lots of fixing and new pages that I added All for my need and yours. https://limelect.com/downloads/document-projects/

@Anders Melander Got it finally thanks. Until next time

@Anders Melander In the third party list there is no way to add mine. See for yourself. Try to add something. "I made this" sound more logical.

@Anders Melander There no way to put it there. see for yourself

On portableApss free and great SQLiteDatabaseBrowserPortable https://sqlitebrowser.org/

Return to my filter but with date and time My basic statement that worked is ProjectsFDTable.Filter :='MyDateTime = {d ' +FormatDateTime('yyyy-mm-dd ',AdvDateTimePicker2.Date)+'}'; The problem I want to filter only date AdvDateTimePicker2.Date BUT MyDateTime has date and time. !!! I know of {fn CONVERT(MyDateTime,DATE)} I did not know where to place it in my basic function. My solution that works (BUT I DO NOT LIKE IT) is: ProjectsFDTable.Filter :='MyDateTime > {dt ' +FormatDateTime('yyyy-mm-dd ',AdvDateTimePicker2.Date)+' 00.00.00 }'+ ' and MyDateTime < {dt ' +FormatDateTime('yyyy-mm-dd ',AdvDateTimePicker2.Date)+' 23.59.59 }'; Which is date+time > and date+time < in beetwin. Any better idea? In SQL the above {fn CONVERT(MyDateTime,DATE)} works.

@Hans J. Ellingsgaard It is a fairly large program with many sections Some with SQL and some table. I did not want to start to redesign a large portion (maybe stupid but factual). @Serge_G Thanks

@Serge_G As per your suggestion with D10.2.3 ProjectsFDTable.Filtered := false; ProjectsFDTable.FilterOptions := [foCaseInsensitive]; decodedate(advdatetimePicker2.date,yy,mm,dd); ProjectsFDTable.filter:=Format('MyDateTime=%d',[yy*10000+mm*100+dd]); from f7 'MyDateTime=20211003' for 03/10/2021 Do not forget MyDateTime has date and time in it

@Hans J. Ellingsgaard read last line of my topic.

@ergeka I do not understand. The problem is "MyDateTime" which I have to get from it the date only. AdvDateTimePicker2.Date has nothing to do with the problem. AdvDateTimePicker2.Date has DATE only

I have done filtering in other databases with no problem. This time I am using FDTable, My tries ProjectsFDTable.Filtered:=false; ProjectsFDTable.Filter:='Category =' +QuotedStr('Tools'); OR ProjectsFDTable.Filter:='Category = Tools'; ProjectsFDTable.Filtered:=True; Category is the column Tools is the data The errors are mainly - Tools cannot be found as the Column <<<< how come? With the QUERY component I have no problem but for my reasons I want to do it with FDTable. Any idea PS. I tried with ProjectsFDTable.SQL nothing worked.

Read my comments above. It answers your question. It is in my question With the QUERY component I have no problem but for my reasons I want to do it with FDTable.

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?