Stack Overflow
Stack Overflow

Questions tagged [bde]

BDE is the abbreviation for Borland Database Engine.

Borland Database Engine (BDE) is a legacy Windows-based database engine providing database connectivity for Delphi and C++ Builder via SQL Links and ODBC.

It was replaced in 2000 by dbExpress.

Resources

180 questions
4
votes
1 answer

How to use TSession Class of BDE in Delphi?

I am using mutiple connection using ODBC. In whole project I am using the same connection, but create, use and destory TQuery object. Now I am going to use connection in threads and came to know Delphi BDE provides TSession Class for that. I want to…
Ashu
  • 49
  • 1
  • 4
4
votes
3 answers

Delphi connection to SQL Server - 'futureproof' replacement for BDE?

we have an applcation of some size (about 1MLOC) that were started back in the days when BDE was just about to be deprecated. Nowadays we only use it to connect to SQL Server using ODBC. It has worked surprisingly well in spite of its deprecated…
LandShark
  • 63
  • 2
  • 7
4
votes
8 answers

delphi "Invalid use of keyword" in TQuery

I'm trying to populate a TDBGrid with the results of the following TQuery against the file Journal.db: select * from Journal where Journal.where = "RainPump" I've tried both Journal."Where" and Journal.[Where] to no avail. I've also tried: select…
Baldric
  • 303
  • 1
  • 4
  • 10
4
votes
1 answer

Is there a limit to the number of parameters in a TStoredProc?

Is there limit to either the number of params or to the overall size of a params in a TStoredProc ExecProc call? Currently running a system that is still using the BDE to connect to Oracle and a recent change to the number of parameters to a package…
Mike Howard
  • 73
  • 4
4
votes
2 answers

How to find out what permission an application needs under Windows 7

Is there a way to find out what privileges my application needs in order to run in a Windows 7 environment? I have a Delphi application that is using BDE and ODBC for database connectivity. This application works on most computers with Windows 7…
Robert Niestroj
  • 15,299
  • 14
  • 76
  • 119
3
votes
1 answer

Does TQuery.Unprepare close the query result in Delphi?

I wonder whether in Delphi calling Query1.Unprepare; implicitly closes Query1, if it was previously active. Such that e.g. calling Next on it will fail. You might say, just go ahead and try but I did on a 64-bit Windows 7 system and had all sort of…
Kit Fisto
  • 4,385
  • 5
  • 26
  • 43
3
votes
3 answers

How do I solve the "Cannot perform this operation on a closed dataset" with Borland Database Engine and a Delphi application?

The application was working perfectly, until I edited the user database (*.dbf) in OpenOffice.org Calc. Now it gives me the above error about a closed dataset.
Geoffrey
  • 5,407
  • 10
  • 43
  • 78
3
votes
2 answers

Determining best method to traverse a table and update another table

I am using Delphi 7, BDE, and Interbase (testing), Oracle (Production). I have two tables (Master, Responses) I need to step through the Responses table, use its Master_Id field to look it up in Master table (id) for matching record and update a…
IElite
  • 1,818
  • 9
  • 39
  • 64
3
votes
2 answers

Use TQuery.Locate() function to find other then first matching

Locate moves the cursor to the first row matching a specified set of search criteria. Let's say that q is TQuery component, which is connected to the database with two columns TAG and TAGTEXT. With next code I am getting letter a. And I would like…
user8675722
3
votes
1 answer

How to find out the BDE's shared memory area's actual location and size programmatically?

The Borland Database Engine uses a shared memory area that has to be mapped in the same address in all BDE application processes concurrently running in the same Windows workstation. The area's location and size are guided by two settings called…
Side S. Fresh
  • 3,015
  • 2
  • 16
  • 18
3
votes
3 answers

BDE, Delphi, ODBC, SQL Native Client & Dead lock

We have some Delphi code that uses the BDE to Access SQL Server 2008 through the SQL Server Native Client ODBC driver (2005 version). Our issue is that we're experiencing some deadlock issues in a loop doing inserts to multiple tables. The whole…
EspenS
  • 31
  • 1
  • 2
3
votes
3 answers

How to ignore some parameters in TQuery

If i have a SQL statement like below SELECT * FROM myTable WHERE CID = :vCID AND DataType = :vDataType And usually i use TQuery to get some data like below aQuery.ParamByName('vCID').Value := '0025'; aQuery.ParamByName('vDataType').AsInteger :=…
Leo.W
  • 299
  • 1
  • 7
  • 21
3
votes
0 answers

BDE dbase Corrupt Memo/BLOB file

I am using Delphi 7 and BDE to access some DBase tables. Some dbt fikes end up being corrupted very often. I know that closing the computer while having a dbase table opened leads to the corruption. Does anybody have some ideas what other reasons…
paccic
  • 299
  • 4
  • 10
3
votes
1 answer

Opening Paradox database; 'PDOXUSRS.NET' workaround?

I'm writing an application that has to open a preexisting BDE database that has been saved by a third party. In this application, I currently have a TDatabase (DriverName: STANDARD) with path set correctly in Params. I can now set Connected to true…
Imanuel
  • 3,596
  • 4
  • 24
  • 46
3
votes
2 answers

Shut down BDE from code

We have a legacy application uses the BDE. (The BDEcontinues to work surprisingly well, given its age). There are times when our app needs to manipulate folders (Rename, move, etc.) but a .NET or .LCK file remains open in the folder, preventing…
RobertFrank
  • 7,332
  • 11
  • 53
  • 99
1
2
3
…
11 12