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
1
vote
2 answers

PostgreSQL serial (autoincrement) with UniDac on Delphi XE2

I am migrating our Delphi XE2 application from MSSQL (using ADO components), to PostgreSQL, using UniDAC. In database, there are some serial type fields (autoincrements). When I append record, I not put any data to this autoincrement field. Formely,…
Andrey
  • 2,659
  • 4
  • 29
  • 54
1
vote
2 answers

Delphi edit unicode table data

My Delphi application using PostgreSQL database (with UniDac components). Data are stored in UTF8 in database. To read international characters, I use this handler: procedure TdmMain.OnGetText(Sender: TField; var Text: String; DisplayText:…
Andrey
  • 2,659
  • 4
  • 29
  • 54
1
vote
2 answers

Display Firebird exception message only

I have a stored procedure that is called from a before update trigger. In this procedure I check for some condition, if met an exception is thrown The problem the exception display many data I don't want to show to the user: exception 4 …
zac
  • 4,495
  • 15
  • 62
  • 127
1
vote
1 answer

Strange filter behavior in DevExpress grid

I have a form with 2 grids showing records selected using master-detail option on Devart UniQuery. This working very nice showing the wanted records in detail that relates to master. I have the option to select records (companies) using a filter.…
OZ8HP
  • 1,443
  • 4
  • 31
  • 61
1
vote
1 answer

DELPHI / ACCESS SELECT SQL ERROR

im using a UNIDAC TUniQuery component, this is my sql: q_ContribSem2.Close; q_ContribSem2.SQL.Clear; q_ContribSem2.SQL.Add('SELECT SUMINISTRO.SUMTITIPOPERSONA, SUMINISTRO.SUMCHRAZONSOCIAL,…
Americo Torres
  • 23
  • 3
0
votes
1 answer

Performance Issues Using TUniTable

I'm in the process of converting a Paradox database application written in Delphi to use SQL Server 2008 R2. We are using the UNIDAC components from Devart to access the database/tables. However, I am finding the performance rather slow. For…
PDM
  • 503
  • 2
  • 12
  • 27
0
votes
1 answer

Error when connecting unidac 4.0.1 with sqlite database

I'm delphi user, i got problem when try to connect sqlite with my unidac 4.0.1 component. I've dropped TUniConnection, Sqlite uniprovider, setting client library at specification property, but it always raised an error: file is encrypted or is…
Abdullah Al- Arief
  • 39
  • 5
0
votes
1 answer

How to retrieve two or more fields by using TUniQuery in Delphi/MongoDB?

How to retrieve two or more fields by using TUniQuery (from UniDAC Library) in Delphi accessing MongoDB? Example: when using MongoSH, it's possible to do equivalent retrieve like this: db.myCollection.find({}, {Id: 1, Number: 1}) Result is: { …
wBB
  • 821
  • 1
  • 18
  • 39
0
votes
0 answers

Delphi and UniDAC MySQL connect string

How can I make an ini file to connect TO mySQL databases. I'm using UniDAC comments from a Delphi 10.4 app. I need help, I need the code
Mohamed ELbadry
  • 1
  • 1
0
votes
0 answers

How to get InsertedID from UniQuery's UpdateSQLs statement

I am using Uniquery in delphi-rio. UniQuery's SQL.Text is: Select ID, Column1 From Table Here ID is an auto-incrementing ID. The insert statement in UpdateSQLs is: INSERT INTO table (Column1) VALUES (:Column1) SET :ID = SCOPE_IDENTITY() After…
jeongSoo
  • 1
0
votes
0 answers

How to read UniDac .log files (database dumps) with python

I have an old delphi program exporting electrical measurement data from a device as .log files as a database dump. I need to convert them to .csv or any other easily accessible dataformat. As I have no access to the source code, my options to find…
Patrick Lehnen
  • 80
  • 5
0
votes
0 answers

How get the row that causes the error when Appling Updates

I have a TUniquery in CachedUpdates mode when applying updates with ApplyUpdates an exception is raised due to a Database constraint, is there a way to get the record that causes the error? Edit : Trying to migrate from FIBPlus where the…
Fouad Loucif
  • 31
  • 4
0
votes
0 answers

Action On Device Wake Up to Re-establish Socket Connection

I've built an Android application using Delphi 10.4. In it, I have an SQL Server connection using an SDAC database connection. My issue is when the device goes to sleep, the network connection suspends. And when I wake the device up, the connection…
Mark Lyder
  • 45
  • 5
0
votes
1 answer

Delphi Unidac MySQL Create Trigger From Memo Code Syntax Error

Here is my MySQL Trigger code; DELIMITER // CREATE TRIGGER pdfdenemeu BEFORE INSERT ON denemetbl FOR EACH ROW BEGIN SET NEW.iki = CONCAT(NEW.bir,'.pdf'); END// DELIMITER ; When i run this code on HeidiSQL it creates trigger and works…
Sheshman
  • 88
  • 3
  • 10
0
votes
1 answer

Does TUniQuery (UniDac TUniQuery) Last and First methods jump directly or do a record by record scroll

I have a program that must set up a more less complex screen after the user goes to a certain record in a dataset (TUniQuery). The user can jump on many ways: a combobox, search box and finally a DbNavigator. Going from the first to the last record…
alvaroc
  • 433
  • 5
  • 14
1 2
3
4 5 6