* * *

Author Topic: Sending Information to database mysql 56 (mariadb 10.2)  (Read 826 times)

jshand2010

  • Full Member
  • ***
  • Posts: 221
Sending Information to database mysql 56 (mariadb 10.2)
« on: January 01, 2018, 07:13:02 am »
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
Manjaro Linux 15.12 Rolling Release, fpc 3.0.1 fixes, lazarus trunk

GetMem

  • Hero Member
  • *****
  • Posts: 3082
Re: Sending Information to database mysql 56 (mariadb 10.2)
« Reply #1 on: January 01, 2018, 08:19:27 am »
Quote
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

  • Full Member
  • ***
  • Posts: 221
Re: Sending Information to database mysql 56 (mariadb 10.2)
« Reply #2 on: January 01, 2018, 09:11:50 am »
thanks getmem.  it works.  i now just have to figure out how to find duplicates in the database.
Manjaro Linux 15.12 Rolling Release, fpc 3.0.1 fixes, lazarus trunk

GetMem

  • Hero Member
  • *****
  • Posts: 3082
Re: Sending Information to database mysql 56 (mariadb 10.2)
« Reply #3 on: January 01, 2018, 09:36:09 am »
Quote
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".   

 

Recent

Get Lazarus at SourceForge.net. Fast, secure and Free Open Source software downloads Open Hub project report for Lazarus