Build a Delphi SQL component

Create a Delphi component that should associate several controls from a Form and execute specific SQL commands.

For a better understanding you can see bellow a proposal with the structure of this component:

TSodaSqlForm [TComponent]

-------------------------

FDConnection

+Buttons

|-BtnDelete

|-BtnModalOK

|-BtnModalCancel

|-BtnModalDelete

|-BtnNewEntry

|-BtnSave

+SqlCommands

|-Select

|-SelectLastId

|-Delete

|-Insert

|-Update

+Fields -> Field ----

|-Associate

|-AssociateLabel

|-DataType (dtString,dtCardinal,dtInteger,dtInt64,dtReal,dtBoolean,dtText,dtDate,dtTime,dtDateTime,dtBlob)

|-Name

|-Value

|-ValueDef

|-Enabled

|-Visible

|-ReadOnly

|-Password

|+SqlField

|-Name

|-Table

|-Alias

|-FieldType (ftNormal,ftId,ftDeleted,ftInactive)

|+SqlConstraints (set of cnAutoIncrement, cnPrimaryKey, cnUnique, cnNotNull)

|+SqlCommands

|-SelectPrimaryKey

|-SelectUnique

|+Format

|-CurrencyStr

|-Decimals

|-UseThousandsSeparator

|+InputValidator

|-Active

|-InputSpecial (isNone,isZipCode,isPhoneNo,isName,isEMail,isPassword)

|-ValueMin

|-ValueMax

|-MaxLength

|-NotNull

Attached you can see a picture with a form, some buttons and some controls. All this elements are associated to this component and when for example the save button is pressed then information from fields should be added to database. Component must be delivered with source code.

Taidot: Delphi, Ohjelmointi, SQL

Näytä lisää: delphi database connection tutorial, system data acquisition concentrator, san diego audi club, what is sdac, student document assistance center, delphi sql server example, delphi sql server connection string, state disability advisory committee, create link formidable form wordpress, create joomla component php form, customize create account link login form joomla, access create map link based form, create joomla component form, create customize link joomla form, create link autofill form

Projektin tunnus: #15237362