Jump to content

Stano

Members
  • Content Count

    888
  • Joined

  • Last visited

  • Days Won

    7

Everything posted by Stano

  1. I don't know, but I'm filling in a few hundred spaces I'll finish it tomorrow. Preview: Clean Code enthusiast probably would point outavoid disinformation, but it allboils’ downs to names could lead developersin a wrong direction, because developers end upwith different understanding of a name.Think ofSetPosition not setting current position ofa memory buffer, say in an instance of a class with a name containing the word“Stream”, to a new position passed as the parameter Value, butinsteadat the position of the memory buffer was set tothat value.
  2. Stano

    docwiki.embarcadero.com is not working

    For some pages it works: refresh the page after the error.
  3. I turned on grammar checking. I fixed, all the reds, I knew. It seems to me that there is a mixture of American and English English. Plus something Danish here and there. I don't know English. So the rest is up to another volunteer. Object Pascal Style Guide - Developers Guide EN.docx
  4. Toto sa tiahne celým textom. Skontroloval som to len s kódom. pozriem sa na to. If it weren't for PDF, I wouldn't put it together
  5. Personally, I only use it if the name of the argument matches another name. Unfortunately, Pascal Analyzer found me such matches very more. I'd rather be without them.
  6. Here is a modified version of docx. I didn't do anything with the content. Only with formatting. It was totally broken. If you use it, you do not change the styles used in any way. You break the whole document. This file can be found if you would like to do the translation. I did the translation into Slovak. I just haven't checked it yet. Unfortunately, I did the formatting twice. First for Slovak and then the original Object Pascal Style Guide - Developers Guide EN.docx
  7. Professional has FireDAC. But he doesn't have his * .pas
  8. Stano

    Syntax error in From clause

    PrimaryKeys are an internal DB issue. You have nothing to do with them. The user must not suspect that such a thing exists. I repeat: you must use the Generator to insert new PrimaryKeys. If you need to know the new PrimaryKey, then Get its value from Generator Use it in the new record and for your purpose. If something goes wrong, you throw it away!
  9. Add-on Packs have long been removed for FireDAC
  10. Stano

    Syntax error in From clause

    I don't want to read your entire code. Please be aware of one thing. This is a forum to help solve problems. Not distance learning. As said: read the DB manual Read some general book about DB Not to be bad: FB has generators. Study it Enter PrimaryKey using FireDAC. You will find it quickly You can specify PrimaryKey using MyQuery.SQL.Text: = 'INSERT INTO USERS' + 'SELECT GEN_ID (DEPOSIT_ID, 1), CAST (: FKOWNERFLAT AS INTEGER), ...,' + MyQuery.SQL.Text: = 'INSERT INTO USERS' + 'SELECT GEN_ID (DEPOSIT_ID, 1), CAST (: FKOWNERFLAT AS INTEGER), ...,' +
  11. If I decide to put it here, I'll adjust the formatting first. This will take some time.
  12. Hard to say. His book as a whole was highly praised. They discussed one issue here. In my opinion, he could not agree with the opinion presented here. He announced that he had downloaded the book and did not respond. At the same time, everyone just wanted to help him. He wrote that the comment does not resist. I do not understand that. I personally offered the book so that the members could help him with professional proofreading. Not me I consider it a great pity
  13. I offer help. To author. My well-thought-out comments. Without reading a book: Format the * .docx file is appalling. If you want it, I will adjust it for you The CONTENTS field is not used. This is a problem with any change. Correction, addition of text. Translation Indentation. The book is also about that. Well, in the examples, it's probably in the mood. I can fix it At least there would be something useful here
  14. If you want, I can put a PDF attachment and * .docx. Perhaps the author is not angry.
  15. Stano

    docwiki.embarcadero.com is not working

    I voted. But I'm only third.
  16. Stano

    Enhanced messageboxes

    I TAdvTaskDialog from TSM
  17. Really. I didn't notice it. Well thank you.
  18. I read a quality book on the subject. (Perfect Code - Steve MCConnell - 2005). I still want to read yours. I don't know English, so I use google transaltor. If you have the text itself, it would help me. Now I need to copy the text from the PDF first. Remove unnecessary spaces. The add-on to remove them doesn't work for me. Only then translate. Then I'll send you a translated book. Although I don't know if he will be interested in Slovak translation (Czechs also understand him). If I find a shortage with blind eyes, I'll let you know.
  19. Stano

    Syntax error in From clause

    It depends on the purpose of use. If it is an embedded / local version, I recommend Firebird. There is no need to install anything. Just copy. Access is, as usual with MS, unlike other DBs. You will not acquire the right habits.
  20. Stano

    Syntax error in From clause

    Such a small tool class function TFDFunction.TextInsertInto(const ATableName: string; AllFields: Boolean = False): string; var FTable: TFDTable; sFields, sValues: string; Field1: Integer; begin FTable := TFDFunction.NewTable(nil, ATableName); if AllFields then Field1 := 0 else Field1 := 1; try // Without primary key. It is auto increment. sFields := ATableName + ' ([' + FTable.FieldList[Field1].FullName + ']'; sValues := ' VALUES (:' + FTable.FieldList[Field1].FullName; for var I := Field1 + 1 to FTable.FieldList.Count - 1 do begin sFields := sFields + ', [' + FTable.FieldList[I].FullName+ ']'; sValues := sValues + ', :' + FTable.FieldList[I].FullName; end; Result := 'INSERT INTO ' +sFields + ')' + sValues + ')'; finally FreeAndNil(FTable); end; end;
  21. My experiment (s) FMTSpace.UpdateOptions.UpdateTableName := 'DISTANCES'; FMTSpace.UpdateOptions.EnableInsert := True; FMTSpace.UpdateOptions.UpdateChangedFields := True; FMTSpace.Active := True; FMTSpace.CachedUpdates := True; /// Filling FMTSpace with data FMTSpace.ApplyUpdates(-1); That's how it works for me. I consider it extra work. for var J := 0 to FRecordCount -1 do begin for K := 0 to qryDistanceIns.Params.Count -1 do qryDistanceIns.Params[K].Values[J] := FMTSpace.Fields.Fields[K].Value; FMTSpace.Next; end; try TFDFunction.QryExecute(qryDistanceIns, True); finally FreeAndNil(qryDistanceIns); end; Unfortunately, the instructions and examples are more than brief. They are not complete. Thanks!
  22. Defining field types in MemTable and retrieving data using CopyDataSet is the easiest for me. Only now did I realize that I had written nonsense in Uwe Rabe's answer. I meant MemTable.Data := MyQuery.Data. No CopyDataSet. I apologise.
  23. You probably meant TFDBatchMoveTextReader
  24. I write here again that I am not a programmer. I seldom understand foreign code. The reason for asking the question: it's hard to find something, especially FireDAC, in help. Examples are: about something other than the topic very complicated incomplete, possibly with errors I couldn't find anything. I was successful later. I forgot to write it here. Thanks to all.
×