Database
Amazon RDS – MariaDB Connecting to DB
To connect to Amazon RDS MariaDB we need a client software. In this case we use Navicat. Install it using the link Navicat . After it is successfully installed we follow the steps below to […]
Delphi
Database
Amazon RDS – MariaDB Data Import
Amazon RDS MariaDB provides easy ways of importing data into the DB and exporting data from the DB. After we are able to successfully connect to the MariaDB database we can use CLI tools to […]
Database
Amazon RDS – PostgreSQL Features
PostgreSQL is a powerful, open source object-relational database system which has earned a strong reputation for reliability, feature robustness, and performance. AWS RDS runs various versions of PostgreSQL. It supports point-in-time restore and backups, creation […]
Database
Amazon RDS – PostgresSQL creating DB
As a cloud platform AWS gives you very minimal number of steps to setup a DB in RDS. Creating a PostgreSQL can be done in three ways. Using AWS management console, AWS CLI or AWS […]
Database
Amazon RDS – PostgreSQL Connecting to DB
To connect to Amazon RDS PostgreSQL DB we need a client software. In this case we use pgAdmin. After it is successfully installed we follow the steps below to connect it to the Amazon RDS. […]
Database
Amazon RDS – PostgreSQL Data Import
Amazon RDS PostgreSQL provides easy ways of importing data into the DB and exporting data from the DB. After we are able to successfully connect to the PostgreSQL database we can use CLI tools to […]
Database
Amazon RDS – MySQL Features
MySQL is a popular Relational DB which is available in the amazon RDS services with its community edition features. Almost every feature of MYSQL can be leveraged in the RDS platform with only some restrictions […]
Database
Amazon RDS – MySQL Creating DB
As a cloud platform AWS gives you very minimal number of steps to setup a DB in RDS. Creating a MYSqlDB can be done in three ways. Using AWS management console, AWS CLI or AWS […]
Database
Amazon RDS – MySQL Connecting to DB
To connect to Amazon RDS MySQL DB we need a client software. In this case we use MySQL Workbench. After it is successfully installed we follow the steps below to connect it to the Amazon […]
Database
Amazon RDS – MySQL DB Export Import
Amazon RDS MySQL provides easy ways of importing data into the DB and exporting data from the DB. After we are able to successfully connect to the MySQL database we can use CLI tools to […]
Database
Amazon RDS – MySQL DBA Tasks
As with every other database, Amazon RDS MYSQL also needs DBA tasks to fine tune the database and do periodic health checks etc. But as the AWS platform does not allow the shell access to […]
Database
Amazon RDS – Multi-AZ Deployments
In a Multi-AZ deployment, Amazon RDS automatically provisions and maintains a synchronous standby replica in a different Availability Zone. The primary DB instance is synchronously replicated across Availability Zones to a standby replica to provide […]
Database
Amazon RDS – DB Snapshots
Amazon RDS creates automated backups of your DB instance during the backup window of your DB instance and stores them as volume snapshots. Automated Backup For Automated backup to work properly, followings are the criteria. […]
Delphi
Passing Array to Function in C++
You can pass arrays an argument to a function just like you pass variables as arguments. In order to pass array to the function you just need to mention the array name during function call […]
Delphi
Strings in C++
Strings are words that are made up of characters, hence they are known as sequence of characters. In C++ we have two ways to create and use strings: 1) By creating char arrays and treat […]
Delphi
C++ ‘this’ Pointer
The this pointer holds the address of current object, in simple words you can say that this pointer points to the current object of the class. Let’s take an example to understand this concept. C++ […]
Delphi
C++ Tutorial – Learn C++ Programming with examples
Learn C++ Programming with examples C++ language is a direct descendant of C programming language with additional features such as type checking, object oriented programming, exception handling etc. You can call it a “better C”. […]
Delphi
C++ Loop Types
There may be a situation, when you need to execute a block of code several number of times. In general, statements are executed sequentially: The first statement in a function is executed first, followed by […]
Database
Embarcadero InterBase 2020 v14.1.0.231
InterBase is the name of a powerful and of course application software in the field of database management. The software in front of you is actually a SQL compliant database. The support of Unicode and the compliance […]
Delphi
Press a button in a TWebbrowser when there are multiple buttons in the same form
// If there is only one button, you can do something like: WebBrowser1.OleObject.Document.forms.item(0).elements.item(0).click; // This will do a click on the first element of the first , where an // element is either , or […]
Delphi
Get the HTML Code out of all Internet Explorer Instances
Get the HTML Code out of all Internet Explorer Instances uses MSHTML_TLB, ActiveX; function GetHTMLCode(WB: IWebbrowser2; ACode: TStrings): Boolean; var ps: IPersistStreamInit; s: string; ss: TStringStream; sa: IStream; begin ps := WB.document as IPersistStreamInit; s […]
Delphi
Force IE to re-read registry settings
I’ve written a small app that modifies a setting for IE and need to somehow tell IE to re-read the registry settings. Does anyone know of an API call or message that will do this? […]
Delphi
Submit a Form in TWebbrowser with an image submit button
Submit a Form in TWebbrowser with an image submit button If you have a webpage with a Form on it, but the submit – button is an image, you can use this code (using a […]
Delphi
Execute a Javascript function in a Webbrowser/ IE Document
Execute a Javascript function in a Webbrowser/ IE Document uses MSHTML_TLB, SHDocVw, ShellAPI; // function to execute a script function function ExecuteScript(doc: IHTMLDocument2; script: string; language: string): Boolean; var win: IHTMLWindow2; Olelanguage: Olevariant; begin if […]
Delphi
Download a webpage with a hidden IP programmatically
Add a button and memo implementation {$R *.dfm} uses Urlmon; procedure TForm1.Button1Click(Sender : TObject); var ca : iinterface; rls : Integer; stat : iBindStatusCallBack; rr : Cardinal; tag : _tagBindInfo; exGuid : tguid; noIp : […]
Delphi
Send an email with attachments by shellexecute to outlook express
Shellexecute(Handle,’open’,’mailto:aaaa@bbb.com?subject&body=body text&CC=aaaa&bcc=dddd&attach=FileName’,nil,nil,SW_SHOW) only works with outlook, not for outlook express, but the method below can send attachment to outlook express uses ComObj; procedure SendMail(Subject, Body, RecvAddress : string; Attachs : array of string); var MM, […]
Delphi
How to get the serial number of an Audio CD programmatically
(* ——————————————- How to get the serial number of an Audio CD — Required units: MMSystem, MPlayer ——————————————- *) procedure AudioCDSerialNumber(Sender: TObject); var mp : TMediaPlayer; msp : TMCI_INFO_PARMS; MediaString : array[0..255] of char; ret […]
Delphi
Get & Set Audio Volume programmatically
Get & Set Audio Volume programmatically unit uMain; interface uses Windows, Messages, SysUtils, Classes, Controls, Forms, Dialogs, ExtCtrls,StdCtrls, mmsystem; //You must add this in the uses line type TForm1 = class(TForm) procedure FormCreate(Sender: TObject); procedure […]
Delphi
How to set the screen resolution programmatically
// How to set the screen resolution. procedure SetResolution(XRes, YRes: DWord); var lpDevMode : TDeviceMode; begin EnumDisplaySettings(nil, 0, lpDevMode); lpDevMode.dmFields := DM_PELSWIDTH or DM_PELSHEIGHT; lpDevMode.dmPelsWidth := XRes; lpDevMode.dmPelsHeight := YRes; ChangeDisplaySettings(lpDevMode, 0); end;
Delphi
Test if a sound card is installed or not programmatically
(* —————————————————- If you write multimedia software that requires an installed sound card, of course you must check if some sound card is installed You may do so with this function: —————————————————- *) function waveOutGetNumDevs: […]
Delphi
Remove Dead Tray Icons
// Remove Dead Tray Icons procedure RemoveDeadIcons(); var TrayWindow : HWnd; WindowRect : TRect; SmallIconWidth : Integer; SmallIconHeight : Integer; CursorPos : TPoint; Row : Integer; Col : Integer; begin // Get tray window handle […]
Delphi
Hide start menu
// Hide start menu procedure HideStartMenu(); begin MoveWindow(FindWindowEx(FindWindow(‘shelltray_wnd’, nil), 0, nil, ‘button’), 0, 100, 10, 10); end;
Delphi
Get Executable Full Name From Window Handle programmatically
(* ——————————————– Get Executable Full Name From Window Handle — Required unit: Tlhelp32 ——————————————– *) function GetExeNameFromWindowHandle(AParent : HWND) : String; var ProcessEntry32 : TProcessEntry32; ProcessId : DWord; SnapshotHandle : Integer; begin Result := ”; […]
Delphi
Power management procedure (shutdown,log off, screensaver, etc) programmatically
Power management procedure (shutdown,log off, screensaver, etc) programmatically // Power management procedure (shutdown,log off, screensaver, etc) function PowerMng(Action : Integer; Force : Boolean) : boolean; var rl: Cardinal; hToken: Cardinal; tkp: TOKEN_PRIVILEGES; begin if (Win32Platform […]
Delphi
Check & Register File Association programmatically
Check & Register File Association programmatically unit file_association; interface uses SysUtils, Registry, WinTypes, ShellAPI; function RegisterAssociation(const aExeName, aFileExt, aFileDesc, aFileIcon: string): Boolean; function ShellFindExecutable(const FileName, DefaultDir: string): string; implementation //————————————————————————// function RegisterAssociation(const aExeName, aFileExt, aFileDesc, […]
Delphi
How to Empty Recycle Bin programmatically
How to Empty Recycle Bin programmatically unit Unit1; interface uses Windows, Messages, SysUtils, Classes, Graphics, ShellApi,Controls, Forms, Dialogs,StdCtrls, ExtCtrls; type TForm1 = class(TForm) procedure EmptyRecycleBin(); end; var Form1: TForm1; function SHEmptyRecycleBin(Wnd:HWnd; LPCTSTR:PChar; DWORD:Word):Integer; stdcall; const […]
