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

How to pass NULL value from Unidac Query component in Delphi?

When I am using StoredProc component in Delphi using ParamByname('ParamName').Clear I'm able to send NULL value. But how can I pass NULL value when using a Query component? with Query do begin SQL.ADD('exec…
SSE
  • 445
  • 2
  • 10
  • 29
1
vote
2 answers

Is Raise error is not working in Unidac Components with Sybase 12.5 Client Libraries

We are using Unidac Stored Proc Component in Delphi 10 with Sybase 12.5 drivers In Sybase proc we are raising error like below,i found it is retruning back but it not showing error message.Isthis not working in Unidac or any other issue? if @number…
SSE
  • 445
  • 2
  • 10
  • 29
1
vote
1 answer

TUniTable/TFDTable.Filter wildcard limitation - like '[AB]*'

Please help me with filter option. Is it possible to use the wildcard option Client like '[AB] *' for records that start with 'A' or 'B'? This option works in Access, but it does not work in Unidac Table or FireDac Table as Filter.
Jiří Baudyš
  • 21
  • 2
1
vote
2 answers

Ask query from Delphi with UniDAC components in two SQL Server databases on same server

I want to run a query with TUniQuery (UniDAC components) in two SQL Server databases located on the same server. I think two TUniConnections must be linked on the same query component. Is there any other way to get simultaneously data from both…
GBAKAS
  • 61
  • 1
  • 2
  • 4
1
vote
1 answer

Delphi FMX - Android API 26 - SQLite DB Connection with UniDAC

I'm using Tokyo 10.2.3 and UniDAC component for interacting with an SQLite database on Android API 26 Platform. So far, with the help from Dave: http://www.delphiworlds.com/2018/06/targeting-android-8-and-higher-continued/ ... the App worked fine…
Beaker
  • 11
  • 3
1
vote
2 answers

Why I can not connect to mongodb from unidac?

I am trying to connect to mongodb from Devart unidac components and I supplied server name like this, I right click on the UniConnection1 and choose "connection editor" and I enter connection…
zac
  • 4,495
  • 15
  • 62
  • 127
1
vote
0 answers

Delphi XE7 unidac rounding issue

In my below delphi code, which is compiled in XE7 and with unidac version 7.0.2 : cAmount : Currency; cAmount := Query1.FieldByName('AMOUNT').AsCurrency; Sometimes i get very weird values in cAmount. For example if the Amount value in the…
Binitta Mary
  • 134
  • 3
1
vote
3 answers

Count in Firebird 3.0 bigint vs Firebird 2.5 integer

On my system, after the migration from Firebird 2.5 to 3.0, many reports and other functions began to give problems stating that what was expected was Integer and the current one is LargeInt. I took a look and saw that some searches with the count…
sounobre
  • 420
  • 1
  • 6
  • 16
1
vote
0 answers

Firebird SQL SUBSTRING : "expression evaluation not supported

I'm trying to run the following query on a database to replace the leading characters of certain rows. UPDATE table SET path = :newpath || SUBSTRING(path FROM :pathlen) WHERE path STARTING WITH :oldpath So for parameter :newpath = foo, :oldpath…
Roddy
  • 66,617
  • 42
  • 165
  • 277
1
vote
0 answers

What happens if I call ParamByName for a parameter that has multiple locations in a query?

I have a runtime created query that may or may not need some specific params to be used more than once. If I use ParamByName in a query like select field1 from table1 where field2 = :a and field2 in(select field3 from table2 where field3 =…
Miguel E
  • 1,316
  • 2
  • 17
  • 39
1
vote
1 answer

Parameter RowsAffected is not reliable. Why?

I am using UniDac and I perform an Update instruction on MySQL server. I am doing it simultaneously by two clients. I wanted to know who updated record in the first place, so I was checking parameter RowsAffected and I thought that if one peer will…
Flash
  • 466
  • 6
  • 16
1
vote
1 answer

Calculated fields are empty when using unidac in delphi 7

I am using unidac components in a Delphi 7 project to connect to a SQLite database. Connecting and quering works fine, except for calculated fields. My query is this : select c.CardID, c.FirstName, c.SurName, c.Street, c.City, …
GuidoG
  • 11,359
  • 6
  • 44
  • 79
1
vote
2 answers

Delphi FormatFloat different behavior (variable & dataset)

I have found a strange behavior of Delphi's FormatFloat function. Let me show the case study. value to be converted : 129809.495 formatted output desired : 129,809.50 Case 1 : Converting from a string var str: string; str := '129809.495'; str :=…
saintfalcon
  • 107
  • 2
  • 15
1
vote
1 answer

How to create UniDac MySQL components in console application?

As preliminary information: I've never used a component which i can drag & drop to the formular designer in a console application. At the moment i use: UniConnection UniQuery UniDataSource MySQLUniProvider My question is now: How can i create…
Hidden
  • 3,598
  • 4
  • 34
  • 57
1
vote
1 answer

Avoid deadlocks MySQL/UniDAC/Delphi

I'm using UniDAC (Devart) in 2 applications accessing a MySQL database. During some heavy update update operations made by one application, occasionally I get an Error "#40001 Deadlock found when trying to get lock; try restarting transaction" in…
Miguel E
  • 1,316
  • 2
  • 17
  • 39
1
2
3 4 5 6