We often look in the IDE for the function called column mode<\/strong> or search\/replace<\/strong> because we \u201cpaste\u201d (Ctrl+V) texts and then want to add something to the right and\/or left of it. THE multi paste<\/strong> is a superior way to resolve this type of situation, I like to call it a custom \u201cnecklace\u201d<\/strong> because you can customize it before the final result.<\/p>\n\n\n\n Let's take a better example, imagine you have the following query in your clipboard area:<\/p>\n\n\n\n You want to use the above query in your program, and in Pascal you will need to adapt it leaving it like this:<\/p>\n\n\n\n Using the\u00a0column mode<\/strong>\u00a0and\/or\u00a0search\/replace<\/strong>\u00a0you would add\u00a0Query1.SQL.Add('<\/strong>\u00a0to the left and ‘);<\/strong>\u00a0on the right But the multi paste<\/strong> solves the problem in a more practical way, see how:<\/p>\n\n\n\n Still in doubt? Watch the video:> https:\/\/www.youtube.com\/embed\/7mKy2h2GD5I<\/p>\n\n\n\n The example above was with a query, but think of any type of code that you need to copy and paste and then customize it to be useful within components that deal with code coming from other areas such as HTML, XML, JSON... transport into a component or concatenate it later. See this concatenation:<\/p>\n\n\n\n The usefulness of this\u00a0multi paste<\/strong>\u00a0is quite wide, make the most of the feature.<\/p>\n\n\n\n If you have doubts about the features, watch the video below:<\/p>\n\n\n\nselect a.razao_social, a.cnpj, a.endereco, a.end_numero, a.end_complement,<\/span> a.end_neighborhood, a.end_cidade, a.end_cep, a.end_uf, a.end_estado, a.end_pais, a.status, a.status_com from customers a where a.razao_social like 'a%'<\/code><\/code><\/pre>\n\n\n\nQuery1.SQL.Add('select');
Query1.SQL.Add(' a.razao_social, ');
Query1.SQL.Add(' a.cnpj,');
Query1.SQL.Add(' a.address,');
Query1.SQL.Add(' a.end_number, ');
Query1.SQL.Add(' a.end_complement, ');
Query1.SQL.Add(' a.end_neighborhood, ');
Query1.SQL.Add(' a.end_city, ');
Query1.SQL.Add(' a.end_cep, ');
Query1.SQL.Add(' a.end_uf, ');
Query1.SQL.Add(' a.end_state, ');
Query1.SQL.Add(' a.end_country, ');
Query1.SQL.Add(' a.status,');
Query1.SQL.Add(' a.status_com');
Query1.SQL.Add('from clients to');
Query1.SQL.Add('where a.razao_social like ''a%''');<\/pre>\n\n\n\n
and then it would clean whitespace and double quotes, am I right?<\/p>\n\n\n\n![\"Posicionando-se](\"https:\/\/gladiston.github.io\/hello_lazarus\/assets\/productivity_multi_paste1.png\")
<\/li>
Query1.SQL.Add('<\/strong>
is at Text after each line<\/strong> the following text:
‘);<\/strong>
now uncheck the option Trim clipboards contents<\/strong> so we don't lose the indentation of our SQL, as we can see in the image:<\/li><\/ol>\n\n\n\n![\"Usando](\"https:\/\/gladiston.github.io\/hello_lazarus\/assets\/productivity_multi_paste2.png\")
<\/figure>\n\n\n\n![\"Resultado](\"https:\/\/gladiston.github.io\/hello_lazarus\/assets\/productivity_multi_paste3.png\")
Your code\/query is already correctly quoted closing its pairs.<\/li><\/ol>\n\n\n\n![\"Resultado](\"https:\/\/gladiston.github.io\/hello_lazarus\/assets\/productivity_multi_paste4.png\")
<\/figure>\n\n\n\n