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

Delphi: is DBexpress faster than Firedac

I'm running a Mysql server on my network (Mariadb 10.3.24), and have made a performance test with dbexpress and firedac on the same data, same machine and with no other users on the database. I'm using Delphi 10.1 and made no changes to the…
Ib Elfving
  • 87
  • 1
  • 3
4
votes
2 answers

TSQLQuery - Cursor not returned from query

Right now, I am trying to get rid of some old searching code in a delphi programm, and I want to push the searching to the sql-server the program is using. For this I created this query, which is very similar to a query I use in a different C#…
Marks
  • 3,613
  • 5
  • 31
  • 46
4
votes
1 answer

Can TCustomClientDataset apply updates in a batch mode?

I've got a DB Express TSimpleDataset connected to a Firebird database. I've just added several thousand rows of data to the dataset, and now it's time to call ApplyUpdates. Unfortunately, this results in several thousand database hits as it tries…
Mason Wheeler
  • 82,511
  • 50
  • 270
  • 477
4
votes
1 answer

Threading DbExpress queries

I have only done "GUI" database access in Delphi with DbExpress components, but now I'd like to execute one query on background. I read some where that TSQLConnection is not thread safe and I have to create new connection for each thread. I see that…
Harriv
  • 6,029
  • 6
  • 44
  • 76
4
votes
6 answers

Getting a Field List from a DBExpress TSQLQuery

I am having a problem getting a list of fields from a query defined at run time by the users of my program. I let my users enter a SQL query into a memo control and then I want to let them go through the fields that will return and do such things…
jrodenhi
  • 2,237
  • 1
  • 21
  • 31
4
votes
1 answer

Is it possible to tweak TStringField to work like TWideStringField in Delphi?

We want to use Unicode with Delphi 2009 and Interbase, and found that to switch the character encoding from WIN1252 to UNICODE_FSS or UTF8 we first have to replace all instances of TStringField with TWideStringField in all datamodules. For around 60…
mjn
  • 36,362
  • 28
  • 176
  • 378
4
votes
2 answers

How does a .NET program behave differently when run with and without debugging in Visual Studio?

I'm getting an Access Violation in DBEXPSDA40.DLL (Dev Art MS SQL Server dbexpress driver) on closing down my .NET application. My application (VB.NET) calls a Delphi written COM Server which uses dbexpress to connect to SQL Server. If I do the same…
Steve
  • 6,382
  • 3
  • 41
  • 66
4
votes
8 answers

Delphi dbExpress and Interbase: UTF8 migration steps and risks?

Currently, our database uses Win1252 as the only character encoding. We will have to support Unicode in the database tables soon, which means we have to perform this migration for four databases and around 80 Delphi applications which run in-house…
mjn
  • 36,362
  • 28
  • 176
  • 378
4
votes
3 answers

TClientDataSet used as in-memory dataset - is it possible to apply the updates in-memory without saving the data to a database?

By default, the TClientDataSet tracks all the changes made in the DataSet (inserts, updates, deletes). Is there a way to tell the dataset to accept the current changes (after a series of inserts using insert/post, let's say) without actually calling…
boggy
  • 3,674
  • 3
  • 33
  • 56
4
votes
4 answers

dbExpress driver for Microsoft Access

being a dbExpress newbie I wonder if there is a dbExpress driver for Microsoft Access?
Joe Meyer
  • 469
  • 1
  • 6
  • 14
4
votes
1 answer

TSQLDataset error while migrating from delphi 7 to delphi XE4

I have following TSQLDataSet in my Delphi 7 application. It is fetching 2 fields (ID and Name) from table MyTable. object SQLDataSet: TSQLDataSet GetMetadata = False CommandText = 'select * from MyTable' MaxBlobSize = -1 Params =…
user1556433
4
votes
4 answers

Equivalent to TUpdateSQL in Delphi 2010 dbExpress?

I am planning to migrate a Delphi 6 BDE application to Delphi 2010... First of all, do I have to move away from BDE? (I will but I prefer to do this in stages if possible) Second, is dbExpress the best choice? (I am using MS SQL) Lastly, is there…
Snackmoore
  • 905
  • 3
  • 18
  • 32
4
votes
2 answers

How to consume in process server method with DataSnap 2010

I define a server method: TServerMethod = class(TPersistent) public function EchoString(Value: string): string; end; The method EchoString return an equivalent Value string. I then use TDSTCPServerTransport with TDSServer and TDSServerClass to…
Chau Chee Yang
  • 18,422
  • 16
  • 68
  • 132
4
votes
1 answer

dbExpress vs ADO Connection

Is using a dbExpress database faster/better/less programming than ADO connection and Access db for this instance? Application will not be consistently reading / writing to DB DB size will be pretty small (1000-2000 rows) (5 columns) DB will be…
Glen Morse
  • 2,437
  • 8
  • 51
  • 102
4
votes
1 answer

How to pass a parameter to a query using dbExpress in Delphi

I want to use a dbExpress TSQLQuery component. But i do not know how to write the SQL to add a parameter. I will give an example maybe it will be more clear what my problem is. In a TADOQuery the following works: SELECT* FROM sometable WHERE…
Japster
  • 985
  • 6
  • 19
  • 38
1 2
3
…
17 18