Stack Overflow
Stack Overflow

Questions tagged [mydac]

MyDAC are Data Access Components for MySQL Editions for Delphi.

MyDAC components are written by

Resources:

  • Devart's page for MyDAC.
30 questions
4
votes
2 answers

Using multithreading for making queries in Delphi

I've been recently applying threads for making queries to a MYSQL database, I use MyDAC for connection to DB, 'cause TMyConnection doesnot let making simultaneously queries per a connection, I create a new connection and a new query object per every…
Billiardo Aragorn
3
votes
1 answer

Giving the content of ca.pem file as hard coded string in delphi for SSL connection

I have a MySQL server and I have the client certificate and keys for SSL connection to the MYSQL server. In delphi that uses MyDAC for connecting to mysql, I can use: MySQL1Connection.SSLOptions.CACert := 'file…
user6725114
  • 93
  • 7
3
votes
3 answers

Experience with direct data access components

I would like to know as to what has been the experience of using direct data access components like devart's MyDAC which allows a direct connection to the mysql server rather than through the client library or ODBC.
Vinayak Mahadevan
  • 191
  • 1
  • 7
2
votes
3 answers

Delphi 2009, MyDAC and relational database

I have quite a problem concerning the use of relational database concepts in Delphi 2009 with MyDAC. I have a database structure that looks somehow like the following: Item id …
Kevin Dungs
  • 1,555
  • 1
  • 13
  • 18
2
votes
2 answers

Define custom POST method for MyDAC

I have three tables objects, (primary key object_ID) flags (primary key flag_ID) and object_flags (cross-tabel between objects and flags with some extra info). I have a query returning all flags, and a one or zero if a given object has a certain…
Martijn
  • 5,471
  • 4
  • 37
  • 50
2
votes
1 answer

Coverting a TMyQuery dataset to TClientDataSet in Delphi

I make use of the Mydac components by devart (corelab) to access MySql from Delphi (2006) Very often I need to work with data in a TClientDataSet What is the best way to convert the dataset of a TMyQuery to TClientDataSet Currently I am…
Charles Faiga
  • 11,665
  • 25
  • 102
  • 139
2
votes
1 answer

Filling a TListBox with a column from a database query

I created a table in my database with MYDAC components and added data. How can i extract these values that in colums from this table? i tried these but they didn't work; MyQuery1.Close; MyQuery1.SQL.Text :='SELECT * FROM uyeler ORDER BY site'; …
Ankara
  • 27
  • 2
  • 6
1
vote
0 answers

How can I control which field are being updated?

I'm using TMyQuery component (from MyDAC suite) with the this sentence: SELECT id, name, salary, ‘n’ as modified FROM employees If I change the fields SALARY and MODIFIED I would receive the error “Unknown column MODIFIED in field list” OK. One…
Elivaldo
  • 93
  • 4
1
vote
0 answers

See prepared TMyQuery SQL string

I just want to preface this by saying I do not think it's possible, but I want to ask just to verify. Much like with PDO, we use the TMyQuery's 'params' property to prepare SQL statements prior to execution. Is it possible to see the 'final' SQL…
ConBran
  • 369
  • 2
  • 15
1
vote
1 answer

MySQL roles don't work in a Delphi application

I am using MariaDB10 with DBForge and creating a Delphi Project, I created a role to manage the permissions but it's not working good. 1 - Create a role on DbForge panel with a permission for a procedure myprocedure 2 - Add a Tmyquery in my Delphi…
BDuarte
  • 129
  • 11
1
vote
1 answer

How to read MYI, MYD, frm

I'm complete beginner no experience with mySql at all. I've got some MYD, MYI, frm files containing measurements done by my machine. Could someone tell me step by step how to open those files? Ideally would be if someone would give me instruction…
Lobo1908
  • 97
  • 2
  • 8
1
vote
1 answer

MySQL time_zone 'current session' - is it IP or Connection?

I have a project that is, intermittently, changing the time_zone value from a user defined value, to SYSTEM, and I am trying to determine if MySQL considers 'the current session' (MySQL TimeZone) the connection, or, the workstation IP that the…
ConBran
  • 369
  • 2
  • 15
1
vote
1 answer

Embarcadero Delphi Xe5 Ide Split in two

Hi guys i have just installed Mydac into my delphi xe5 Ide and when i started it up afterwards the entire IDE Changed. It has split in two in basic terms it looks alot like delphi 7 now. When i compile the app i am working on. The IDE returns to…
Marcel
  • 874
  • 1
  • 14
  • 28
1
vote
1 answer

Unable to connect to mySql database useing just code

I searched here but did not see an answer . I am using Delphi2010. I using Devart Mydac to connect to mySql data base . When i set the Server, Database, Name , Pass in the component it connects no problem. BUt when I try to connect just with code it…
grant1842
  • 357
  • 1
  • 7
  • 23
0
votes
0 answers

Delphi losing mysql connection after some idle

I am using MyDac to connect MySQL and my Delphi Project, here is what is happening: When I start the application, everything works fine but after some idle if I try to make a new search I get the error: 'Acess denied to user for routine…
BDuarte
  • 129
  • 11
1
2