Jump to content

Codehunter

Members
 View Profile  See their activity

  • Content Count

    4

  • Joined

  • Last visited

Posts posted by Codehunter

  1. Posted

    On 11/14/2020 at 1:51 PM, dummzeuch said:

    Have you looked at the newer "Convert Strings" expert? There is a favorite called "SQL-to-String" which seems to do exactly what you want

    Thanks! This is exactly what I want. But a little confusing. Maybe the Convert Strings expert can supercede the String Paste as expert because the last is a subset of the first.

  2. Posted

    12 minutes ago, Lars Fosdal said:

    It is pseudocode - the way we'd want it to work - and as I said, there has been QP or QC's created for this before.

    This was not meant as critic 🙂 As you can see at the left, I'm not so often here... Mostly in the german DP

  3. Posted

    6 minutes ago, Lars Fosdal said:

    I totally agree, and it has been suggested for years.
    No joy so far.

    Unneeded whitespace and linebreaks should be eliminated. 

    
LSQL := "SELECT * 
        FROM myTable 
        WHERE myCol=1 
        ORDER BY id DESC";

     

    But your snippet seems to be like pseudocode, its not Delphi/Pascal 🙂 I'm used such constructs in PHP and let the DBMS strip all unneeded stuff. But Delphi/Pascal doesnt support multiline strings like in your snippet.

     

    The resulting SQL Statement should be: 

    SELECT * FROM myTable WHERE myCol=1 ORDER BY id DESC

     

    10 minutes ago, Arnaud Bouchez said:

    Some tools - like cnpack IIRC - allow to format the text into source code string after being pasted.

    Oh yeah, lets remove all the stuff from GExperts which exists in other Tools 😉 The Apple Way: Nothing can exist in our Appstore that is already offered by us. 🤬

    IMHO the best way is a competition between the best ideas. I know that other IDE experts have similar or better implementations but why not improve GExperts? Sometimes the others are unstable or unusable in some situations. Esp. CnPack is very tricky in the Editor Experts, therefore I have completely disabled this part.

  4. Posted

    Hello!

     

    Would be nice to have an type "%s +" in the PasteAs options for SQL statements. There is not neccessary to include any linebreak in the string itself, only in the Pascal source. 

    LSQL := 'SELECT * ' +
        'FROM myTable ' +
        'WHERE myCol=1 ' +
        'ORDER BY id DESC';

    Please note the space prior to the closing quotemark in each line.

     

    Greetz

    Cody

×