Delphi Onderdils The Delphi Resources

This example is how I look for nohp in a pulse transaction on the server. using tedit to find data on the next grid.
In the event of a change in tedit, the text will be searched to the next column of the grid. Column Nohp located at index 6. by looping from the first line to last line , it will seek the edit value in the column specified. If there is data that is similar or the text containing the data will be displayed in nextgrid

Continue Reading…

This is example fill next grid with data using addoquery and microsoft Access database.

The first time you must add columns to  nextgrid by double click the component, and then choose type column of  next grid wicth do you want :

• Tnxtextcolunn
• Tnxnumbercolumn
• TnxImagecolumn
• ect

Continue Reading…

Next Grid is Grid component from Berg Software, we can acces cells like field, such as :;

begin
 edit1.text:=gridtrx.Cell[6, i].AsString;
 edit2.text:=inttostr(gridtrx.Cell[6, i].Asinteger);
end;

NextGrid is a powerful Delphi/CBuilder Grid. It is very easy to use it in design-time (with using intuitive Columns Editor) and in run-time.

NextGrid have much more features than standard Grid, attractive look (Windows Vista & XP themes support), it is extremely fast (quick sorting, data manipulation, drawing…)

Continue Reading…

What is FreeReport?

FreeReport is product from Fastreport.inc, this is free version

FreeReport 2.3 consists of a report engine, a designer, and a previewer. Its capabilities are comparable to QuickReport3 and ReportBuilder 3.52.
FreeReport 2.3 works with Delphi 2/3/4/5/6/7/2005 and 2006 and C++ Builder 1/3/4/2005/2006.
Freeware; royalty-free full source code.
What’s new in FreeReport 2.34?

Continue Reading…

we can take advantage of the position of the folder of the application that we are making. for example calling the help file, call the report file, database access and so forth by utilizing  application.exename

• create new application
• add 3 edit to form
• add button to form
• double click button1
• write this code

procedure TForm1.Button1Click(Sender: TObject);
 begin
 caption:=application.exename;
 edit1.Text:=application.exename;
 edit2.Text:=extractfilepath(application.exename);
 edit3.Text:=extractfilename(application.exename);
 end;

source code

Continue Reading…

HeidiSQL is one of tool to manage MySQL database . Heidisql is build from delphi and zeos component, it is for free. we can download at  http://www.heidisql.com

HeidiSQL is a lightweight, Windows based interface for MySQL databases. It enables you to browse and edit data, create and edit tables, views, procedures, triggers and scheduled events. Also, you can export structure and data either to SQL file, clipboard or to other servers.

Features

Continue Reading…

ZeosDBO Installation Guide

• You can download the current (SVN) version from svn://www.firmos.at/zeos/trunk/
• The development/testing branch is at svn://www.firmos.at/zeos/branches/testing/
• Snapshots can be found at http://zeosdownloads.firmos.at/downloads/snapshots/

Official reaseses are published at the Zeoslib forum [http://zeos.firmos.at/portal.php] and the Zeoslib Source-
forge Project pages [http://sourceforge.net/projects/zeoslib]

1.    Unpack the archive to a folder (not for SVN versions, of course)

2.    Copy the required dlls for your database client to the windows system directory (usually    Win-
dows\System or winnt\system32) or use the database client installer.
Attention : think about licence issues when working with the database client libraries. Not all software is
freely distributable in all situations. These libraries are NOT a part of the zeoslib packages.

3.    Add the build Directory of the package you are about to install to Delphi’s library path.

4.    Locate the package directory associated with your compiler and open the ZeosDbo.bpg project group.
Load the project and compile the following components in the order listed (or just choose compile all
from Project-Menu):

• ZCore.bpl
• ZParseSql.bpl
• ZPlain.bpl
• ZDbc.bpl
• ZComponent.bpl

Continue Reading…

GNU LESSER GENERAL PUBLIC
LICENSE

Copyright (C) 1991, 1999 Free Software Foundation, Inc. 59 Temple Place, Suite 330, Boston, MA 02111-1307
USA Everyone is permitted to copy and distribute verbatim copies of this license document, but changing it is
not allowed.

[This is the first released version of the Lesser GPL. It also counts as the successor of the GNU Library Public
License, version 2, hence the version number 2.1.]

1. Preamble

The licenses for most software are designed to take away your freedom to share and change it. By contrast, the
GNU General Public Licenses are intended to guarantee your freedom to share and change free software–to
make sure the software is free for all its users.
Continue Reading…

ZeosDBO Technical Info

ZeosLib Development Group

ZeosDBO is a database middleware components for Borland development tools, including Delphi, C++ Builder
and Kylix.

The following compilers are supported:

•    Delphi 5 – 7 and 9-11
•    Lazarus (FreePascal)
•    MSEide+MSEgui (FreePascal)
•    C++ Builder 5 – 6
•    Kylix 2 – 3

ZeosDBO supports direct connectivity to the following databases using the vendor provided, native interface:

•    MySQL 3.20 – 5.0
•    PostgreSQL 6.5 – 8.1
•    Firebird 1.0 – 2.0
•    Interbase 5.0 – 7.5
•    Microsoft SQL Server 7, 2000
•    Sybase ASE 12.0, 12.5
•    Oracle 9i
•    SQLite 2.8, 3.5

For other databases we propose to use implemented Active Data Objects (ADO) Bridge.
Continue Reading…

One of DML SQL Command is SELECT.

SELECT is command to show record(s) from tabel in database

Syntax :

SELECT  * FROM TPEGAWAI;

NOTE :

1. SELECT : command to show
2. *  refers to NO,NAME,BORNDATE,ADDRESS,SALARY
3. TPEGAWAI is table name

How to use SQL in Delphi  ADO…?

• Continue Reading…