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
5
votes
2 answers

List of free dbexpress drivers for Delphi

Anyone knows/has a comprehensive list of free open source dbexpress drivers?
user114285
  • 513
  • 7
  • 19
5
votes
3 answers

Can dbExpress's TSQLQuery use ? as parameters?

We've porting code to Delphi XE2, and need to change our data access components from third party ODBCExpress which is no longer in business, to dbExpress's TSQLQuery. We have parametrized SQL query such as: sSQL := 'UPDATE ZTestData SET '+ '…
Robo
  • 4,588
  • 7
  • 40
  • 48
5
votes
3 answers

SQL Query to calculates 'reserved' inventory items

We are creating a inventory system for items called readoutprobes and readoutprobekits. The schema, below, is simplified, using the words items and itemkits. An itemkit, is a predefined collection of 1 or more items, i.e. a kit. In a kit, a…
Totte Karlsson
  • 1,261
  • 1
  • 20
  • 55
5
votes
1 answer

Delphi 2010 and Dbexpress deploy

How on Earth to deploy a Delphi 2009 /2010 app that connects to a remote mysql using dbexpress? What files to include? Thanks
user645976
5
votes
1 answer

Keeping connection alive - mysql

I have set up my delphi application that I created with a button named Connect. Once I click it it executes the following code: begin someConnection.Connected:=true; somecomenziDataSet.Active:=true; end; Similarly I have a button for…
t1f
  • 3,021
  • 3
  • 31
  • 61
5
votes
4 answers

How to get the millisecond value from a Timestamp field in firebird with Delphi 2007

I have a Firebird database (running on server version 2.1.3) and am connecting to it with Delphi 2007 using the DBExpress objects (using the Interbase driver) One of my tables in the database looks something like this CREATE TABLE MYTABLE ( MYDATE…
Re0sless
  • 10,678
  • 6
  • 51
  • 66
5
votes
2 answers

DBX Error: Driver could not be properly initialised

I am running Delphi XE3 (Ultimate Edition), MySQL database and this is the error I get when a click Test Connection. As a response, I located the libmysql library in my xampp directory and copied it over to my System32 directory. This does not work…
ple103
  • 2,080
  • 6
  • 35
  • 50
5
votes
1 answer

How can I get the Winsock error code for a dbExpress connect error?

In case of a connection problem, the dbExpress driver throws a TDBXError but does not include a socket error code. The message is simply: Unable to complete network request to host "exampledb.local". Failed to establish a connection Is there a…
mjn
  • 36,362
  • 28
  • 176
  • 378
5
votes
2 answers

Is it good practice to use email as id in a mysql DB?

I have read may questions and answers as to simplicity of a mysql DB and good practice. I have a mysql DB, with a 'clients" table. Each client added has an email, which is unique as to emails. Using C++ Builder there are problems adding records…
Jan Andersen
  • 51
  • 2
5
votes
1 answer

How compatible is Chau Chee Yang's dbExpress and XE2 Enterprise dbExpress for Firebird?

I use Delphi 2010 Professional which did not come with the dbExpress driver for Firebird. If I start using the Firebird dbExpress driver written by Chau Chee Yang and then later upgrade to XE?? Enterprise (which comes with the Firebird dbExpress…
Michael Riley - AKA Gunny
  • 5,074
  • 4
  • 42
  • 89
5
votes
3 answers

How can I detect if ApplyUpdates will Insert or Update data?

In the AfterPost event handler for a ClientDataSet, I need the information if the ApplyUpdates function for the current record will do an update or an insert. The AfterPost event will be executed for new and updated records, and I do not want to…
mjn
  • 36,362
  • 28
  • 176
  • 378
4
votes
1 answer

dbExpress "Record not found or changed by another user"

How do I find the reason for a "Record not found or changed by another user" error when working with dbExpress? How do I find the SQL statement (with the actual parameter values) that fails?
mjn
  • 36,362
  • 28
  • 176
  • 378
4
votes
1 answer

How to copy a database's table to another database's corresponding one using TSQLConnection/dbExpress?

I'm using C++ Builder (or Delphi 2007 and XE2) using DBExpress. I connected two databases one for firebird(my local hard disk) one for MySQL(on Web) using TSQLConnection. Then, my question is ... how can i use(make) SQL statement(or anything) to…
R.O.K.
  • 61
  • 3
  • 6
4
votes
3 answers

How to use Booleans with Delphi XE2 dbExpress and Firebird 2.5

Does the new XE2 dbExpress still have problems using Boolean fields?
Jlouro
  • 4,515
  • 9
  • 60
  • 91
4
votes
1 answer

Monitor SQL queries executed by a Delphi application

I'd like to monitor SQL queries executed by my application while it runs. I'm using a dbExpress connection to an Oracle 11g database under Delphi 2007. This used to be possible under the BDE with the sqlmon.exe utility. Is there a similar utility…
JosephStyons
  • 57,317
  • 63
  • 160
  • 234
1
2
3
…
17 18