haentschman

Hi... The question is...why you want the imho old TSQL instead of FireDAC, UNIDAC, Zeos?

Hi... Question to Andreas: We can expect it?...sometime. Great Work...Thanks.

Hi... ...look here (in german):

Hi... Imho is the editor in the MSSQL studio a script...not a query. How about TFDScript instead of TFDQery? http://docwiki.embarcadero.com/Libraries/Seattle/en/FireDAC.Comp.Script.TFDScript ' + quotename(name,'''') + ' also in scripts you can use parameters

Hi... which you use?

+1 ???

Hi... ....please use every time SQL Parameters! Qry.SQL.Text := 'select Blubb from Bla where Date = :BDA'; Qry.ParamByName('BDA').AsDateTime := Now; See SQL Injection: https://en.wikipedia.org/wiki/SQL_injection https://de.wikipedia.org/wiki/SQL-Injection Then you will see that the DateTime problems will disappear. (Field in DataBase = DateTime)

Hi... the solution ist here... https://www.danielwolf.eu/blog/2015/1668-meine-vorstellung-einer-willkommens-seite ...slim and effective

...yes. What if your house burns down? All data that cannot be restored, especially the Delphi projects, must be transferred to the data center outside the house. (Webspace/Webserver)

Hi... Is this what you mean? ...the base folder for new projects? ...in german

Hi... i think ist confused. Please show the code of your program... Principle: 1: loop ( while not Database.Eof do ...from Query) 2: create Mail complete with sender, receiver (from database "FieldByName"), body (the same) ... procedure Send(Sender: string; Receiver: string; Body: string); 3: send Sorry...never use a click procedure...bad design. In the loop use .Open / .Close of the ICS component...imho.

this is named: learning by doing.

Hi... correspondingly: one dproj -> one repository Branches in the repository: Picture: master: unused release: new branch development: new branch #xxx: new branch for every feature -> then merge to development

Hi... Even if you are the only developer, you should have a ticket system. You can use it to create small "building blocks" for the project. Think of it as a "to-do" list, where you document which changes have been made for the one ticket. A small one is Mantis. https://www.mantisbt.org/

Hi... Last but not least...TortoiseXXX has in the Explorer overlayicons. I love it. You can see, which files/folders are modified. Especially the ones you haven't changed yourself...dproj.