Scott Hollows – One Line At A Time

Technical tips for Oracle and Delphi

  • Home
  • Software
  • Oracle
  • Delphi
  • AutoHotKey
  • RSS Feeds
  • Scratchpad
  • About
  • Contact
  • Oracle foreign keys do not always work

    I’ll show you how to break them, and how to fix them Im not talking about DISABLED or DEFERRED or NOVALIDATE foreign keys – No, this is different. This is for a specific scenario – a multi column foreign key based on one or more optional columns You can insert a row with junk values…

  • FREE Monitor Viewer for Windows. View Multiple External Monitors

    MonitorViewer is free Windows software that lets you view another external monitor in a window. Useful for doing presentations so you can see the output that is on the projector screen when using extended desktop mode, rather than mirror mode. Now you dont have to turn around to see the projector screen Up to 6 monitors…

  • AutoHotKey (AHK) New Line In Macro Output

    There are multiple ways to send a New Line to AutoHotKey output.I will show one technique that has worked well for me This example is triggered when you type in MyMacroText1 (not case sensitive) and it then sends the text including new lines to the current program You can do it all on one line…

  • AutoHotKey (AHK) Text Replacement / Key Macro Using Text From File

  • AutoHotKey (AHK) Text Replacement / Key Macro Using Multiple Inputs

  • AutoHotKey (AHK) toggle window on top / not on top

  • AutoHotKey (AHK) Adjust Sound Volume using Shift Mouse Up / Down

    Bonus Tip. Modifier Keys ! Alt^ Ctrl+ Shift# Windows

  • Delphi FMX – click through form. HitTest not available

    Create a Delphi FireMonkey (FMX) form that the user can click through

  • Delphi TSplitter immediate repaint screen while dragging

    Delphi TSplitter does not immediately refresh other controls when you are dragging it. To make a Delphi TSplitter immediately repaint the screen when you drag it with the mouse, set ResizeStyle = rsUpdate

  • Get color of active window title bar in Delphi

    This post shows you how to get the color of the title bar for the active window.  The method to get the color of the title bar of an active window in Delphi has changed over time.

  • Examples of Devart UniDac connecting to Oracle database

    Examples of Devart Unidac connecting to an Oracle database using Oracle Client and direct connection (no Oracle Client)

  • Separator lines for project files in Delphi IDE

    Add separator lines to your Delphi IDE project files list.

  • Convert Delphi VCL window handle (HWND) To String

    Simple example of converting a window handle (HWND data type) to a string in a Delphi VCL program cardinal(vMyWindowHandle).ToString

  • Disable Delphi TTimer during the OnTimer event

    When writing a Delphi TTimer event, I often disable the timer and re-enable it at the end of the event. If you dont do this, the OnTimer event could fire again before you have finished processing it.

  • Increase / decrease (Zoom) the Delphi IDE font

    Download my free software to add hotkeys to the Delphi IDE to increase and decrease the font size in the code editor.

  • Windows File Manager Extension by Scott Hollows

    This is a free add-on for Windows File Manager that provides some useful hot keys and features.

  • FireMonkey Panel tricks – Panel Color and Transparent Panels

    Change the color of a Delphi FireMonkey panel or make a FireMonkey panel transparent.

  • Delphi Performance Tuning – Creating 500 Panels on a Form

    I needed to create 500 panels on a form for a game that I was assisting another person with … and Delphi was choking.  It was taking 20 seconds to do this.   Not cool.  We had to find a way to speed it up.  This is what we did …

  • Delphi 2D controls in 3D (FireMonkey) – presentation 1st March 2017, Brisbane Australia

    I am doing a remote presentation this week on “Displaying and Animating 2D FireMonkey controls in 3D”.  This will be at the Australia Delphi User Group’s meeting in Brisbane

  • Dynamic SQL in a SELECT … using an embedded function in Oracle 12

    You can include dynamic SQL in a SELECT statement in Oracle 12 by using an embedded function.  Ill show you how

  • Fix object is not visible in Delphi’s Live Bindings Designer

    I recently hit a problem where an object on a form was not visible in Delphi’s Live Bindings Designer.  Ill show you how I fixed that

  • Popup menu for a Delphi Firemonkey form

    Unlike VCL forms, Delphi FireMonkey forms do not have a PopupMenu property.  So how can you show a popup menu when the user clicks the Right Mouse Button ? You have to code it yourself and its pretty easy to do.  The tricky bit is converting the X/Y  position from the forms local co-ordinate system to global co-ordinates.  Ill show…

  • Immediate TTimer to emulate PostCreate / PostOnCreate event in Delphi

    Learn how to create the equivalent of an PostCreate / PostOnCreate event that executes just after the form’s OnCreate event has fired. To do this, we will use an “Immediate Timer”

  • Z Order of Controls in Delphi FireMonkey

    Get and set the Z Order of controls at runtime in Delphi FireMonkey.

  • Copy an Oracle ApEx page between repositories

    Learn how to copy pages between applications in different ApEx repositories. Oracle ApEx allows you to export pages, but you can only import them into the same application in the same repository.  If you try to import into another application or another repository you will get an error. This page was exported from a different application…

  • Z Order of Controls in Delphi VCL

    Get and set the Z Order of controls at runtime in Delphi VCL.

  • Color gradient in Delphi FireMonkey

    Introduction to color gradients in Delphi FireMonkey.

  • Multi-Line Captions for TLabel, TPanel and Buttons. Delphi VCL and FireMonkey

    Implement multi-line captions in Delphi for TPanel, Tlabel and buttons (TButton, TSpeedButton, TBitBtn) This is native Delphi code.  You don’t need to hack the form’s text file VCL and FireMonkey source code is included

  • Multi Line Popup Hints for Delphi VCL and FMX

    Learn how to setup multi line popup hints in Delphi for any type of control for both VCL and FireMonkey. This uses native Delphi code.  You don’t need to hack the forms’s DFM text file

  • Using a reserved word as an identifier (variable name, class name etc) in Delphi

    AKA Silly Delphi Party Tricks #1 Is it possible to use a reserved word as an identifier ? For example – I want to name my variable or class “BEGIN” because, ummm, well I dont know just because. Yes you can.  Simply prefix the the name with an ampersand “&” escape character like this var &begin : integer; // begin…

1 2
Next Page→

Scott Hollows – One Line At A Time

Create a website or blog at WordPress.com

 

Loading Comments...
 

    • Subscribe Subscribed
      • Scott Hollows - One Line At A Time
      • Already have a WordPress.com account? Log in now.
      • Scott Hollows - One Line At A Time
      • Subscribe Subscribed
      • Sign up
      • Log in
      • Report this content
      • View site in Reader
      • Manage subscriptions
      • Collapse this bar