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

java update query for paradox database

i'm trying to update paradox table from java but i'm getting an Exception java.sql.SQLException: [Microsoft][ODBC Paradox Driver] Operation must use an updateable query. java.sql.SQLException: [Microsoft][ODBC Paradox Driver] Operation must use an…
Daniel Miovski
  • 31
  • 4
1
vote
6 answers

How can System.Object use sub-classes as its return types?

It is true in .NET that all types inherit from System.Object. What I find paradoxical, is a few methods on System.Object - namely public virtual string ToString(); public virtual bool Equals(object objA, object objB); System.String is inherited…
Dominic Zukiewicz
  • 8,258
  • 8
  • 43
  • 61
1
vote
2 answers

Paradox: Query a Date column + a Time column as a DateTime

First off, I'm a Paradox newbie. Secondly, I'm querying a database of a third-party software package and cannot change the schema. I have two fields simply named "Date" and "Time" that I'd like to query as a DateTime (from my MS SQL experience). Is…
Austin Salonen
  • 49,173
  • 15
  • 109
  • 139
1
vote
3 answers

Cancelling Record Changes

I am editing a record using a dbedit component, I have a cancel button but I'm not sure on how I can make it so all of the changes made using the dbedit components are reverted. I was thinking about copying the record either to a temp table or…
user863551
0
votes
1 answer

Can Python adodbapi be used to connect to a paradox db?

Can Python adodbapi be used to connect to a paradox db? If yes what would the connection string look like?
CodeLizard
  • 1,319
  • 2
  • 12
  • 20
0
votes
2 answers

What's the best approch to Covert Paradox(objectpal) system in to .Net?

We have old system in paradox and db is sqlserver 2000. We need to convert paradox(objectpal) system in to .net WPF. We create architecture in .net but any type of automation tool avilable so we can convert code of paradox into c# code ? or what's…
KuldipMCA
  • 3,079
  • 7
  • 28
  • 48
0
votes
1 answer

Datadirect Drivers for Paradox

I need to access my data stored in the Paradox database. I have installed Datadirect drivers for accessing the paradox database and have configured the User DSN and System DSN data source connections as mentioned in all the manuals. I still am not…
JJunior
  • 2,831
  • 16
  • 56
  • 66
0
votes
1 answer

Opened Paradox File Using PypxLib And Need to Insert Data into Dataframe

I was successful in opening a paradox .db file using PyPxLib and now I am searching for some type of code to insert the rows into a Pandas dataframe. from pypxlib import Table table = Table('d:/Projects/Lakeport/Data/bbrptfav.db') …
PMelan
  • 23
  • 4
0
votes
0 answers

How can Paradox Error point to something not in the code?

I've been using Paradox for many years, but just had a coding error that has me totally confused: I run Paradox V9 under Win 10 22H2. I had to modify some code, and on running it, was surprised to see a dialog that told me "An error was triggered in…
Lothar Krepke
  • 1
  • 1
0
votes
1 answer

How to re-size Paradox tables after records have been deleted?

I am using the Paradox 9 app as bundled with WordPerfect 2000. After deleting thousands of records from the table, the filesize remains at 500 kB even though there are now only 12 records. Is there a way to decrease the filesize to what it would be…
MrSnrub
  • 435
  • 4
  • 14
0
votes
0 answers

How to pass an SQL string to a paradox database using pypxlib?

Currently I try to work with data files from a measuring system using python. The data is saved in a paradox database format file.db. I would like to find a fast way to read these files into pandas dataframes. What I did so far is: from pypxlib…
Daniel
  • 1
0
votes
1 answer

Is it possible to connect to SQL Server from Paradox?

I have a module in Paradox where I have to write some records to a SQL Server database. Can this be done using ODBC? How can it be done? Thanks
sony
  • 1,453
  • 3
  • 35
  • 79
0
votes
1 answer

Python FileNotFoundError despite clearly having found the file

I'm working on a mailbomb program that randomizes images from a given directory. The code looks like this: import schedule, time, smtplib, random, os, sys, socket from email.mime.text import MIMEText from email.mime.image import MIMEImage from…
user12822419
  • 23
  • 8
0
votes
0 answers

Python SQLAlchemy insert into paradox db

I'm trying to insert something into paradox .db file, but I get this error: TypeError: visit_insert() takes 2 positional arguments but 3 were given I don't understand, what I'm doing wrong. I read docs and surf a lot, tried different code, but it…
ScapeKP
  • 1
0
votes
0 answers

How to use ODBC to connect with Paradox DB with PHP?

I'm currently working on a project: Write a Web Application that is able to make connection to pdx .db file. This post gave me a little hint, but it was not complete. What I got from it is basically to use ODBC to work with Paradox databases. But…
NcXNaV
  • 1,657
  • 4
  • 14
  • 23
1 2 3
…
11 12