Skrim

Does not work for me, The new version 11 is NOT listed, even after clicking Update. I have contacted Support several hours ago, no answer yet. This is not a nice experience. Ole

Database is PostgreSql. In a table I have: Customer Amount 10000 100 10020 110 10150 350 10000 -100 10300 200 I want to retrieve only customers where Amount is 0 (100-100=0), in this case Customer 10000. How can I do this using Sql? Thanks in advance. Ole

Thanks Stano Works great 🙂 SELECT customer, SUM(amount) FROM aTable Group by customer having sum(amount)= 0 Regards, Ole

D 10.4.2 and Win10. My program suddenly will not execute spesific parts of my program, but crashes. (No change in actual code) When that happens also the Delhi IDE crashes. There might be a file called XmlLite.Dll that causes this, but I'm not sure. The file is on my pc in several directories. Anybody else experienced this? Maybe reinstall Delphi? Regards, Ole

If you have a Postgres database and need to document it, this is a nice tool. https://www.yohz.com/dbdoc_details.htm Just a happy Customer.

Delphi 10.4 procedure TForm1.Button1Click(Sender: TObject); var i : byte; j : integer; begin screen.Cursor:=crHourGlass; try j:=30000; i:=j; showmessage(inttostr(i)); finally screen.Cursor:=crDefault; end; end; If I set i=3 then inttostr gives me 3 If I set i=3000 then inttostr gives me 184 If I set i=30000 then inttostr gives me 48 I thought 3000 and 30000 would raise an exception, as they are out of range?

Am I allowed to tip about a software program here, not directly related to Delphi, or is that considered spam? It's a little utility I think make my programming task a little bit easier. It's not made by me, nor have I any connections to the company.

Thanks, I thought they were set by default. Moral, don't take anything for granted 🙂