Jump to content

haentschman

Members
  • Content Count

    211
  • Joined

  • Last visited

  • Days Won

    5

Posts posted by haentschman


  1. Quote

    Google "disable live bindings"

    I think, it was a joke...:classic_unsure: Google: "delphi disable live bindings" site is not funny.

     

    the answer is:

    Quote

    Related post: https://forums.embarcadero.com/message.jspa?messageID=934167

     

    And I have just disabled livebinding by renaming all the 4 .bpl files on disk:

    
    dclbindcomp180.bpl
    dclbindcompdbx180.bpl
    dclbindcompfmx180.bpl
    dclbindcompvcl180.bpl

     


  2. Quote

    I'm flipping between the Test and Live connections

    [Breainstorming :classic_cool:]

    Version1:

    In my applications i have a Interface for every database system. In the interface all queries are created dynamically. The connection is created in this interface. All use this connection...

    For you: Give your datamodule a public property (example: "CurrentConnection") . Connect all queries with this "CurrentConnection". If you change the "CurrentConnection" with the "LiveConnection" then the queries works with the "LiveConnection". :classic_cool:

    Datamodule....
    
    private
      FCurrentConnection: TFDConnection;
    public
      property CurrentConnection: TFDConnection;
    ...
    // All queries
    Query.Connection := FCurrentConnection;
    
    Application...
    Datamodule.CurrentConnection := FDLiveConnection;
    // or
    Datamodule.CurrentConnection := FDTestConnection;

     

    Version2:

    Create separate INI with the connection string for Test / Live. Over a build configuration the application loads his own INI.

     


  3. Hi...:classic_cool:

    Quote

    ...and over 20 FDQueries for all the tables

    ...I'm having to re-specify the sql query in code several times throughout the application.

    ...It seems to me that this isn't very good coding/design

    ...another variant: https://en.delphipraxis.net/topic/219-dimowa®-sql-resource-creator/

    Quote

    A tool that manages the resource strings according to the tutorial mentioned in the german link (https://www.delphipraxis.net/49505-sql-dateien-als-resource-einbinden.html).

    This is another way to manage SQL statements. The SQL are stored in separate files in a folder structure in the project. SQL can be tested in the preferred DBMS editor.

    Important: SQL Statements OUTSIDE of the Sourcecode (pas, dfm) in resources *.res. (without SQL.Add; SQL.Add; SQL.Add... :classic_cool:)

     


  4. Hi all...:classic_cool:

    Quote

    Now if you would also have the "old" Object Inspector Expert from Uwe ..... that would be a dream !

    :classic_love::classic_cheerleader:The last version was imho XE. I've written to Uwe before... without an answer. Everyone who knows Uwe has no contact more... :classic_sad:

    @Uwe Schuster: We need only the SourceCode...please. :classic_tongue:

×