Stack Overflow
Stack Overflow

Questions tagged [anydac]

www.anydac.com - Firebird, SQLite, Advantage, SQL Server, Oracle, PostgreSQL, MySQL, DB2, ODBC, dbExpress high-speed data access components for Delphi.

AnyDAC was developed by DA-SOFT Technologies and is an unique set of Universal Data Access Components for developing database applications on Delphi, C++Builder and FreePascal.

AnyDAC enables native high-speed direct access from Delphi to Firebird, SQLite, MySQL, SQL Server, Oracle, PostgreSQL, DB2, SQL Anywhere, Advantage DB, Interbase, Access, Informix and more.

In 2013 AnyDAC was sold to Embarcadero, renamed FireDAC and limited to only support Delphi platform.

References

40 questions
0
votes
1 answer

AnyDAC (FireDAC) - Open transaction after TBlobField.GetAsString

at the moment we are migrating the database component of our Delphi7 application from the BDE components to the AnyDAC (FireDAC) Version 8.0.5 components. The following prerequisites are given: On our form we have one TADConnection, one TADQuery…
Mr.Darcy
  • 11
  • 2
0
votes
1 answer

AnyDAC - Refresh record before editing

at the moment we are migrating the database component of our Delphi7 application from the BDE components to the AnyDAC Version 8.0.5 components. The TTable (BDE) has the following behavior, before editing the record from another application instance…
Mr.Darcy
  • 11
  • 2
0
votes
1 answer

Anydac TADTable component collation issue

I'm having an issue with sorting strings that have special characters like ^ and ! in a Firebird database. When using the TADTable component with the following settings and a table that uses collation unicode_ci_ai CachedUpdates :=…
cjmarques
  • 632
  • 1
  • 7
  • 17
0
votes
1 answer

Enabling SQLite Foreign Keys without command

Is there a way to enable the SQLite Foreign Keys with the TFDQuery component and without using a sql command? I build a SQLite DB with foreign keys and it works, also without enabling that option. However, I might better use it. LuMa
LuMa
  • 1,673
  • 3
  • 19
  • 41
0
votes
0 answers

Firedac / Anydac query issue when using updatesql components

The following question is related to firedac using adquery, updatesql with access database: First the scenario: In one of scenario my updatesql gives an error i-e data in the table was not updated, however my dataset after showing error moves to…
Khawar
  • 33
  • 1
  • 6
0
votes
0 answers

FireDac installation in XE4 fails

I have installed Delphi XE 4 Enterprice Update1 on my computer. I tried to install Fire DAC 8.0.5.3365, but during installation got many errors like: Source\uADStanCipher.pas(181) Error: E2010 Incompatible types: 'Byte' and…
vico
  • 17,051
  • 45
  • 159
  • 315
0
votes
1 answer

AnyDac - How to disconnect from in-memory sqlite db?

I'm using in-memory SQLite databases with AnyDac on Delphi XE2. I noticed that my queries return results even when I forget to connect the database first after restarting the program, which is probably caused by the autoconnect capability of AnyDac.…
Jasper
  • 62
  • 3
0
votes
4 answers

[AnyDac][DApt]-400 But my tables does have a PK

[anydac][DApt]-400.Fetch command fetched[0] instead of [1] record, Possible reasons:update table does not have PK or row identifier,record has been changed/deleted by another user, when…
Mawg says reinstate Monica
  • 38,334
  • 103
  • 306
  • 551
0
votes
1 answer

Displaying a MySql TIMEDIFF() in a DB grid

When I use the command line, this query gives me pleasing results (it shows duation, which is what TIMEDIFF is about): mysql> select timediff(end_time_stamp,start_time_stamp) from test_runs; +-------------------------------------------+ |…
Mawg says reinstate Monica
  • 38,334
  • 103
  • 306
  • 551
0
votes
1 answer

AnyDac form design, programming query cancel dialog

I'm having a problem with my AnyDac Cancel dialog from TADGUIxAsyncExecuteDialog component, basically i need the user to be able to cancel the query execution it works perfectly but the design doesn't match the program what i need is to edit the…
AirWolf
  • 597
  • 7
  • 27
1 2
3