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.
I have 7+ years in database development with very good experience.
Relevant Skills and Experience
I am good in Delphi, SQL
Proposed Milestones
€500 EUR - Cost