Sending Information to database mysql 56 (mariadb 10.2)

[jshand2010]

I have set up a mysql (mariadb 10.2)

i use the mysql 56 connection component
i use the tsqlquery component
i use the tsqltransaction component and
i use the tdatasource component

the components are on my login form.  i have my database connection set up correctly.  all the query and transaction connections are active without problems.  i have also managed to set up a datasource without the issue of circular dependency or such like.

on the form i have two dbedit textboxes with the datasource correctly set.

what i want to know is:

how do i send the information i type into the textbox to the database?

please help

[balazsszekely]

how do i send the information i type into the textbox to the database?

Like this:

Code: Pascal  [Select][+][-]

1. tsqlquery.ApplyUpdates;
2. tsqltransaction.Commit;

[jshand2010]

thanks getmem.  it works.  i now just have to figure out how to find duplicates in the database.

[balazsszekely]

I now just have to figure out how to find duplicates in the database.

Just do a quick google search: "find duplicates in a sql table".