Stack Overflow
Stack Overflow

Questions tagged [dbexpress]

dbExpress is Embarcadero's data driver architecture replacing the deprecated Borland's BDE.

dbExpress is Embarcadero's data driver architecture that replaced the older Borland Database Engine ().

It only provides unidirectional database access.

Embarcadero supplies drivers for many notable databases. Additional drivers are also available from third parties.

Currently, drivers can be written in Delphi/C++.

Resources:

  • Migrating BDE Applications to dbExpress page on Embarcadero Developer Network.
  • Wikipedia article on dbExpress
  • DevArt page on their proprietary dbExpress drivers.
259 questions
0
votes
1 answer

Delphi DBExpress SQLDataSet.ExecSQL freezes

I am comparing BDE and DBExpress components and try to execute simple update in TMPTABLE. When I use BDE TQuery Query.ExecSQL works fine, but if I use DBExpress TSQLDataSet, it freezes in SQLDataSet.ExecSQL. I use Delphi XE3 in Win7 64b. Database…
pKarelian
  • 263
  • 1
  • 8
  • 14
0
votes
2 answers

Can Delphi (dbExpress) use SHOW TABLES across Schemas?

I trying to write a small database management app to compare our live and dev database schemas At the moment I can use a single TSQLconnection to get the list of Schemas on the MySQL (5.0) server, the problem comes when I try and directly access the…
Dan Kelly
  • 2,634
  • 5
  • 41
  • 61
0
votes
1 answer

delphi xe3 database with MySQL version 5.1 Error. Exception TDBXError in module. Unable to load dbxmys.dll (errorCode126)

I have droped all components to the form in order to make a simple database application. The connection was successfully tested. After setting the properties of the Components and running the application, the message is displayed. "Exception…
Eid
  • 190
  • 3
  • 14
0
votes
2 answers

Delphi 2006 translating sql server 2008 express date fields as twidestring

Some days ago I posted a question on which component to use to make a MultiDatabaseWithJustOneComponent and i follow the general advice to use dbexpress. FirebirdSQL has date field, SQL Server 2008 has date fields too. But for some reason date…
José Eduardo
  • 323
  • 1
  • 5
  • 16
0
votes
1 answer

FieldType by dbxSqlite driver always ftWideMemo only when the dataset is empty

using delphi xe4 and dbexpress on sqllite3 This issue occurs only when the dataset is empty. Create an app with TClientDataSet, TDataSetProvider and TSQLQuery and TSQLConnection. The TSQLConnection must be of drivername Sqlite. After opening of the…
Reza
  • 18,865
  • 13
  • 88
  • 163
0
votes
5 answers

"Field 'COUNT(id)' has no dataset" TSQLQuery in Delphi

Sorry for my english, but i hope you'll understand me :P I'm trying to create new TSQLQuery component in code, without placing it on form. I wrote that code: var sql:tsqlquery; pole:TFMTBCDField; .... sql:=tsqlquery.Create(self); …
WombaT
  • 790
  • 1
  • 13
  • 27
0
votes
0 answers

Replacement for TSQLQuery.TransactionLevel in Delphi XE2 or later

I am converting a program from Delphi 2005 to Delphi XE2 or XE3. It uses DbExpress with a Firebird database. The program uses TSQLQuery.TransactionLevel to allow it to have overlapping transactions. It is dependent on these overlapping…
urtlet
  • 153
  • 2
  • 10
0
votes
1 answer

DbExpress: Using New 5.1 libmysql.dll with older MySQL 5.0 server

I would like to find out from fellow developers if there are any pitfalls in using a recent libmysql.dll with a previous MySQL server. I use Delphi with DbExpress to build database applications. My main reason is that I have both Delphi 7 and Delphi…
Martin
  • 39
  • 1
  • 5
0
votes
1 answer

Strange behaviour of Delphi database components

I have a problem with the Delphi database components. I tried to add some functionality to a program, but was getting strange problems. I broke it down to a simple sample project and the behaviour is still there. I created a new Forms Application…
Marks
  • 3,613
  • 5
  • 31
  • 46
0
votes
3 answers

Delphi 6 -> Delphi 2006 dbexpress weirdness?

I have an older application (written in Delphi 6) that has to be ported to Delphi 2006 (update 2). The application used to connect to an Interbase 6.x database using DBExpress, but the new version needs to connect to a Firebird 2.x…
Arjan de Haan
  • 120
  • 1
  • 5
0
votes
1 answer

How to connect two sets of db components using master / detail relationship?

This is how my db components are connected in program: The datatypes of components are (first row, from left to right): TDBGrid, TDataSource, TClientDataSet, TDataSetProvider, TSQLQuery, TSQLConnection. Second row is analogous to first row. Client…
truthseeker
  • 1,220
  • 4
  • 25
  • 58
0
votes
1 answer

Missing Field Errors In TClientDataSet when external dll called from Delphi 7

I have a DLL created in Delphi XE2 that is using DB Express and TClientDataSet to display the results of a join in a DB Grid. There is a simple function to launch/show the form that is exported for use in other applications. The query is executed,…
ConBran
  • 369
  • 2
  • 15
0
votes
0 answers

Delphi BCD Field incorrectly displayed if DisplayFormat contains the dot

I'm having a weird problem with an old project that's still being maintained with Delphi 7. I have a TFMTBCDField component, representing Firebird Numeric Field (called GROSSPRICE). It's value gets calculated on the server side (by the Firebird SQL…
Attila Fulop
  • 6,861
  • 2
  • 44
  • 50
0
votes
3 answers

Add a blank row, then populate using a dialog in Delphi/DataSnap/dbExpress

I'm planning to create a dialog that would create a blank record in a Firebird database, then populate the fields with values taken from text edit boxes in that dialog. I am using the following: dbExpress DataSnap Delphi XE2 Maybe it should go like…
Victor Ian
  • 1,034
  • 13
  • 26
0
votes
1 answer

Delphi DBExpress Parent Child No corresponding master record found

I am using DBExpress to connect to MySQL. I have a master detail relationship between two tables. I am providing the parent table via DatasetProvider. On the client side I have 2 clientdatasets. One of them accesses the provider, has all the parent…
Nirav KAKU
  • 19
  • 3
1 2 3
…
17
18