Sending Information to database mysql 56 (mariadb 10.2)
lazarus / 16-Databases

----------------------------------------------------------------------
jshand2010 · 2018-01-01 06:13

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 · 2018-01-01 07:19

Quotehow do i send the information i type into the textbox to the
database?Like this:
Code: Pascal  [Select][+][-]window.onload = function(){var x1 =
document.getElementById("main_content_section"); if (x1) { var x =
document.getElementsByClassName("geshi");for (var i = 0; i
tsqlquery.ApplyUpdates;tsqltransaction.Commit;

----------------------------------------------------------------------
jshand2010 · 2018-01-01 08:11

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

----------------------------------------------------------------------
balazsszekely · 2018-01-01 08:36

QuoteI 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".