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
0
votes
1 answer

Execute proc using MyDAC

I am having trouble on executing simple procedure on MySQL server using my dac components in c++ builder 2010. I have found an example in delphi over here http://stackoverflow.com/questions/3704173/return-value-of-stored-functions-in-mydac but I…
Suhrob Samiev
  • 1,528
  • 1
  • 25
  • 57
0
votes
1 answer

Unidac / MyDac / SQL - I have problem with fast insert about 1000 rows

I use unidac components. And i have problem with fast insert about 1000 rows. var query: TUniquery; begin query.SQL.Add('INSERT INTO Table (field1,field2,field3) VALUES (:b0,:b1,:b2);'); for I := 0 to 1000 do begin …
lcdk
  • 59
  • 2
0
votes
2 answers

Delphi - MyDAC - Fast Report

I have no problem generating a report from a MySQL query or table. The problem starts when I want to add a variable in the report in each row. For example, table "PRODUCTS": ID|PRODUCT-NAME|SHELF-LIFE What's the best practice if I want to generate…
Michael Virdis
  • 3
  • 1
0
votes
0 answers

use Devart MyDac on android device

I are trying to use MyDac on my andriod delphi app but I keep running into a loss of vital information. I need a file libmysqld.so in the application executable file location whish to me is $Plateform\debug folder of my project. But I cannot find…
Daniel Rogers
  • 39
  • 8
0
votes
1 answer

Return value of stored functions in MyDAC

I am working with Devart's MyDac and MySQL Server 5.0.41. Here is a section from the documentation on executing stored procedures with TMyConnection.ExecProc: Note: Stored functions unlike stored procedures return result values that are obtained…
NicM
  • 169
  • 2
  • 12
0
votes
2 answers

documentation, pointers on TMyTable.Open in MyDAC

I am learning Devart's mydac Data Access Components and I have few question I have not been able to resolve through online searches and the documentations. In the code examples, I see invocation of TMyTable.Open but I could not find the description…
NicM
  • 169
  • 2
  • 12
0
votes
1 answer

How can I tell if my connection is using SSL?

I'm using code from a demo program using Devart's MyDac component using Delphi 2009 to connect to a remote database using SSL. I have made and verified the certificates and keys and set the connection parameters in MyDAC to use them…
user3209752
  • 619
  • 2
  • 17
  • 29
0
votes
0 answers

MySQL IFNULL and date comparison glitch?

I have od_bulk table my InDate column defined as DATE. Running the following query SELECT IFNULL(InDate, CURDATE()) ReturnDate FROM od_bulk generates the following error message Type of value has a mismatch with column typeCouldn't store <2/27/2012…
Garik M
  • 1
  • 2
0
votes
2 answers

In Delphi using MyDAC, how do I write an entire record as a string?

As the title suggests, using Delphi 2010 and MyDAC 7.1, how do I output an entire string as a string like JSON / XML / CSV or some other plain text option? eg output: {user_id:1;username:testuser;password:testpass}
SupaMonkey
  • 876
  • 2
  • 9
  • 25
0
votes
1 answer

Delphi: How to load the contents of the table (mysql) into an Array [1..50] of Float?

I have a table in a datasource module using MyDAC. I want to load the contents of the table, column months with 50 rows into an Array [1..50] of Float. How can I do this? This is the code of my datamodule unit: unit Unit2; interface uses …
Artur_Indio
  • 736
  • 18
  • 35
0
votes
1 answer

Error 42000 Mydac TMyquery sql script wrong parse

Need help Mydac TMyquery not work this script in navicat and sqlfiddle work but tmyquery not work SET @@group_concat_max_len = 32000; SELECT group_concat(concat('sum(ifnull(if(s.id=',s.id,',m.qty,0),0))`',s.sizes,'`'))eval, …
user2662676
  • 1
  • 1
0
votes
3 answers

Program with FastReport using MyDACDatabase doesn't work

I'm using the MyDACDatabase components to connect my report build with FastReport 4 to my MySQL database. I can edit it normally and test in the FastReport designer when using my Delphi's IDE, even compile the application, but when I open the form…
llanfair
  • 1,845
  • 4
  • 27
  • 43
0
votes
2 answers

Use Rave with MyDac

I'm using Cbuilder XE and I want to use Rave Report with Mydac component but it seems to me that Rave recognize only the standard TQuery component and ignore the Mydac versions. I would ask you if there is a way to feed a Rave report using TMyQuery…
enzo1959
  • 409
  • 2
  • 5
  • 13
0
votes
1 answer

Credit system to make application in database (MyDAC)

I want to make a credit system. If have user credits "warning: you have credit! quantity: [Jeton value in column]", If have not user credits "warning: you have not credit!" I used MyDAC Components Jeton: User credit column.(In database) How do I…
Ankara
  • 27
  • 2
  • 6
-1
votes
1 answer

How to insert data into a MySQL table in MyQuery (Delphi)

I am doing mysql connection by establishing a user-registration application. I use Delphi 7. Myquery (MySQL Access Set) have a problem with adding user information. MyQuery1.SQL.Clear; MyQuery1.SQLInsert.Add('INSERT INTO uyeler (nick) VALUES…
Ankara
  • 27
  • 2
  • 6
1
2