Jump to content

tgbs

Members
  • Content Count

    83
  • Joined

  • Last visited

Posts posted by tgbs


  1. 1 hour ago, mvanrijnen said:

    You'd better add calculated fields to the dataset, and use the OnCalcFields event.

    That way you can locally do then calculations,  

    Use a slight different fieldname for the locally calculated, or same and don't fetch the calculated fields in the query.

     

    This depends on the type of calculation.
    If there is programmer logic then oncalc event is ok. If it can be considered from the database then better to use syntax from the relevant sql database. No need to run another request/s to read data and calculate. A stored procedure can be used in the main query if it will be used frequently and has more complex logic.


  2. When join is only for checking(not selecting column) better to use EXISTS.

    Can you sum debit and credit in one select ?

    Input parameter ACTIVEYEAR better be integer


  3. On 7/6/2022 at 6:44 PM, Remy Lebeau said:

    Although that is technically correct, that has no bearing on this issue.  Skrim is able to send emails in general, so they already have valid authentication.  The issue is just that some of the emails are being rejected while others are not.  That has nothing to do with authentication.

     

    Oops...Sorry, You are absolutely right

    One months ago at office we receive this error for some email. After resend all is fine. I think this is some new staff from Google, maybe first email to concrete mail account, after they change some things...I have no access to DNS records for domain and cannot verify dkim and others for mail server. From my personal domain never get this error.

    Quote

    gmail-smtp-in.l.google.com[108.177.119.26]
        said: 550-5.7.1 [xxx.xxx.xxx.xx ip] Our system has detected that
    this
        message is 550-5.7.1 likely unsolicited mail. To reduce the amount of
    spam
        sent to Gmail, 550-5.7.1 this message has been blocked. Please visit
        550-5.7.1  https://support.google.com/mail/?p=UnsolicitedMessageError
    550
        5.7.1  for more information.
        g31-20020a056402321f00b0042dce60161csi1041414eda.475 - gsmtp (in reply
    to
        end of DATA command)

     


  4. If there is an invisible column, the name of the next column that is not fully visible is not drawn

     

    screenshot_7.png.b0c1047c383083f7bcf39e8649e45c15.png

    If Second column is visible = false then

    screenshot_6.png.63876e7372145787013694eb680ab4aa.png

    This can be seen in the design time as well
    Delphi Alexandria with the update


  5. I read from web that Linux service are created via Fork() . But this cannot be used in linux containers. Because engine look for master pid and finish execution if it stopped.

    Is there any skeleton of such a program. I will use the application in a docker, which will be accessed through Nginx.

×