Jump to content

haentschman

Members
 View Profile  See their activity

  • Content Count

    211

  • Joined

  • Last visited

  • Days Won

    5

Posts posted by haentschman

  1. Posted · Edited by haentschman

    Quote

    Yes, that ticket is locked.

    Just because a callstack contains personal data. When i remove it, i open the ticket again.

     

    They have the same information like you... :classic_cool:

     

    Edit: Ticket reopened.

    Edit: Ticket closed (16:00)

    Edit: Ticket reopened (delete Files.zip)

  3. Posted

    Hi...

    Quote

    It was NOT intended as a funny comment

    everything will be all right. :classic_cheerleader: I take the wrong emoij :classic_huh: instead of :classic_smile:.

     

    Quote

    and especially when you are using visual inheritance the skinning system

    In the current project i use abundant visual inheritance. In the old project was every form unattached. The old project was skinning with AlphaControls and DevExpress. I have deleted the AlphaControls! Now the error raised an other positions.

    I think there might be a control (ComboBox) in the DFM and PAS but it's not visible.
    Bad: I don't have a trainee for punishment. :classic_unsure:

     

    Quote

    Though looking at this post 

    ...exactly i do so.

     

    Quote

    BTW - once a long time ago when i had another very messy problem i put up a VM so the DX team could debug my complete sources with all other 3rd party components. Might be worth a try.

    ...they do that? Cool. :classic_cool: I try...

  4. Posted · Edited by haentschman

    Thanks...:classic_smile:

     

    Quote

    You are fiddling with the Active property of that component. Why?

    see...

    Quote

    Please no funny comments about the source code... :classic_biggrin:i inherited the project.

    Its a copy / paste project with over 2Mio lines. In 8 month i cant see everything. :classic_huh:

     

    Quote

    ULIK has some very pertinent comments above. Did you research h(is/ers) suggestions? 

    ...at the moment no. :classic_blush: But i think the problem is placed in the messaging system from DevExpress and not in my code.  Normally i work with the undocked designer. No chance! If i clicked on the ribbon the same error is raised in the IDE. :classic_unsure:

    Regardless of that i will heed your tips on working with PropStore.

  7. Posted · Edited by Daniel
    Deleted attachment on request

    Hi all...:classic_cool:

    ... a few more information. I could do that once ... with breakpoint. :classic_cheerleader:Today the same Sceniario without mistakes. :classic_blink: OnActivate runs through...

     

    PS:

    Please no funny comments about the source code... :classic_biggrin: i inherited the project. :classic_blush: And these are units where I haven't done anything except the codeformatter.

     

    Please help... :classic_unsure:

     

    Thanks.

     

     

     

  12. Posted · Edited by haentschman

    Hi...:classic_cool:

    Quote

    // This works fine.

    ...rather not.

     

    Why is this constellation always used? 

    fdquery.SQL.Clear();
fdquery.SQL.Add

    instead of 

    fdquery.SQL.Text

    ?

     

    Imho SQL.Text also resets the parameters. With SQL.Clear only the SQL is removed. The parameters are retained! Consistent would be however: 

    fdquery.SQL.Clear;
fdquery.Params.Clear;

    PS: Better Open than Active = True, Close or Active = False is not necessary with Firedac

     

    Give it a try: 

    fdquery.SQL.Text := 'SELECT * FROM MyTable WHERE Key1=:KEY1 AND Key2=:KEY2';
