Data Update Component

Completed Posted Sep 24, 2005 Paid on delivery
Completed Paid on delivery

Create a component for RAD of a Master/Detail Forms design application. Bypass placing the component on the form and setting the property the form should basically be done.

## Deliverables

**Spec for creating a Custom Data Update Component for Delphi 7.**

Below is the problem that created the need for this component to be built.

**Problem:**

1. I have 8 large forms that has a Master/Detail design. One Master table to 3 to 20 detail tables per form. There are many physical records that make up 1 logical record. In the database definition cascade update and delete is specifying on the master record all detail tables has foreign keys of the master table.

2. Read-Only mode versus Edit Mode. The data access custom component I am using defaults to read only and handle moving between read-only and edit mode very poorly.

**Solution:**

Create a component that will sit between the data source component and the data access components. This component will manage the access of all the physical records as one logical record. It will also handle the read-only and edit mode problem by allowing the data aware components to act in the same manner as if it was connected to a TTable component. The component will use ONLY SQL to perform it tasks.

The component will handle the following:

· First function

· Last function

· Next function

· Prior function

· Insert function

· Edit function

· Post function

· Cancel function

The above function will have an associated bitbtn component property that I may supply it will the correct button from the Form..

The component will use Borland TQuery and TUpdateSQL components this will make it easy to convert to my custom components.

Events Needed:

* BeforeInsert

* AfterInsert

* BeforePost

* AfterPost

* BeforeDelete

* AfterDelete

List of suggested property:

* FirstBtn TBitbtn

* LastBtn TBitbtn

* NextBtn TBitbtn

* PriorBtn TBitbtn

* InsertBtn TBitbtn

* EditBtn TBitbtn

* PostBtn TBitbtn

* CancelBtn TBitbtn

* Key1Name string Will have the field name that is common to all tables

* Key2Name string

* Key3Name string

* Key4Name string

* Key5Name string

* DataSource TDataSource

* FieldEditor List all the fields and from what tables, also the TQuery and TUpdateSQL,

* WhereClause string

* MasterTable TQuery

* DetailTable1 TQuery must handle up to20 detail tables.

* DetailTable2 TQuery

* DetailTable20 TQuery

* MasterUpdate TUpdateSQL Will has 1 for each TQuery component.

* DetailUpdate1 TUpdateSQL

* DetailUpdate2 TUpdateSQL

* DetailUpdate20 TUpdateSQL

StatusBar TStatus place all messages to status bar.

The component will have a Field Editor sub component where I will be able to specify what table the field belongs to and its TQuery and UpdateSQL component. It will also have a display label property.

All SQL for the TQuery and UpdateSQl will be generated at runtime from the Field Editor information and the where clause for the Master Table query will pass in at runtime from the where clause property.

1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.

2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):

a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.

b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.

3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).

## Platform

Windows xp Delphi 7/ Interbase.

Chrome OS Delphi Engineering Linux Mac OS MySQL PHP Software Architecture Software Testing UNIX Windows Desktop

Project ID: #3905614

About the project

1 proposal Remote project Active Oct 2, 2005

Awarded to:

itlabsvw

See private message.

$170 USD in 28 days
(64 Reviews)
5.7