Stack Overflow
Stack Overflow

Questions tagged [unidac]

UniDAC, short for Universal Data Access Components, is a library of nonvisual cross-database data access components for Delphi, Delphi for .NET, C++Builder, and Lazarus (Free Pascal).

Resources:

  • Devart's UniDAC section on its official website.
79 questions
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
0 answers

Best way to update detail records from a summary SQL statement in Delphi

What is the recommended way to summarize detail records in a SQLite table like the following SQL code. Have the user review the summarized records, currently in a DBGrid, then once all looks good the user can then highlight the row(s) and press a…
Larry
  • 1
0
votes
1 answer

KBMMW ORM MetaExists(mwmdtTable) not supported

I am trying to create table in MSSQL using kbmMWORM with uniDAC connection. Below is my KbmmWTable definition: [kbmMW_Table('name:DEPT')] TDept = class private FCoGroup:string; FDeptCode:string; FDeptDesc:string; public …
Shely
  • 5
  • 3
0
votes
1 answer

Direct connection to Firebird with IBDac/UniDac from Android using Delphi

I'm trying to connect to a REMOTE Firebird Database from Android using Delphi and IBDac. It says that cannot find libfbclient.so.3.0.2 library. I put it in the deploy to all library paths and nothing. If I remove the library it doesn't connect…
Fon
  • 33
  • 8
0
votes
1 answer

When uniQuery is opened, why DataSource.onDataChange trigger 2 times?

I've a question about unidac's uniQuery: when uniQuery open, if a DataSource component is linked, the DataSource.onDataChange will trigger 2 times, and ADOQuery trigger just 1 time, why? Environment: uniDAC：6.4, 7; delphi: 7, xe 10.1 berlin
d5f
  • 1
  • 1
0
votes
0 answers

How works UPDATE SQL from MASTER-DETAIL on TClientDataSets - DELPHI XE3 DATASNAP

I'm creating a simple Master-Detail relationship with ClientDataSets on Delphi XE3 + SqlServer. I have configured Master-Detail through DatasetField at the client application and with the property MasterSource in the Detail TUniQuery at the server…
M. Adriz
  • 1
  • 1
0
votes
1 answer

UniStoredProc1:Field'_COLUMN1' not found (on android)

I am able to get all the fields that my stored procedure (UniStoredProc1) is supposed to receive from the SQL Server. This is the stored procedure : declare @Navadna int ... select @Navadna = COUNT(diet) from Mytable where diet ='1'; ... select…
user763539
  • 3,509
  • 6
  • 44
  • 103
0
votes
1 answer

Delphi and UniDAC embedded MySQL connect string

I have a problem with connecting Devart UniDac with embedded mySQL database. The code goes: basedir := GetCurrentDir + '\mysql'; UniConnection1.ProviderName := 'MySQL'; UniConnection1.Database :=…
Aleksandar
  • 48
  • 5
0
votes
1 answer

Code for UPDATE and DELETE in delphi uniquery

I'm trying to update and delete my record. I'm using dbgrid as to show the database and i use uniquery to do the query. I managed to do the insert query but not with the update and delete. Here is my code : unit Unit1; interface uses …
Rod
  • 53
  • 1
  • 1
  • 5
0
votes
0 answers

Delphi 2010 : UniDAC vs Indy-MultiThread safety handleing method

I am doing develop Indy based application. Server has several Indy TCP Server components. So It works under multi-threads and handles mysql db. I have faced one problem. That is about the exceptions of MySQL DB in threads. When serveral threads…
david chan
  • 31
  • 5
0
votes
2 answers

Delphi : Connecting to an Excel File with UniDAC

I want to connect to an Excel file with UniDAC I have set Provider property of UniConnection to "ODBC" and Server property to "Excel Files" but there is no option to set Excel File Address How can I Connect to an Excel File with UniDAC ? is it…
Mahmoud_Mehri
  • 1,643
  • 2
  • 20
  • 38
0
votes
2 answers

IBDAC / UniDAC + interbase 6 or 7 + a table field named "returning"

I am porting REALLY old code to use the UniDAC components. I have hit a wall with a specific UPDATE sql that changes a field named "returning." Simply wrapping the field in quotes does not resolve the issue, because the SQL dialect in the database…
Stamp
  • 89
  • 9
0
votes
1 answer

How to get value of an Output Parameter of a MySQL SP with TUniSQL

I have created a Stored Procedure in a MySQL DataBase that have 2 output parameters like this (for Example) : CREATE PROCEDURE `invite_user`(fUName VARCHAR(15) CHARSET utf8, fRegCode VARCHAR(15) CHARSET utf8, fEmail VARCHAR(30) CHARSET utf8,…
Mahmoud_Mehri
  • 1,643
  • 2
  • 20
  • 38
0
votes
2 answers

MySQL : start Transaction if a condition was true

I want to execute some runtime-generated SQL commands in a Transaction, there is no problem, but I should start this transaction if a condition was true, for example : SQLText := 'IF (SELECT COUNT(ID) FROM desk_table WHERE Status = 1 AND Number =…
Mahmoud_Mehri
  • 1,643
  • 2
  • 20
  • 38
0
votes
1 answer

Refresh Queries in Threads

I`m using Delphi XE6 and UniDAC and MySQL I have some TUniQuery components in my DM and I want to Refresh theme repeatedly, so I put some Timers in my main form and in each timer I create a thread and pass a query to it for refreshing data : for…
Mahmoud_Mehri
  • 1,643
  • 2
  • 20
  • 38
1 2 3
4
5 6