fdquery.ParamByName('KEY1').AsString = 'value1';
fdquery.ParamByName('KEY2').AsString = 'value2';
fdquery.Open;

     

  14. Posted · Edited by haentschman

    Thanks...:classic_smile:

    Quote

     does not create it at creation time because it does not need to BUT when things are to get destroyed the little "Handle" getter function...

    That's what I think, too. A message problem.

    Quote

    Logging any changes you have made between production versions

    ...it's always been like this :classic_unsure:

    Quote

    The call before CreatHandle looks odd. Looks like there are entries missing.

    I am on vacation...next week i get a more detailed Callstack with debugging information from VCL.

  15. Posted · Edited by haentschman

    Hi all... :classic_cool:

     

    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:)

     

    * Online update if you want
    * User defined color scheme
    * Administration Projects
    * Administration SQL for multiple databases
    * Management of the status of SQL in the network (colleagues)
    * Administration of any folders for SQL
    * Handling like you know it from an editor
    * Partial string search
    * the projects / ini are stored in the user directory ! (see todo)

     

    Tips
    1. create the base folder for all SQL
    2. creation of subfolders for project-specific SQL
    3. a namespace for the SQL is imho important. (reasonable order and search)

     

    Todo:

    * The project XML stored in your project folder (better for version controls systems)

    * Partial string search in all SQL files

    * a smaller encyption standard for version controls systems

    * English version > 100 users :classic_cool:

     

    DOWNLOAD > 5MB: http://www.dimowa.com/downloads/dSRG/Setups/dSRGSetup14.zip
    Lizenz: Freeware for one DBMS

     

    Manual: Manual.pdf

     

    GUI:

    dSRG_GUI.png

     

    Resource clear text:

    Ressource_normal.png

     

    Resource encrypted:

    Ressource_crypt.png

     

    Splash:

    Splash.png

     

    • Like 1

  18. Posted · Edited by haentschman

    Hi all...:classic_cool:

    This is my favorite Error message...:classic_unsure: 

     

    Project:

    * 2 mio lines.

    * DevExpress  18.3

     

    This error ist not new. He exist since more then 10 years by DevExpress! The error comes from time to time. :classic_unsure:

    Ticket DevExpress:

    https://www.devexpress.com/Support/Center/Question/Details/T624801/element-has-no-parent-window

     

    Callstack Example:

    Quote 
    
date/time          : 2018-11-02, 12:12:54, 362ms
computer name      : WIN7-P06
user name          : XXX
registered owner   : WIN7-User
operating system   : Windows 7 x64 Service Pack 1 build 7601
system language    : German
system up time     : 1 day 1 hour
program up time    : 1 hour 37 minutes
processors         : 8x Intel(R) Core(TM) i7-2600K CPU @ 3.40GHz
physical memory    : 12499/16365 MB (free/total)
free disk space    : (C:) 80,51 GB (W:) 497,73 GB
display mode       : 1920x1080, 32 bit
process id         : $13a0
allocated memory   : 1,00 GB
largest free block : 456,24 MB
executable         : XXX.exe
exec. date/time    : 2018-10-31 15:36
version            : 1.4.1.100
compiled with      : Delphi 10.1 Berlin
madExcept version  : 4.0.19
callstack crc      : $1ce86e39, $2e885e9e, $57e9cf7d
exception number   : 1
exception class    : EInvalidOperation
exception message  : Element '' hat kein übergeordnetes Fenster.

main thread ($e5c):
006e9f94 +0b4 XXX.exe Vcl.Controls             TWinControl.CreateWnd
0096b1a2 +022 XXX.exe cxControls     8288   +3 TcxControl.CreateWnd
00a2a9e3 +087 XXX.exe cxContainer    3911  +12 TcxContainer.CreateHandle
00ab0156 +00a XXX.exe cxEdit         7745   +1 TcxCustomEdit.CreateHandle
00afcf96 +00a XXX.exe cxDropDownEdit 2613   +1 TcxCustomDropDownEdit.CreateHandle // every time this line! 
0282a897 +00f XXX.exe Form.MainMenu   361   +2 TfoMenuMain.pnlLeftClick // (TfoMenuMain) ->Self.Close; // Form WITHOUT DevExpress!
02d95c91 +d59 XXX.exe SEAM            328 +216 initialization

     

    Any ideas?

     

    Thanks..

  19. Posted · Edited by haentschman

    Hi...:classic_cool:

     

    If you extracting the SQL from Sourcecode, then you can save it as Resource...a better handling for more then one DBMS. 

    But i think, that the extraction of of the SQL is manually work. :classic_huh:

     

    ! Advertising from me...:classic_tongue:

    How about this? DIMOWA®SQL Creator ...at the Moment in German. :classic_wink:

     

    Advantages:

    * SQL not in query or sourcecode

    * SQL as file on the disk

    * SQL can tested in your favored Editor

    * SQL, if you want, encypted in the EXE

    * Shows more DBMS  side by side  in the editor

    ...and so on.

×