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
0
votes
0 answers

How to insert a record blob field in SQL to a Paradox table?

I am using the SQL editor in Paradox 9. I am trying to insert a record into a table that contains a blob (Binary) field. My SQL statement is as follows: insert into table1.db (field1, field2) values ('value1', 'value2') That returns the…
MrSnrub
  • 435
  • 4
  • 14
0
votes
0 answers

i can't run a foreach loop container for an ADO NET Source contains a paradox files

I have a lot of paradox files (*.db), i want to automatize the transfer of data containing on these files to sql server, with ado net source it works, but foreach loop doesn't. I have configured the Foreach Loop Enumerator to use an enumerator type…
0
votes
0 answers

Corel Paradox ODBC Driver

I am in the process of migrating some legacy software that uses Delphi (XE3 or Tokyo) and the BDE against Paradox. We will be going with UniDAC, and have the software running, using ODBC (MS Paradox Driver). Unfortunately, the MS Drivers are…
sse
  • 987
  • 1
  • 11
  • 30
0
votes
2 answers

Convert Excel sheet to paradox DB

given a data in an excel sheet, For the purpose of converting it to Paradox DB, to get used in paradox program. there are any application that convert excel sheet to paradox DB?
Simo Os
  • 149
  • 10
0
votes
1 answer

BDE administrator and Paradox 11

I've just upgraded from Windows 7 to windows 10. I used to use Paradox 5 with BDE administrator and things worked fine. However Paradox 5 didn't work with windows 10, so I upgraded it to Paradox 11. That's the context for what I'm going to ask…
Tim B
  • 7
  • 3
0
votes
2 answers

Java-Paradox Driver - can select but can't modify

I need to do some DB operations on a paradox database from within java code (I didn't even know about the existance of paradox) So i downloaded this driver as found out here: https://github.com/leonhad/paradoxdriver, and created a code to query the…
Maik
  • 811
  • 3
  • 22
  • 35
0
votes
0 answers

Wrong characters with OdbcDataAdapter

I use OdbcDataAdapter to get data from Paradox DB. public static DataSet GetDataSetFromAdapter(DataSet dataSet, DataTable dataTable, string connectionString, string queryString) { using (OdbcConnection connection = new…
Kirill
  • 13
  • 2
0
votes
1 answer

How to create a BDE alias in Java programmatically?

Is it possible to create a BDE alias for Paradox in Java programmatically? I'm trying like this: import java.sql.DriverManager; import java.sql.SQLException; import java.util.logging.Level; import java.util.logging.Logger; public class Principal { …
BicaBicudo
  • 307
  • 1
  • 8
  • 20
0
votes
0 answers

How to fix character bug in existing .db file

I'm trying to import a .db file into a existing database through a tools called 'Import Data' in IBExpert. I have a problem with the encoding of the .db file, when the import is done characters like 'ç, ã, õ' are not recognized. I've been trying to…
0
votes
2 answers

Trying to read Paradox .sc and .sc2 code files

There is a very old program that a client uses that was written in paradox for DOS. It runs on the paradox runtime version 4.0 in DOS for the whole program. Right now, it is run in a virtualized instance of Windows 98, that runs it from the command…
Jeremy Kropf
  • 45
  • 1
  • 1
  • 9
0
votes
0 answers

Delphi sql: dealing with space character in field name

Ho do I deal in the sql text with fields that have a space character. For example in db biolife I have the field: Species Name both my attempts did not work: query1.SQL.Text := 'SELECT Species Name FROM biolife'; query1.SQL.Text := 'SELECT ''Species…
user1238784
  • 2,250
  • 3
  • 22
  • 41
0
votes
1 answer

Delphi Paradox database - making duplicate of record | Key violation error

I need to import data into database of old invoicing program. The technology seems archaic, but I'm not discouraged and maybe someone will tell me a solution. I created from components in Delphi 2005 (I have access to it and I found some…
kwadratens
  • 187
  • 15
0
votes
1 answer

Why is FileSystemWatcher never triggered on changes in open BDE/Paradox database file?

I have an old native application written in Borland Delphi: The application interfaces with the special hardware and creates/stores its data in a BDE/Borland Paradox Database in a .db file. I am not the author of this application and the company…
c00000fd
  • 20,994
  • 29
  • 177
  • 400
0
votes
1 answer

C# ODBC Driver working fine on Win10 but not Win7

I got a Problem with an old ODBC Driver for Paradox Database (Intersolv ODBC Paradox Driver). I have an application to read and write data to a Paradox database while the Main Program of the Databases is running. I have got Problems before with the…
Friedlman
  • 87
  • 1
  • 7
0
votes
1 answer

How to insert simultaneously same data into two differentes table on delphi

I have two tables purchase and stock (paradox 7 in delphi), so I want when I insert some new data in the table "purchase" will be added simultaneously in "stock" table. If someone knows how it works or else say how to do it with SQL.