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
3
votes
1 answer

SSIS how to import data from Paradox?

I'm trying to import data coming from a Paradox Database (all files *.DB are located in a folder) to Sql server 2008 with SSIS 2008. From my OLE DB Source, I created a new Connection using Jet 4.0 OLE DB Provider and then specified "Paradox 5.0" in…
largo68
  • 609
  • 2
  • 16
  • 29
3
votes
3 answers

Paradox SetRange does not provide correct result when querying 3 fields

I have a problem with setting a range on a secondary index in a Paradox 7 table using Delphi2010. The relevant fields are: FeatureType (int); YMax (int); XMax (int); YMin (int); Xmin (int). The secondary index contains all these fields in this…
bosvos
  • 549
  • 5
  • 14
3
votes
4 answers

Import data from Excel

I want to import data from Excel into a Paradox database on Delphi 7. How can I do that using Delphi?
user578332
  • 325
  • 1
  • 5
  • 16
3
votes
4 answers

How to update report in access with bound dataset automatically?

I have a single entry output from a paradox table which is imported into Access. Now I have created a report and done the databinding within the report to the dataset from Paradox. When work is done in Paradox the single entry output…
CGF
  • 313
  • 3
  • 5
  • 15
3
votes
3 answers

Convert Paradox to MDB

I need to access an database in DB (paradox) files. I'm in a project that will be used Delphi and Access (i know it's very old but the customer want this) and the old project use paradox database. I would like to know, if is there any program to…
Felipe Oriani
  • 37,948
  • 19
  • 131
  • 194
3
votes
1 answer

(?,?...?) or (@field1,@field2...@fieldn) in parmeterized queries?

Is this bad coding? I have a query INSERT INTO sometable (field1,field2...fieldn) VALUES (?,?,.....?) Then cmd.Parameters.Add("TOFnr", OdbcType.Int, 10).Value = orderId; cmd.Parameters.Add("LineNr", OdbcType.Int, 10).Value =…
Leif Neland
  • 1,416
  • 1
  • 17
  • 40
3
votes
1 answer

Connecting to Paradox database through Windows ODBCCONF command line

I use Eclipse to manipulate Paradox databases with a HXTT Paradox Driver. But now i would like to create data sources through Windows ODBC and use ODBC-JDBC bridge for connection through command line or .BAT files. I've tried the…
Diego Victor de Jesus
  • 2,575
  • 2
  • 19
  • 30
3
votes
3 answers

Bertrand's Paradox Simulation

So, I saw this on Hacker News the other day: http://web.mit.edu/tee/www/bertrand/problem.html It basically says what's the probability that a random chord on a circle with radius of 1 has a length greater than the square root of 3. Looking at it,…
Jonas Schreiber
  • 447
  • 4
  • 13
3
votes
2 answers

install PARADOX extension for PHP

I have an ApacheFriends XAMPP running on my windows machine and i am trying to access some Paradox database files directly from PHP. I see that there is an extension for this but how can i install it for my windows system?
Mike
  • 965
  • 4
  • 15
  • 24
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
1 answer

Paradox DB: cyrillic words in a query, C#

I need to execute a query to Paradox database. There is a table, that contains data with cyrillic words and I'm trying to use cyrillic parameters in a query like this: select * from AccessZone zn where zn.Name= 'Территория' In AccessZone table i…
Nick
  • 49
  • 6
3
votes
2 answers

How does Paradox manage null and empty values?

I'm using Paradox tables through Borland Database Engine (BDE). I'm not able to realise the way null and empty string values are handled in string fields (Paradox data type "A"). My specific problem is how to determine if a field value is null or…
bluish
  • 26,356
  • 27
  • 122
  • 180
3
votes
2 answers

Pulling Text From a Memo Box Line by Line

I need to go through a ton of data that is stored in a paradox table within a Memo field. I need to process this data line by line and process each line. How can I tell Delphi to fetch each line in the memo field one by one? Could I use #13#10 as a…
user863551
2
votes
1 answer

Paradox Database with BDE - Forcing changes to disk while database/table open

We have a Paradox Database table that we want to mirror across the network using something like DSynchronize. The issue that I am seeing is that Paradox through the BDE (Borland Database Engine) does not update the file system until the table is…
Nevar
  • 61
  • 1
  • 5
2
votes
1 answer

Writing in Paradox tables in .Net with a specific Langdriver

I'm trying to add values in a paradox table with c#. The point is that this table is containing localized strings, for which the Langdriver ANSII850 is required by the BDE. I tried to use both OLEDB and Odbc drivers in .Net, but I cannot write…
ghusse
  • 3,200
  • 2
  • 22
  • 30
1
2
3
11 12