Squamis

Hello! I have some interesting situation. When I open form, you can see components alignment. After editing and saving - alignment restored See at attachments. My IDE has High DPI setted to "Automatic (Screen PPI)" What you can recommend for me? Thanks bds_M0015tHvQc.mp4

In this sample I can't find sample with using query with parameters

Next problem I very often use next type of queries select id from orders where id = any(:id) and set parameter like '{1,2}' for example but FireDAC can't recognize that paramtype I should rewrite sql-query like this select id from orders where id = any(cast(:id as bigint[])) but in this mode query freezes... What you can recommend for me?

Already 🙂 Thanks

Thank for all! Thank for your time! It is really fine solution fo me: DO $$ BEGIN INSERT INTO vdata.sides(fldside_art, fldside_name) VALUES('a','b'); INSERT INTO vdata.sides(fldside_art, fldside_name) VALUES('c','d'); delete from vdata.sides where fldside_art = 'a'; END $$ Tommorow I''l try "Array DML" and "TFDScript"

May be. But, I mean the next: I want in one TFDCommand component set several different queries, for example: insert into table1....; delete from table2...; and in code just run Qr1.Execute; I don't want create two TFDComponent.

No. I mean fully different queries. insert into table1....; delete from table2...;

Helllo! Last week I decided convert my big project from Delphi+PostgresDAC (PostgresSQL) to Delphi+FireDAC (PostgresSQL). I find a lot of interesting things: 1. I can't add several "Insert" sql-queries into one TFDCommand. I've tried to use delimiter ';' - nothing. I want to use one command Execute to run several queries "Insert". 2. Some SQL-query works in different way (about speed) in SQLManager works very fast in Delphi+PostgresDAC mode works very fast in Delphi+FireDAC mode - freeze select * from vdata."systems" where ((fldidxsystem = any(:fldidxsystem::bigint[])) or (:fldidxsystem::bigint[] = '{}')) only when I rewrite SQL-query - work very fast. select * from vdata."systems" where ((fldidxsystem = any(:fldidxsystem::bigint[])) or (:fldidxsystem::varchar = '{}')) Maybe someone have any answers about it?

Thanks

You are completely right!

Yes, I can use stored procedures, macroses, .... This topic just a question for understanding - it is a bug or we can do something! Just why a simple query can't be executed with standart functionality.

Try TableName like t1$t2$t3

Postgres?

This is the way that I select yesturday, after this topic. P.S. If it is a bug, how Embarcadero will know about it?

Also without results :(