haentschman

Hi all... 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... ) * 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 DOWNLOAD > 5MB: http://www.dimowa.com/downloads/dSRG/Setups/dSRGSetup14.zip Lizenz: Freeware for one DBMS Manual: Manual.pdf GUI: Resource clear text: Resource encrypted: Splash:

Hi... ...nobody interested in this? ... crazy

Hi... ...one is still missing. The film https://en.wikipedia.org/wiki/The_Hitchhiker's_Guide_to_the_Galaxy_(film) cutout https://www.youtube.com/watch?v=aboZctrHfK8

Hi... Why? It take 5 minutes...

Hi all... This is my favorite Error message... 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. Ticket DevExpress: https://www.devexpress.com/Support/Center/Question/Details/T624801/element-has-no-parent-window Callstack Example: Any ideas? Thanks..

Just because a callstack contains personal data. When i remove it, i open the ticket again. They have the same information like you... Edit: Ticket reopened. Edit: Ticket closed (16:00) Edit: Ticket reopened (delete Files.zip)

I have a Ticket. https://www.devexpress.com/Support/Center/Question/Details/T624801/element-has-no-parent-window Problem: Even devexpress can't understand this. How am I supposed to find the error? I join the queue of others who fight with the same bug. With the other developers there are different controls. Edit: Just arrived the proposal with the VM by DevExpress.

Hi... everything will be all right. I take the wrong emoij instead of . 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. ...exactly i do so. ...they do that? Cool. I try...

Thanks... see... Its a copy / paste project with over 2Mio lines. In 8 month i cant see everything. ...at the moment no. 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. Regardless of that i will heed your tips on working with PropStore.

Thanks... But...at this point the owner is not destroyed (imho)! GridEdAnlagenDBTableViewANL is auto created with the form and the form ist destroyed at Application.Close????

Thanks... i try this. By the way... ...the error comes only by ComponentState = csFreeNotification! What's that mean?

Hi all... ... a few more information. I could do that once ... with breakpoint. Today the same Sceniario without mistakes. OnActivate runs through... PS: Please no funny comments about the source code... i inherited the project. And these are units where I haven't done anything except the codeformatter. Please help... Thanks.

Hi... W8.1 is like D2005 Show me who doesn't.

really? Why?

Hi... ErrorInsight has never worked before. The checkmark is the first one that is gone with every installation. I trust the compiler.

Hi... sorry...no notion

Hi... ...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;

...no! Why whith "WITH"!

Thanks... That's what I think, too. A message problem. ...it's always been like this I am on vacation...next week i get a more detailed Callstack with debugging information from VCL.

Hi... * Grid * Comboboxes * different Edits * Layouts

Hi... ...its always "intermittent" and at differrent source code positions. Thanks...

Hi... 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. ! Advertising from me... How about this? DIMOWA®SQL Creator ...at the Moment in German. 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.