Jump to content

Dany Marmur

  • Content Count

  • Joined

  • Last visited

  • Days Won


Everything posted by Dany Marmur

  1. Dany Marmur

    Recursive S.Proc

  2. Dany Marmur

    Filter on InternalCalc field

    You should peruse the documentation and sources of your chosen DAC (Data Access Components). The TDataSet base class does not implement very much at all.
  3. Dany Marmur

    SMS via my phone..

    I can see the merit of this. The end-user would like to send SMS's from the phone's subscription. It will probably be a more personlized message compared to using an SMS service and not as prone to false positives (in the recievers head, i will not click that!!). I have an SMS service for 2-phase auth, it was simple to write the API calls. Some services can probably change the "sender", i do not have my head in this atm and i do not know how it would look to the reciever. However, the technical issues seems a bit messy considering all the different phones. Perhaps the platform (Windows, MacOS) has something for the users phone, if there's an API for "connect your phone" thingies? Decades ago i had the same "conundrum" regarding e-mails. I wrote a routine to have Outlook create one mail per recipient. However, after several years had passed, the client realized that the audience of these messages did not care so they find it much simpler to paste the e-mail list from my system into outlook/any e-mail "to" field.
  4. Dany Marmur

    git and Delphi tooling?

    @Ondrej Kelle, ooof!!! Too tired now, on it tomorrow. I think you deserve your buckle now anyways. !! 🙂 🙂
  5. Dany Marmur

    git and Delphi tooling?

    Me too. Do you know if it is possible to select a range of committs and inspect the difference between first and last for a file? I have not been able/had time to figure it out.
  6. No... specifically audit/monitor (by SVN or such) your dfm's to make certain that no component stored ANY sensitive/test info in a property. The decision design-time vs runtime should be begotten in completely different contexts.
  7. I have seen components during the decades that either stored something sensitive or gave the dev an option to store such things. Imagine upgrading a project from say 15 years ago. The concepts of security over all vectors were much different. Time to delivery might have "affected" even older 3rd party libs to expose something considered "folly" today, but not back then. So - i am for recoding a 15 year old app in stead of trying to upgrade all those pesky parts and pieces. So to agree with the post above, equalizing Delphi with lesser security is complete folly. Like "you used the wrong hammer when you build our door, that is why the thief could steal from us". Also, as an aside, Delphi is one of the best languages/RTL for creating viruses because of it's great span from machine code up to RAD components so the "hyped" users/procurators out there may be biased by false virus positives too.
  8. Dany Marmur

    From Interbase To Firebird

    Agreed, IBExpert have a lot of nifty tools built-in. But the price man! No "single dev" licence, one per machine 😞
  9. Dany Marmur

    From Interbase To Firebird

    Since the IB version has some mileage, i would definately try to make a gbak backup (transportable) and try to restore it in FB 3.0. Otherwise i suspect som isql scripting for the metadata and some home-made transfer app.
  10. Dany Marmur

    grid with expandable area below each row?

    They call it "preview" and i agree, it is impossible to have it work properly for en users. IIRCC it was implemented way back to mimic Outlooks e-mail list. The other way to edit records is something they work on constantly IMHO, the new LayoutView and more. Even a carousel (!?). But i so so agree, my users do not want that. It's messy. Oops! You supplied images after i posted. Cool, anders! I put a master and then details in other grids (more classical). If i have fields that are absolutely not suited to go into the grid, i link a static DBAware control to the DataSet and column. For me that is mostly good enough. Also, making it so that only visible data is fetched is much more simple (IMHO) with my "design". The fields in the red square are connected to the same DataSet as the master grid on level 1. I would put something under the detail the same way, (would be the green one for "Costs").
  11. Dany Marmur

    Comm.Table Exp. In S.Proc

    It is even better to know one can be of help than being helped 🙂 do click "thanks".
  12. Dany Marmur

    Comm.Table Exp. In S.Proc

    If you want to emit more than one "row" from a stored procedure, you will need to use: FOR <SELECT CLAUSE> INTO <PAR_LIST> DO BEGIN SUSPEND; END However, the error message indicates you have a problem in the join clause (not 100% sure). So i have made a procedure that works in Firebird 3.0 (i do not have Interbase, so this might not work for you). create or alter procedure TEST_OUTPUT returns ( TMONTH integer, TOTAL numeric(18,2), MONTH_NAME varchar(26)) as begin for with cte (tmonth, total) as ( select extract(month from pt.prj_actual_date), sum(pt.prj_actual_amount) from prj_trans pt where pt.prj_account_no = 13 group by 1 union select extract(month from pt.prj_actual_date), sum(pt.prj_actual_amount) from prj_trans pt where pt.prj_account_no = 10 group by 1 ) select cte.tmonth, tm.monthname, sum(total) from cte join test_months tm on (tm.monthnum = cte.tmonth) group by 1, 2 into :tmonth, :month_name, :total do suspend; end My "prj_trans" table does not have a "month number" so i did an extract for the cte, it is just what i had "at hand". I added a test_month table to be sure only one row is generated for each month (could be a cartesian product in your SQL, not sure) but the error message indicates that you coded for one row but got more, so it will not hurt to check your join. The output is as expected now (12 rows, monthname and amount). HTH, /Dany
  13. Dany Marmur

    Interbase 2007 ->2020

    The legacy way of upgrading ODS is: Make a *backup* of the DB file with the older ODS (On Disk Structure). Then *restore* the database using the new version, the ODS will upgrade. BUT: Regarding IB i do not know whether you can make the backup using the new server or if you must use the old server version. IB may even have command line tools to upgrade, i do not know. HTH
  14. Dany Marmur

    Help with IBObjects, Interbase 7.5 & Delphi 10.4

    No. No. IBObjects' charset handling is definitely on par with any other DAC. Contact the vendor for support. Source changes *will* bite back. Do you really know that much about IBObjects?
  15. Wow! +1 to Lars for asking the question that i should have asked for ages now. +1 to ByteJuggler for presenting the exact "problem" i have and the solution. I love this forum.
  16. Dany Marmur

    Help with IBObjects, Interbase 7.5 & Delphi 10.4

    Did you solve your problem?
  17. OK, me again in a needy mood ... I tried to search here and there and... somewhere... but. I am looking for resources pointing to a "modus" to first off measure what takes what time when my exe is loaded. So some kind of writeup of the different stages and dfm-resources and other resources. Or perhaps using a profiler and understanding what it reports. Then after having mapped "sections/scopes/what-not" during application load, i would like to move on to resources with hints on what can be done. Of course, for such endeavours some properties are significant about the project itself: VCL 32/64 bit DevExpress BarManager/Ribbon/Layoutcontrol/GridViews/PivitGrids/Skinning/Scrolling/Painting and then some... FastReports... RTC... IBObjects (think a really tight and well working FireDAC with sources but only for FB/IB)... madExcept... kbmMemTable... I think those are the focus points in this project. TIA, /Dany
  18. Dany Marmur

    How to optimize exe loading times

    Most definitely. But i did not know that when i started the tread 🙂
  19. Dany Marmur

    Can't edit my post?

    @Mahdi Safsafi, @Kas Ob., happens here a lot! For me it works when i reload the page (chrome, yes). Then my edit is "kept" and the navigation and editing works again.
  20. Dany Marmur

    How to optimize exe loading times

    @Mike Torrettinni, it seems to be due to hard use of the DevExpress LayoutControl. Sampling Profiler points there, running instrumenting during dfm loading has been a little tricky. Sadly i have had to put this issue back for a while.
  21. Dany Marmur

    TIdSSLIOHandlerSocketOpenSSL and TLS 1.3 ?

    For mission-critical stuff, n/software. €1200 / annum. But don't you guys spend that anyhow? In lost working hours?
  22. Dany Marmur

    DevExpress FMX Grid

    Not very surprising.
  23. Dany Marmur

    Zeos 7.3 entered the beta phase.

    Is it feasible to replace an edge memory-table component (i.e. TkbmMemTable, TClientDataSe, TFDClient...) with this library? Does it contain a good TDataSet-based memory table? TIA, /Dany
  24. Dany Marmur

    How create a website whit Delhpi

    Delving strategic suggestions on a non-detailed request can only be done by people with an invested interest in what is suggested. I just coined that - no shit!
  25. Dany Marmur

    How create a website whit Delhpi

    Except for mine, as i felt the need to ask for specifics. Good point.