skyzoframe[hun]

Now it has. https://docwiki.embarcadero.com/CodeExamples/Alexandria/en/SelectDirectory_(Delphi)

🙂

Hello, I need advice from all of you. I know I am not the only one who has got these problems. Maybe someone has already solved it. 1.-How to handle undo and redo in code? 2.-What are the best strategies for handling it in the relational databases (InterBase and Firebird)? best wishes, k.z.

The first step is solved, by using the update flag, creating a negative and positive ID with one trigger when inserting anything into the database. // interbase database // before insert AS declare variable COUNT_ID INTEGER;declare variable I INTEGER;/**/ begin COUNT_ID=0; i=0; new.TIME_CREATE=Current_TimeStamp; /* UPDATE_KEY -> default False! */ if (new.UPDATE_KEY=False) then begin /*when create*/ if (not exists( select * from MGR_SZABASZAT where ID>-1)) then begin new.ID=0; end else begin select count(*) from MGR_SZABASZAT where ID>-1 into :COUNT_ID; i=:COUNT_ID; WHILE (i>0) DO begin if (not exists (select ID from MGR_SZABASZAT where ID=:i)) then begin new.ID=:i; i=0; end else i=i-1; end /* WHILE (i>0) DO*/ end /*if (not exists( select * from MGR_SZABASZAT)) then*/ end else begin /*update*/ if (not exists( select * from MGR_SZABASZAT where ID<0)) then begin new.ID=-1; end else begin select count(*) from MGR_SZABASZAT where ID<0 into :COUNT_ID; i=:COUNT_ID+1; i=i*-1; WHILE (i<0) DO begin if (not exists (select ID from MGR_SZABASZAT where ID=:i)) then begin new.ID=:i; i=0; end else i=i+1; end /* WHILE (i<0) DO*/ end /*if (not exists( select * from MGR_SZABASZAT)) then*/ end end

Also, select some range and press "Ctrl+/" , it gives "//" to each selected line. Press again, and will remove it.

I found these.: https://www.tweaking4all.com/software-development/software-delphi/delphi-ide-code-editor-keyboard-shortcuts/ https://leanpub.com/codefasterindelphi

creativity the key, AI can not handle that...

ctrl+shift+c+left mouse press

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 :)

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

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.

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ő

Good to know.

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?

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.

how long is it valid for? a year?

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

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?

There are any other ways to handle unique identities?

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