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

SQL Query output to a variable in Delphi?

I Would like to know how Can I put the SQL Query result into a variable. I'm aware of this integerVariable := UniQuery1.RecordCount; but this? integerVariable := SELECT COUNT(*) FROM Orders WHERE Amount='1000'
ed tru
  • 101
  • 1
  • 2
  • 7
3
votes
2 answers

TTable and lookup fields performance issue

I have a TTable (actually a UniDac TUniTable) which has the table fields plus 2 lookup fields from another table (Mysql). I have set up the correct indexes and the table loads very fast. The problem is when I manually edit a field…
George K
  • 35
  • 3
3
votes
1 answer

How can I read blobfield without freezing?

I want to read blobfield (with blobstream) from client side (over network) but application freezes while fetching data. How can I read blobfield without freezing and showing percentage with a progressbar. (I'm using Delphi and Firebird) i'm using…
user3205651
  • 31
  • 2
3
votes
1 answer

How to enable UTF-8 to Unicode translation?

Database: utf8 Collation: utf8_general_ci I have the following problem: When I execute my query everything is written correctly to the table except the Chinese characters and Cyrillic characters shows me only in the table field "???????". Is…
Hidden
  • 3,598
  • 4
  • 34
  • 57
3
votes
2 answers

Check active transactions in MySQL

Is there a way to check the number of active transactions (on the database, not on the local UniConnection component) at any given time, using MySQL + UniConnection? I'm trying to avoid deadlocks from extended operations and this way I could make…
Miguel E
  • 1,316
  • 2
  • 17
  • 39
3
votes
1 answer

Unidac 5.0 performance degradation

We migrated from UniDAC 4.1 to 5.0 (simply rebuilded or app with new version) and catch huge degradation in our datapump routines. Running pgfouine catch many queries like: SELECT current_database() AS DATATYPE_CATALOG, n.nspname AS…
Igel
  • 63
  • 7
3
votes
2 answers

How to add a non-bound column to a DevExpress DB QuantumGrid

I am using these components: UniDac for connection to mysql database DevExpress for QuantumGrid IDE: Embarcadero Rad Studio XE2 I have a cxGrid component with one level and a cxGrid1DBTableView specified as the level's View. I can get data from my…
AirWolf
  • 597
  • 7
  • 27
3
votes
1 answer

Visual SQL query Builder for Delphi 2010 and Unidac

We are seeking a freeware or opensource Visual SQL Builder for Delphi 2010 and Unidac We currently allow our clients to perform SQL against our application's database using a standard Memo field and peform button. We would like to enhance this…
Blow ThemUp
  • 895
  • 6
  • 18
  • 29
2
votes
2 answers

How can I replace WHERE IN choices in WHERE clause to reduce execution time of the request?

I am using DBF database in a C++ project written on RAD Studio 10.2 Tokyo. To make request on this database, I am using UniDac Devart component (that is a little bit limited compared to MySQL itself). The problem I have is when using WHERE IN…
development
  • 23
  • 4
2
votes
2 answers

obtain the real identity of the connected user

dxStatusbar1.Panels1.Text := DataModule2.UniConnectDialog1.Connection.Username; ...gives me the username that has connected to sql server. However the connected user has a different name in the actual database. Example: His login name for the…
user763539
  • 3,509
  • 6
  • 44
  • 103
2
votes
1 answer

Get an OUT BLOB type Parameter of a Stored Procedure as TStream

I have a stored procedure on my MySQL Database with 2 OUT parameters as Blob type I want to get their values as TStream with UniDAC`s SP component, I have tried this code for testing : SP := TUniStoredProc.Create(nil); M := TMemoryStream.Create; …
Mahmoud_Mehri
  • 1,643
  • 2
  • 20
  • 38
2
votes
1 answer

UniDac doesnt find stored procedure schema

I have used UniDac VCL components for Delphi for a year now but recently started quite a big project with SQL Server 2012 and I want to separate the tables and stored procedures in different schemes my whole logic is in stored procedures so no…
AirWolf
  • 597
  • 7
  • 27
2
votes
2 answers

Fastest way to query repeatedly big table

I have a table with 50 million records, but a compact structure (id, int1, int1, int2, int3). All relevant indexes are implemented. I need to query it about 50 times for each user interaction. This is taking about 5 seconds, using regular prepared…
Miguel E
  • 1,316
  • 2
  • 17
  • 39
2
votes
2 answers

UniDac on PostgreSQL: no value on serial (autoincrement) field after insert

In my application user have ability to add some records to database. I'am using UniDac 4.6.12 components. For autoincrement field, we are using serial PostgreSQL type and I don't touch value of this field in my application. But, after Post of…
Andrey
  • 2,659
  • 4
  • 29
  • 54
2
votes
1 answer

Delphi: SQLite and UniDac

Need to store some data in SQLite. To work with SQLite chose UniDac, but there is a problem: when in the UniConnection, in the field "Database", I choose SQLite and enter the name of the database - get the error "Unsupported metadata kind". Database…
dedoki
  • 709
  • 4
  • 14
  • 24
1
2 3 4 5 6