skyzoframe[hun]

I mean in delphi. for example.. ctrl + shift + c , on procedure or function yougot there, what you wrote there. anyway alt+f4 are the best all the time :)

🙂

3 minutes ago, Squamis said:

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.

 

I have no clue.

Try to handle everything over stored procedures in database side.
In code  call the procedure.

https://www.postgresql.org/docs/current/sql-createprocedure.html

1 minute ago, Squamis said:

 

Try TableName like t1$t2$t3 

Yes it is working... https://dbfiddle.uk/OrzyibpI

var
	Q : TFDQuery;
    .
    .
    . 
Q.SQL.Text := ('select * from TEST$TEST_;');
Q.SQL.Text := ('select * from TEST$$TEST;');

Hmm... strange, because it is working for me. Also in command line.

https://dbfiddle.uk/eDOCApeX

hi, check here one solution, how to use Listview in fmx.

3 hours ago, Mike Torrettinni said:

I think the last updated exams were in 2011,

Good to know.

2 hours ago, Roger Cigol said:

b) it gives you areas that you can focus on to learn more and hence stimulate your mind and perhaps become a slightly better more experienced programmer.

yes, this is the reason, from one point of view.

After a while, I read these kinds of books. From  2016.

- Expert Delphi By Paweł Głowacki
- Delphi High Performance By Primož Gabrijelčič

- Mastering Delphi Programming: A Complete Reference Guide By Primož Gabrijelčič
- Delphi Cookbook - Third Edition By Daniele Spinetti, Daniele Teti
- Delphi Programming Projects By William Duarte
- Delphi GUI Programming with FireMonkey By Andrea Magni
-- by Dalija Prasnikar
Delphi Memory Management for Classic and ARC Compilers

Delphi Event-based and Asynchronous Programming

Now reading.: Delphi Thread Safety Patterns

Because I am far from intelligence. I have to read. ˇˇ Are there any good books to read? What did I miss?

22 hours ago, haentschman said:

(exam time: ~1 hour)

How many questions do we have about the basic certification?

If the test time is about 1h and there are 120 questions available, every question has 1/2min to focus on it. So the exam will be lightning-chess or something.

25 minutes ago, haentschman said:

The Developer certificate is only valid for a limited time...

how long is it valid for? a year?

53 minutes ago, haentschman said:

...what you want?

The first one, do you have it already 🙂 // Delphi Certified Developer

Hi everyone,

I need the certification, because of my family. They saw me all the time reading and working in front of my computer. My deadline is one semester.

I want to ask for some advice before I buy anything.

How should I prepare?
What can I expect?
What is your experience?

Sincerely Zoltán-Attila Köllő

19 minutes ago, limelect said:

Right now from my point of view as a programmer, I catch the screen of a

program as a picture copy to clipboard saves to ADVrichedit so simple. 

https://download.tmssoftware.com/Download/Manuals/TMS TAdvRichEditor.pdf

Or you can store pictures on a local drive, and only the picture name has to be in the database. Or use a custom table for blob fields and call only when you have to show the picture.

I don't understand: why do you need so many big files, or blobs, in your database?

by the way.:

They are the same drawings in different file formats. If I need to save something in database, I'll use a *.emf file.

I only have one question: Can you reduce the file size somehow?

21 hours ago, Lars Fosdal said:

Basically, it is an automatically incremented integer value which uniquely identifies the row, without having any other relation to the data in the row.

You use these identity fields as primary keys for efficiently joining tables, and as unique id's for doing updates and deletions.

There are any other ways to handle unique identities?

4 hours ago, Lars Fosdal said:

Basically, it is an automatically incremented integer value which uniquely identifies the row

How do you solve the limit of integer range? What are you think about not "basically way"?

CREATE DOMAIN IMAGE AS BLOB SUB_TYPE 0 SEGMENT SIZE 2048;

After that, you can call your domain. You don't need to definite everything when creating your database table. I really like to use domains.

 'CREATE TABLE IF NOT EXISTS ENTRY( '+
    'Title VARCHAR2(60) NOT NULL, '+
    'UserN VARCHAR2(40), '+
    'Passw CHAR(64) NOT NULL, '+
    'URLpa VARCHAR2(100), '+
    'NickN VARCHAR2(20), '+
    'CustN VARCHAR2(20), '+
    'Notes VARCHAR2(400), '+
    'DateC DATE, '+
    'Icon IMAGE)'); 

select codes, count(*) as duplicate
from data1
group by codes
having count(*)<>1
order by duplicate desc

https://dbfiddle.uk/nYtX1oTz

15 hours ago, BennieC said:

TListview item programmatically to display the image.

Does it mean you want to create at runtime everything? Without using Live bindings?

If you want to separately manage Types, Front-End, Back-End.

Check the zip file at the bottom.

if ContainsText(LInput, ' ') then  LInput := StringReplace(LInput,' ','',[rfReplaceAll]);

Maybe you have to remove the SPACE character, before you put everything into array.

I got the answer. 42.

I dont know what are you talking about. What is your question? In one sentence..

Hi, I like to use it in this way.: (here you will find example files)

I think the best book for generics.: Pawel Glowacki (RIP) - Expert Delphi

How to separate units, back and front end, types etc..