Jump to content

mvanrijnen

Members
  • Content Count

    492
  • Joined

  • Last visited

  • Days Won

    1

Everything posted by mvanrijnen

  1. Went to the enumwindows solution, more solid. thxn guys for the tips.
  2. yes, looking into that now. i'm testing a combinantion of things written here in this thread.
  3. thnx, was the most simple solution for me!
  4. No, sorry i'm not clear πŸ™‚ The traybar app would need to know, when its activated which window in windows was active. So if i have notepad open and selected, and rightclick my traybar app, i need to have the handle to the notepad window, if i have also another app open (e.g. calc) and selected, and rightclick my traybar app, i need to have the handle to the calc app,
  5. mvanrijnen

    Pos, SplitString

    Yes, most DB components do, i did abuse (years ago) with some specific software to calculcate expressions, i just send them to the dbserver, and that did the calculations for me. SELECT (1+4)*5 AS result FROM dummytable ROWS 1 TO 1 now days i opt for a different solution πŸ˜‰
  6. Would be nice to have a written transcript also. Many people (or at least one πŸ™‚ ) prefers reading this kind of stuff instead watching youtube. Also no speakers connected at work to the computer.
  7. mvanrijnen

    Pos, SplitString

    Would the query component know what type after a .Prepare statement ?
  8. In the contract (we haqve with the sales company, barnsen), is stated: - The yearly maintenance contract includes all new version udates, maintenance upgrades en technical support. So i think under maintenace upgrades, many people (including me), will think that will be some patches/maintenance of known bugs in xx old versions backwards, so you can build your developed software with a less buggy develop environment.
  9. Yes, that was one of the big reasons here to take a subscription (for us). Maybe they find the patches not important enough, same reason they choose too keep absolute radio silence to their users about things. (with their level of communication, one would think that EMB is run by the CIA : ) ).
  10. Would be nice if they would patch 10.4.x also 😞
  11. mvanrijnen

    Any good replacement for Indy email?

    FIrst, which email components ? Which failures ? Which false negatives (if this is virusscan/spam detection, has nothing todo with indy itself, but how you use indy) Maybe your having troubles with the latest development of microsoft, they are pulling out old TLS versions. see: Preparing for TLS 1.2 in Office 365 and Office 365 GCC - Microsoft 365 Compliance | Microsoft Docs (just as info not a solution) you have any logging of the failures?
  12. mvanrijnen

    Moving from Per Monitor V1 to V2

    no answer but just for to be clear, your talking about this: Per Monitor V2 - RAD Studio (embarcadero.com) ?
  13. mvanrijnen

    Delphi 11.0 has a different form Caption offset than Delphi 10.4

    strange, delphi is not drawing these forms itself? vcl is just a door to the underlaying windows api? or does this depends wether you'r using vcl styles or something similar?
  14. mvanrijnen

    Any good replacement for Indy email?

    Yes, but not with Crosstalk, i just made an Com library in VS Community, just imported the tlb into Delphi and it works. I did not know that EWS was that old, have to take a look into it. I see we're supposed to work with Overview of Microsoft Graph - Microsoft Graph | Microsoft Docs instead. For now it works for us with the EWS. (i do that for more thing this way, because there's so much more available in .net these days) I'm sure going to take a look at AtoZed CrossTalk, never heard/read of it πŸ™‚
  15. mvanrijnen

    Any good replacement for Indy email?

    Here the same, only for O365 i have build a "proxy" in C#, we use EWS for that now. (Exchange Web Services (EWS) Managed API reference | Microsoft Docs)
  16. mvanrijnen

    Any good replacement for Indy email?

    Can't you be a little more specific which problems you'r having with Indy ?
  17. mvanrijnen

    D11 - A bridge too far.. :-(

    main problem is that we have now a buggy D11, but they don't look back and fix the D10 version, there a lot of bugs that they could fix, but they just don't. i thought part of the subscription program was that they would fix bugs from a previous release. They entered a path where they never gonna get a (reasonable) bug fixed product. very very disappointed.
  18. mvanrijnen

    SQL date problem

    yes, you'r right, i think it's because this: i got cought up in that. So what i can see is that intenral in his code he's storing the dates as strings, got a little bit mixed up with the DB, easy, easy, easy, take a breath.
  19. mvanrijnen

    SQL date problem

    Okay, so you DB is ok, it's a DateTime field (or timestamp field), then the main problem is probably the storage in the tree, is this a visual treeview thing? best is to take a look at that, if you can improve the storage of the datetime value with the tree item, and keep a record or a pointer to a class instance with the correct data, so you can use your file datetime as a real datetime, then you won't have the problems with the strtodatetime thing when quering the database. it's only a tip, or let's say positive critisism πŸ˜‰
  20. mvanrijnen

    SQL date problem

    then use the function DateTimeToStr and StrToDateTime with the format options, already mentioned before. i would be sure then, to keep a fixed format in the database if it has to be a string like YYYYMMNNHHNNSS, or use ISO8601 to store and retrieve. but keep the points of conversion as minimum as possible, there will be a point where it's gonna bite you, been there, done that πŸ™‚ But at the end, it's something you have to figure out yourself. I would go back and take a look if you can change the >>> DateTimeToStr(FileInfo.TimeStamο»Ώp)); >>> this to tree > to DB to FileInfo.TimeStamp----->Database ------>Visualize DateTimeToStr()
  21. mvanrijnen

    SQL date problem

    Why keep converting a Date(Time) to a string, keep it a a date and let FireDac worry about the conversion to the correct db format. (as said before, keep away from datetime to string conversion (or viceversa) with something like this) What code you now have, the whole SQL statement and the assignment of parameter values?
  22. mvanrijnen

    SQL date problem

    take a look at: System.SysUtils.FileDateToDateTime - RAD Studio API Documentation (embarcadero.com) (assuming you get the filedatetime with a standard delphi function).
  23. mvanrijnen

    SQL date problem

    just for the example: var myDate : TDate; begin myDate := EncodeDate(2021, 10, 3); .... // Make sure that myDate only contains the Date part, even when you declare a var as TDate it still can contain a time part !! // so thats why i make sure in the assignment, it depends on you own code if you need the DateOf() here. FDQuery2.Params.ParamByName('MyDateFrom').AsDate := DateOf(myDate); FDQuery2.Params.ParamByName('MyDateTill').AsDate := IncDay(DateOf(myDate)); ..... end;
  24. mvanrijnen

    SQL date problem

    haha, the StrToDate shit, is just taken from the topicstart, ofcourse in realworld we do not use this in realcode.
  25. mvanrijnen

    SQL date problem

    FDQuery2.SQL.Add('Select * from Projects'); FDQuery2.SQL.Add('WHERE MyDateTime>=:MyDateFrom'); FDQuery2.SQL.Add(' AND MyDateTime<:MyDateTill'); FDQuery2.SQL.Add('ORDER BY MyDateTime'); FDQuery2.Params.ParamByName('MyDateFrom').AsDate := StrToDate('03/10/2021')); FDQuery2.Params.ParamByName('MyDateTill').AsDate := IncDay(StrToDate('03/10/2021')); FDQuery2.Open; please keep forum in english.
Γ—