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 […]
Database
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 Monitoring
In order to maintain the reliability, availability, and performance of Amazon RDS, we need to collect monitoring data so that we can easily debug a multi-point failure. With Amazon RDS, you can monitor network throughput, […]
Database
Amazon RDS – Event Notifications
Throughout the life cycle of amazon RDS DB instances, many DB events occur which are important to be known beforehand. For example – A backup of the DB instance has started, or an error has […]
Database
Get Rid Of the Annoying SQL Wait Cursor
{ Simply place this one line of code in the OnCreate event of the form that is showing the annoying SQL Wait cursor… } procedure TForm1.FormCreate(Sender: TObject); begin Screen.Cursors[crSQLWait] := Screen.Cursors[crHourGlass]; // or whatever cursor […]
Database
Stop the DBGrid control from auto-appending a new entry
Stop the DBGrid control from auto-appending a new entry {How to stop the dbgrid control from auto-appending a new entry when you move down after the last record in a table. It creates a new […]
Database
Convert a ADO Recordset to XML and the reverse way
Convert a ADO Recordset to XML and the reverse way unit ADOXMLUnit; interface uses Classes, ADOInt; function RecordsetToXML(const Recordset: _Recordset): string; function RecordsetFromXML(const XML: string): _Recordset; implementation uses ComObj; { Example: … Memo1.Lines.Text:=RecordsetToXML(ADOQuery1.Recordset); … } […]
Database
Locate on a non-indexed field in a TTable
{The following function can be added to your to your unit and called as follows:} Locate(Table1, Table1LName, ‘Beman’); {Table1 is your table component, Table1LName is TField you’ve add with the fields editor (double click on […]
Database
Create a database at run-time with ZEOS
Create a database at run-time with ZEOS { This unit creates a database on a Interbase-Server at run-time. The IBConsole is no longer needed. You can execute an SQL script to create tables. Try it […]
Database
Read a BlobStream with TADOQuery from an AccessDB
Read a BlobStream with TADOQuery from an AccessDB function GetBlobStream(Query: TADOQuery): TMemoryStream; begin result := TMemoryStream.Create; // You must connect to AccessDB first. // See: Query.Connection, TADOConection or Query.ConnectString // Send SQL command Query.Active := […]
Database
Create database on local MS SQL Server 2000
Create database on local MS SQL Server 2000 procedure CreateDatabase(WindowsSecurity: Boolean; Username, Password: String); var ConnectionString: String; CommandText: String; begin if WindowsSecurity then ConnectionString := ‘Provider=SQLOLEDB.1;’ + ‘Integrated Security=SSPI;’ + ‘Persist Security Info=False;’ + ‘Initial […]
Database
Compact and Repair an Access Database
{ Here is a function I have made to compact and repair an access database. Exclusive access to the DB is required!! } uses ComObj; function CompactAndRepair(DB: string): Boolean; {DB = Path to Access Database} […]
Database
Create tables on MS SQL Server 2000
Create tables on MS SQL Server 2000 procedure TLocal.CreateTables(WindowsSecurity: Boolean; Username, Password: String); var ConnectionString: String; begin if WindowsSecurity then ConnectionString := ‘Provider=SQLOLEDB.1;’ + ‘Integrated Security=SSPI;’ + ‘Persist Security Info=False;’ + ‘Initial Catalog=test’ else ConnectionString […]
Database
Recover the ID of the last inserted row in a table (ADO)
// Insert a new Record… var LastID: Integer; // Query: TADOQuery; // oder // Query: TQuery; begin Query.Active := False; Query.SQL.Clear; Query.SQL.Append(‘INSERT INTO Table (Spalte) VALUES (Value)’); Query.ExecSQL; LastID := GetLastID(Query); end; // get the […]
Database
Use ADO to connect to an Access Database and write a BlobStream value
Use ADO to connect to an Access Database and write a BlobStream value unit Unit1; interface uses Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms, Dialogs, StdCtrls, ADODB, DB, DBTables, ComObj; type TForm1 = class(TForm) […]
Database
Edit an inplace TMemo inside a TDBGrid
(* A common problem when working with DBGrid is, that this component can’t display TMemo fields, multiline columns, Graphics… There are a few good freeware components around to solve this problem. The best one is […]
Database
Multi select rows in a DBGrid using Shift (select as in the IE)
//Folgendes muss eingebaut werden property BM1: TBookmark read FBM1 Write SetBM1; property BM2: TBookmark read FBM2 Write SetBM2; procedure Markieren(Sender: TObject); function Shiftgedr: Boolean; procedure TForm1.Markieren(Sender: TObject); var Richtung: string; TempBM: TBookmark; begin with (Sender […]
Database
Load a jpeg file into a blob field using SQL
Load a jpeg file into a blob field using SQL procedure TForm1.Button1Click(Sender: TObject); var ms: TMemoryStream; begin if OpenPictureDialog1.Execute then begin ms := TMemoryStream.Create; try ms.LoadFromFile(OpenPictureDialog1.FileName); with Query1 do begin with SQL do begin Clear; […]
Database
Convert a Query into a Table
Convert a Query into a Table unit Unit1; interface uses Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms, Dialogs, StdCtrls, Grids, DBGrids, DB, DBTables; type TForm1 = class(TForm) Button1: TButton; Query1: TQuery; DataSource1: TDataSource; DBGrid1: […]
Database
Create Tables Detial/Master in Sql Server 2000 With Code
Create Tables Detial/Master in Sql Server 2000 With Code procedure TForm1.Button1Click(Sender: TObject); begin ADOCommand1.CommandText := ‘Create Table MasterTable ‘ + ‘(FieldName Primary Key);’; ADOCommand1.Execute; ADOCommand1.CommandText := ‘Create Table Detailtable ‘ + ‘(Fieldname Primary Key Refrenced […]
Database
Get List of Tables in Sql Server 2000
Get List of Tables in Sql Server 2000 procedure TForm1.Button1Click(Sender: TObject); begin ADOQuery1.SQL.Add(‘Exec SP_Tables’); ADOQuery1.Active := True; end;
Database
create a table including an AutoInc field (ADO/MSSQL)?
// Erzeugt eine Tabelle mit dem Namen MYTABLENAME, mit den Spalten ID, // MYTEXT1, MYTEXT2. // (Der Name der ID Spalte kann natürlich frei gewählt werden.) // ID ist der Primärschlüssel der Tabelle. Er ist ein Integer, der sich // automatisch für jede Zeile // der Tabelle erhöht. ID wird nie doppelt vorkommen. // MYTEXT1 und 2 sind vom Typ String. // Ich verwende die ADOConnection um mit Jet 4.0 auf eine Access- // datenbank (*.mdb) zuzugreifen. // Der Syntax ist MSSQL, wenn ihr das für PHP oder so verwenden wollt, // muss man das ein bissel umformulieren 😉 // Creates a Table called MYTABLENAME with a unique identifier called // “ID”. ID increases with every new row automatically. MYTEXT1 and 2 // are Strings. Name the colums as you want to. // I used the ADOConnection to access a MS-Access Database (*.mdb) // via Jet 4.0. // The Syntax is MSSQL, you have to transform it to use it in PHP or so. uses AdoDB; var q: TAdoQuery; db: TAdoConnection; begin // Initialize db here q := TADOQuery.Create(nil); q.Connection := db; q.Close; q.SQL.Clear; q.SQL.Add(‘Create Table MYTABLENAME (ID COUNTER PRIMARY KEY, MYTEXT1 String, MYTEXT2 String);’); q.Prepared := True; try q.ExecSQL; except end; q.Free; end;
