Stack Overflow
Stack Overflow

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

Parallel using Paradox database with c# JET and another program

I'm looking for how to access a Paradox database with C#. The problem is that, on workstation is all ready running program, which using target database. Until it's running, oleDbConnection.Open() throws an exception. If I'm not running program in…
Przemysław Staniszewski
  • 31
  • 5
1
vote
1 answer

Can I add index to aggregated field on Paradox

ProductTable.AddIndex('Count_Indx','Count',[ixCaseInsensitive]) I try do this code but not working. Write "Count field not founded on Table"
v.tsurka
  • 452
  • 6
  • 18
1
vote
1 answer

In Delphi get value from lookup field

I have database Paradox 7. Two tables: Order -------- OCode ODate // Buy date OCount // Product count PPrice // Price of product in current moment PCode // Product code CCode //Client code Product --------- PCode PName PPrice On…
v.tsurka
  • 452
  • 6
  • 18
1
vote
1 answer

Encoding issue while reading Paradox database using Java

I have Java application (using JDK 1.7) which is reading Paradox files (*.db). It works well with Latin characters. I am trying to make this application to display Cyrillic characters correctly, however constantly getting unredable results. …
Vlad K
  • 113
  • 1
  • 8
1
vote
2 answers

filter dates fields from paradox db using microsoft.jet.oledb.4.0

Hi I'm trying to filter data fields from a paradox database table (from information system on programmed on delphi)... I successfully made the connection with the connection string: Provider =Microsoft.Jet.OLEDB.4.0; Data Source =c:\bddir; Extended…
christian
  • 21
  • 3
1
vote
1 answer

Does paradox DB allow pagination?

In SQL Server I can use this: DECLARE @PageNum AS INT; DECLARE @PageSize AS INT; SET @PageNum = 2; SET @PageSize = 10; WITH OrdersRN AS ( SELECT ROW_NUMBER() OVER(ORDER BY OrderDate, OrderID) AS RowNum ,OrderID ,OrderDate …
ThiagoAlves
  • 1,313
  • 16
  • 25
1
vote
1 answer

Borland Paradox converter to mysql

Trying to use this converter https://www.rebasedata.com/convert-paradox-to-mysql-online But the problem is that I have a Borland Paradox 5 database, which has 745 files and 176 DBS, and I exceed query length limits running this java applet. I tried…
Dmitrij Holkin
  • 1,995
  • 3
  • 39
  • 86
1
vote
0 answers

Python Ubuntu pypxlib stack smashing detected

I have a simple code to convert the Paradox DB to a dictionary and save it in a .dat with pickle. In Windows, all works great but in Ubuntu 20 Server and venv for python 3.8 I have this issue. *** stack smashing detected ***: terminated Aborted…
David Aragón
  • 11
  • 1
1
vote
1 answer

Paradox BCD field - Number is out of Range error

I'm attempting to update an old Paradox (BDE) table using an older Delphi XE6 application. One particular table has two fields; a Date field, and a BCD field. I'm unable to post a new record to the (FuelSurch) table due to the BCD (FuelSur) field…
Hackbrew
  • 349
  • 1
  • 10
  • 23
1
vote
0 answers

SQLAlchemy - Change table name in FromClause w/ event listener

I've looked at several answers to similar questions, and none of them fit my use case. That said, I apologize in advance if I've somehow missed the answer and this ends up being a re-posted question. In short, I'm writing a small extension / wrapper…
Mark Schlachter
  • 21
  • 1
  • 3
1
vote
1 answer

Defuzzification process of fuzzy sets in RDBMS

I have a table that stores all values..eg x1, x2, x3 which determines fuzzy sets. Degree of membership is assigned to each using mathematical functions for Low, Med, High. My rule 1 states that if x1 is high AND x2 is medium then probability of…
CGF
  • 313
  • 3
  • 5
  • 15
1
vote
1 answer

How do you add data providers to the "Data Source Configuration Wizard" in VS2010

How do you add data providers to the "Data Source Configuration Wizard"? I'd like to add Paradox to this list. Is it possible? Thanks
JimDel
  • 4,309
  • 11
  • 54
  • 99
1
vote
1 answer

Can I use SQL to edit a piece of a record in a group of rows?

The records of one column in my table have a letter/dash prefix (B-290151626). I need to remove the letter/dash without changing the rest of the record, and do this for 1700 rows. This is for the Paradox database (yes I know it's old) and I have a…
C_Pietro
  • 41
  • 1
1
vote
1 answer

Connection PHP to Paradox database

I need to make a connection with PHP to a database created with Paradox (about the year 2004, I think). It is a very old database and there is no way to find information online. I have tried with xampp, wamp but they do not bring by default any…
Mimmetico
  • 422
  • 9
  • 25
1
vote
1 answer

Add new field to paradox database file

I am reading a .db paradox database file by pypxlib package. And using insert function I can add a new row. But how can I add new fields? from pypxlib import Table data = Table('test.db') data.fields >>OrderedDict([('Index',
Dk Lin
  • 23
  • 3
1 2 3
…
11 12