Jump to content

Ian Branch

  • Content Count

  • Joined

  • Last visited

  • Days Won


Ian Branch last won the day on August 8 2019

Ian Branch had the most liked content!

Community Reputation

40 Excellent

Technical Information

  • Delphi-Version
    Delphi 10.3 Rio

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

  1. Ian Branch

    Alpha Controls support for LMD Tools??

    Anders, Yes, thank you. I didn't see any value in signing up to the forum if I wasn't going to use it. It also seems you have to be a member, purchased AlphaControls, to be able to raise a query. I had looked at the Alpha Controls Community for any hints but they were few and far between and only mentioned LMD some time ago and then only one component. Markus, Thank you. I was sort of expecting that as I couldn't see any mention in the greyed out listing in the 'Lite' version. Regards & Tks to you both, Ian
  2. Hi Team, Does anybody know if Alpha Controls supports LMD Tools? I use LMD fairly extensively and I won't invest in Alpha Controls if there is no support or only minimal for LMD. Regards & Tks, Ian
  3. Ian Branch

    Variation of FormatDateTime(

    Hi Remy, OK. You talked me into it. 😉 Regards & tks, Ian
  4. Ian Branch

    Variation of FormatDateTime(

    Hi Remy, Intended or not, my equation produces exactly the same as yours. See attached screen shot. The columns are - Start, Finish Yours, Mine. I am quite willing to accept that my solution is more good luck than good management. 😉 Regards, Ian
  5. Ian Branch

    Variation of FormatDateTime(

    Lars, For some reason your post is not showing att. The code is used once only when the User logs out so time isn't really an issue but I take your point. If the code was used more often I would certainly optimise it as you suggest. The User's Administrator has the ability to generate ad-hoc reports, but is somewhat illiterate with SQL. By adding the Duration to the table he doesn't have to figure out how to create it. Regards, Ian
  6. Ian Branch

    Variation of FormatDateTime(

    Hi Team, Thank you for your inputs. Appreciated. I have implemented the following.. FieldByName('Duration').AsString := (IntToStr(DaysBetween(FieldByName('FinishDateTime').AsDateTime, FieldByName('StartDateTime').AsDateTime)) + ':' + FormatDateTime('hh:mm:ss', FieldByName('FinishDateTime').AsDateTime - FieldByName('StartDateTime').AsDateTime)).PadLeft(12, '0'); This works exactly as I need. Regards, Ian
  7. Ian Branch

    Variation of FormatDateTime(

    Hi Team, Currently "FormatDateTime('dd:hh:mm:ss', EndDateTime - StartDateTime)" only allows 0-31 for the days. I am trying to subtract DateTimes that may be in the 100s to 200s of days apart and still want to represent the difference as just ddd:hh:mm:ss. i.e. 123:12:34:56 How can I do this please? Regards & TIA, Ian
  8. Ian Branch

    Registering GExperts after a build??

    Thanks Thomas. Regards, Ian
  9. Ian Branch

    Registering GExperts after a build??

    Hi Team, Is it necessary to de/re register GExperts into Delphi after rebuilding the .dll from the source, or is it sufficient simply to rebuild? Regards, Ian
  10. Ian Branch

    Key Combination to enter Edit or Insert mode??

    Hi Dany, Thanks for your input. Appreciated. Yes the table does have BLOBs, I will look into that aspect. I would be very disappointed if the User had clicked the edit button and it hadn't been captured. The issue doesn't seem to be endemic, just every now and then and certainly I haven't been able to reproduce it. I have put a couple of logging points in and re-published to the Customer to see if that produces any insight. Regards, Ian
  11. Ian Branch

    Key Combination to enter Edit or Insert mode??

    Sorry. To clarify, I am referring to standard DBEdit components.
  12. Ian Branch

    Key Combination to enter Edit or Insert mode??

    Hi Uwe, Hopefully none. In theory there is no way for the User to edit the fields until the Dataset is put in Edit or Insert modes. I have had a couple of error reports, I use EurekaLog, where the report is that the Dataset isn't in Edit or Insert mode, with the error happening when the User ostensibly clicks on Save/Post in the DBNavigator. This suggests that the User has edited a field somehow and then clicked Save/Post but there is no evidence of the Dataset being put into either mode in the trace. It has left me a little baffled. Hence the query about there being some key combination that the User may have stumbled on. Ian
  13. Hi Team, Given the relevant DataSource AutoEdit is False, and the only Navigator button option is Insert, and it isn't clicked, is there any generic key combination that could cause a dataset to go into edit/insert mode? I certainly haven't created one. Regards & TIA, Ian
  14. RE the monitor I am using - It is an AOC U2790VQ. The cheapest 4k monitor I could find. Oh the screen real estate I can now work in/with. 🙂 For what I do, they are ideal. I did have to update my old video card as it didn't have display ports to feed the monitor. Such a sacrifice. 😉
  15. Perhaps. I am running in 3840 x 2160. Having said that it doesn't retain its resizing between usages. I tried to set my monitor to 1920x1080 to test but Windows went all funny on me. 😞 I guess it will need someone with a a lower resolution to test. Ian