Questions tagged [paradox]

Paradox was created by Borland, as an integrated database management system and application development language for desktops and servers. It ran originally under DOS and later under Windows. It is a file based database system with each table in a separate file or files. Paradox for DOS had a built-in scripting language known as PAL, and used tables through version 4.5. Paradox for Windows was a Windows application that included event processing.

Paradox was created by Ansa/Borland, as an integrated database management system and application development language for desktops and servers. It ran originally under DOS and later under Windows. It is a file based database system with each table in a separate file or files. Paradox for DOS had a built-in scripting language known as PAL, and used tables through version 4.5.

Paradox for Windows is a Windows application that includes event processing. The database system is included in Word Perfect Office X8.

179 questions
1
vote
1 answer

Using ADO to connect Paradox database on Delphi 10.2

Currently I have an old Delphi project using BDE to connect to Paradox. We want to investigate whether ADO can be used to replace the BDE but still use Paradox for Delphi version 10.2 Tokyo. So please advise me that Delphi 10.2 supports Paradox…
1
vote
1 answer

FireDac - how to use transactions with paradox tables

unfortunately i have to work with ancient piece of software, that uses paradox tables. The following code gives me exception: fdcMainPX->TxOptions->AutoCommit=false; fdcMainPX->StartTransaction(); <--- "Project xxx raised exception class…
Vancalar
  • 963
  • 1
  • 7
  • 15
1
vote
0 answers

Pdx ANSI Intl language driver

is there a documentation about the old "Pdx ANSI Intl" language driver which is used in Borland Database Engine? I would like to implement a custom Collate function for SQLite which compares strings in the same order with "Pdx ANSI Intl".…
nvu
  • 137
  • 1
  • 7
1
vote
1 answer

How to read and write to a Paradox 7.x database from .NET app?

I develop .NET application (C#) and I need to read and update some data in a Paradox 7.x database. According to Microsoft article for Paradox 7-8 no support is provided for OLEDB. According to another SO question reading is possible, but not…
bairog
  • 3,143
  • 6
  • 36
  • 54
1
vote
1 answer

Python 'None' value appearing as -2147483648

I'm reading in a data file from a Paradox database file (.DB) using a module pypxlib. Whilst reading each row, I write to a CSV. For some reason, values which expected to be 'None' are appearing as the number -2147483648. Does anyone know the…
Lewis Anderson
  • 651
  • 1
  • 7
  • 11
1
vote
1 answer

SQL Statement Dump Issue

I'm trying to find out why some of my order numbers in my table are dumping out there appropriate data while others aren't. Here I'm trying to dump out data from a specific order number and it won't dump its data for the COMPLEX CITY, COMPLEX NAME…
Curious13
  • 329
  • 2
  • 23
1
vote
3 answers

EDBEngineError-Network Initialization Failed

I am attempting to convert a Dephi 2006 project to Delphi 2009 (Delphi 2006 is on Drive C Delphi 2009 is on Drive D). On the main form there is a DataSource1: TDataSource; and a Table1: TTable; In OnFormShow the table filename is set…
Bill
1
vote
1 answer

solving St Peterburg Paradox in R

St Petersburg paradox is a gambling game where you pay a fixed amount to enter the game. You flip a coin repeatedly until a tails is thrown. Your payoff is the sum from 1 to n of 2^n where n is the number of heads before the first tails. If that…
Max
  • 13
  • 2
1
vote
1 answer

Getting datatypes from Paradox DB over ODBC into SQLite [Delphi]

I'm connecting to a .dbf using ODBC in Delphi using FireDAC. I've setup an ODBC connection, dBase 5.0, using the 32-bit Driver do Microsoft dBase (.dbf) driver. In my IDE (Rad Studio 10.1 Berlin), I've setup the ODBC connection as a data source. The…
Nils Guillermin
  • 1,867
  • 3
  • 21
  • 51
1
vote
2 answers

How to replace null primary keys in MySql

I have to migrate an old Paradox database to MySql. The Paradox database contains composite primary keys with null values (composite keys are composed by 3,4 or 5 fields and it could have 1 or 2 fields with a Null value). The problem is null values…
user3049922
  • 157
  • 1
  • 2
  • 10
1
vote
5 answers

Program to simulate Zeno's paradox in Java

So I was reading in a book of a certain paradox: Say you are in a room with a door opposite of you. In order to leave though, you must travel half the distance there each time. So the first stride you make half the distance, and the second stride…
Snowman
  • 31,411
  • 46
  • 180
  • 303
1
vote
1 answer

Reading BLOB fields in Paradox from VB.NET

Objective: read BLOB field from a Paradox database with VB.NET. What I am able to do so far: Connect to the database and change (non-BLOB) values. Great!* Read entire tables (including BLOB fields) into a DataGrid (via OledbDataAdapter.Fill into…
Lee MC
  • 89
  • 5
1
vote
0 answers

How to configure BDE to connect to an existing Paradox db with .net application?

Hoping in can find someone who is familiar with this scenario. I've not touched Paradox in over 12 years, and most posts I find on the subject are 5+ years old. I have created a C# application to read a Paradox .db file using OLEDB and the Borland…
Kerberos42
  • 233
  • 4
  • 15
1
vote
1 answer

How to decode a string in Visual Basic 6

I'm trying to read .DB (Paradox 5) file within my Visual Basic 6. Everything's OK except encoding/charset. It shows as Iieiei 75a instead of cyrillic string. This is my ODBC Connection string: Driver={Microsoft Paradox Driver (*.db…
Serhii Matrunchyk
  • 9,083
  • 6
  • 34
  • 47
1
vote
1 answer

Paradox database conversion python

I am currently working on a project that uses Paradox database. I need to be able to either convert the data to sql automatically after the paradox database has been run or to be able to interact with paradox directly. I cannot seem to find a way to…
Marcello B.
  • 4,177
  • 11
  • 45
  • 65