How to Use Delphi Multi-Tier Database Application Code Generator

Delphi Multi-Tier Database Application Code Generator 0.9

--Bear,.11.25

DMPCG is a FREE code generator for Delphi developers.

When developing MIDAS project, we need develop the Application Server and Client Application.

We need put Dataset component and Provider components for each table on Application Server side.

We need put ClientDataSet and DataSource components for each table on Client application side.

We need put DataAware components for each table and field on Client application side too.

We need give each component a readable name regarding its table name or field name.

If you have a lot of tables in database to deal with, it may take you several days.

DMDACG can do all of these work for you in several minutes.

The more tables you have, the more time it save for you.

How does DMDACG work?

=====================

1. Copy project template directory to output directory.

2. Connect to database via UDL file or connect to Access MDB file directly.

3. Replace the variable block in template and insert some code blocks:

On Server Side:

A. Each table will have a DataSet and DataSetProvider components in RemoteDataModule

B. Each DataSet will have persist field components.

The first field will be looked as Primary Key.

On Client Side:

A. Each DataSet will have persist field components.

The first field will be looked as Primary Key.

If the filedname is like *ID, we guess it is a Foreign Key, there will be a DBLookupComboBox for it.

B. Each table will have a form with DBGrid for the table and DBEdit components and Label components for each field.

C. There will be a form to hold all of the DBGrid components.

4. All of the component will be named well by the table name or field name.

For example : Client_Frm, Client_DBGrid, Client_DBEdt, Client_Lab, etc.

5. You can change all of the default name format strings in NameFormat.ini

How to Use the DMDACG?

======================

1. Select template directory, you can select the default template directory: \MidasProject

In fact you can edit the code in template directory to add more functions.

2. Select output directory

3. Select UDL file or mdb file

You can also edit the database.udl and let it point to your own database,

And then select the UDL file.

4. Select FieldName and DisplayText Map File, it is a text file. (Optional)

If you use PowerDesigner to design the database, you can copy the field names and codes from the data item list to a text file.

5. Change other options. (Optional)

6. Click "Generate Project Source Code" button.

How to Use the output projects?

===============================

There will be two projects in the output directory.

One is for application server and another is for client GUI application.

1. Open the Application Server Project, run it to register the Remote Data Module COM.

Then close it.

If there is a "Database.mdb" file, The RDM will use it as the database, or it will use

"DataBase.udl" file as the data connection file to connect to database. See the source code.

2. Open the Client GUI Project, open DataModule, select the ServerName from the CombboBox for the DCOM Connection.

By default, the Connection Broker use DCOMConnection because it is handy to debug.

You can use other connection too.

And there is a Config.ini file in Exe directory.

The client will read it at runtime to decide use which connection. (DCOMConnection,SockectConnection or WebConnection)

3. Run the Client GUI Project,

you can edit the the data and post for each table now!

4. Redesign the forms or copy and paste these components to your own forms.

 
Delphi Multi-Tier DB Application Code Generator
Delphi Multi-Tier DB Application Code GeneratorBear Code Generator Main WindowWe need input at least there parameters: Template Directory, Output Directory and UDL filename.Here the Database.udl conne...查看完整版>>Delphi Multi-Tier DB Application Code Generator
 
How to use pointer in C++
仔細看一下這種聲明方式,確實有點讓人迷惑。在某種意義上,"*"和"&"是意思相對的兩個東西,把它們放在一起有什麽意義呢?。爲了理解指針的這種做法,我們先複習一下C/C++編程中無所不在的指...查看完整版>>How to use pointer in C++
 
how_to_use_ant_query_data_and_mail
下面的示例是一個用Ant執行數據庫查詢並通過Javamail發送郵件的例子,要完成相同的功能,請先安裝下列步驟執行操作: 1、安裝j2sdk1.4.2,並設置path和classpath 2、安裝Ant161,加到path中去。 ...查看完整版>>how_to_use_ant_query_data_and_mail
 
Oracle9i新特性spfile之一 -How to Create and use spfile
在Oracle9i中,一個新的文件被引入-spfile,spfile用于服務器端,管理初始化參數。在9i以前,Oracle使用pfile存儲初始化參數設置,這些參數在實例啓動時被讀取,任何修改需要重起實例才能生效,使用spfile你可以使用ALTE...查看完整版>>Oracle9i新特性spfile之一 -How to Create and use spfile
 
How to avoid AV error when developing Delphi database Application
How to avoid AV error when developing Delphi database Application How to avoid AV error when developing Delphi database Application How to avoid AV error when developing database Application--...查看完整版>>How to avoid AV error when developing Delphi database Application