IT SOLUTIONS
Your full service technology partner! 
-Collapse +Expand
KB
   ► KB ► > tables Posts  Print This     

tables Posts

"tables" Knowledge Base Posts

More...
  KB Article    

Mike Prestwood
1. The Future of Paradox Blog

If you have an existing Paradox system you can keep using it but you'll need to skip the Vista operating system and either stick with Windows XP or move to Windows 7. Because better tools exist, you may very well want to put a plan together now for converting to another development tool or at least understand what the future is likely to hold. If you're a power-user or researcher working with data, stick with Paradox.

Posted to KB Topic: Tool Basics
15 years ago, and updated 18 months ago
(44 Entries , last by maria.s3 )

Blog
Nothing New Since Your Last Visit
68105
Hits

Corel Paradox / ObjectPAL Coding

Douglas.M
2. Modern Storage Media is Much Better than the Old Days

This article discusses how storage media has improved dramatically since the early 1990s.

Posted to KB Topic: Hardware
31 months ago, and updated 23 months ago
(4 Comments , last by Pervez.J )

Article
Nothing New Since Your Last Visit
1761
Hits

Computer Tech

Douglas.M
3. Paradox ObjectPAL Dormant Customer Ordering Trend Report (Old and New Versions)

This article describes a Paradox ObjectPAL ordering trend reporting program I made that accepts a purchase order date range and a non-purchase order date range. It will report customers who bought during the purchase time period, but not during the non-purchase time period. There are 2 versions of this report. The older version uses only ObjectPAL Tcursors to perform the processing. The newer one incorporates programmatically executed queries in addition to Tcursors. The purpose of this report is to reveal those customers with declining sales.

Posted to KB Topic: OPAL: Reports
8 years ago, and updated 24 months ago

Article
Nothing New Since Your Last Visit
8094
Hits

Corel Paradox / ObjectPAL Coding

Douglas.M
4. How I Generate a List of Top Customers for a Specific Sales Representative

This is a useful report I made using the Paradox ObjectPAL coding to create a listing of top customers for a specific sales representative along with an order date range input. It’s a good insight into who your sales people are selling to and how much in a given time period.

Posted to KB Topic: OPAL: Reports
7 years ago, and updated 24 months ago

Article
Nothing New Since Your Last Visit
8182
Hits

Corel Paradox / ObjectPAL Coding

Douglas.M
5. What to do When Your Paradox Data Table View Comes up Black

A simple fix for Paradox data tables appearing totally black in data table view mode.

Posted to KB Topic: Paradox Tables
6 years ago, and updated 24 months ago
(2 Comments , last by mprestwood )

Article
Nothing New Since Your Last Visit
7926
Hits

Corel Paradox / ObjectPAL Coding
More...

"tables" Message Board Posts

More...

Thread 5 of 5

jseidel
Reading Paradox tables from Access 2007
I have an Access application that imports data from Paradox tables in an existing, external application (Timeslips by Sage). App was originally written in Access 2003 and I was able to link to several Paradox tables and read them successfully (no update is required). We upgraded to Access 2007 and the existing Paradox links work just fine but I have been unable to create new read-only links to more of the Timeslips' Paradox tables. The new Import wizard assumes a read-write link and then fails with the error:      "Unexpected error from external database driver (11010)." Development is on a Windows7 64-bit machine and deployed to a WindowsXP machine (soon to be upgraded to Windows7). I've tried linking on both machines and NoGo. I've also tried searching the web for code that could handle this but to no avail. Any suggestions as to how I can accomplish this?  Thanks very much.,
Posted to MB Topic: Access VBA Programming « Access Board
13 years ago
103 replies. Last post:

Mike.R4
{Too Long!}
13 years ago
Nothing New Since Your Last Visit
7253
Hits

Thread 4 of 5

dhowe
Could not open Paradox.net
One of our users got a new pc this week.  He has some Excel pivot tables that are reading data from Paradox tables via an odbc connection.  Every time he tries to refresh the data, he gets an error message saying 'Could not open Paradox.net'.  From what I understand, Paradox.net is the DOS version of pdoxusrs.net.  I had the user send me the Excel file and the table it was trying to access and it worked fine for me after setting up the alias that he initially used when he built this pivot table. I had the user search his hard drive for a file called Paradox.net, and one did not exist.  Does anyone have any idea why it would be looking for this file? Thanks, Doug
Posted to MB Topic: Paradox Setup, Vista, etc. « Paradox Board
14 years ago
Nothing New Since Your Last Visit
5461
Hits

Thread 3 of 5

grantr
String search and match with ()
Hi all, I have been trying to solve this one for a while without success. I receive pricelists from distributors that I convert to PDox9 tables, then perform searches for Product IDs to modify my internal table. All works perfectly well, except for the times when the Alpha field I am searching contains a parenthesis " ( or ) " . In this case the search is unable to match the record. I do not see this problem with fields containing  # /.  - = etc. I am using advancedWildcardsInLocate(Yes) for the session. Any way around this? I am unable to change the fields as they are manufacturer product IDs. Thanks in advance, Grant
Posted to MB Topic: Paradox Tables « Paradox Board
14 years ago
1 Reply:

grantr
Please ignore. I ended up solving it after adding the advancedWildcardsInLocate(Yes), and then changing from locatePattern() to simply locate(). I probably made the change prior for some reason haha. Grant
14 years ago
Nothing New Since Your Last Visit
77
Hits

Thread 2 of 5

epicurean
BDE Configuration
{Too Long!}
Posted to MB Topic: Delphi Object PASCAL « Delphi Board
14 years ago
13 replies. Last post:

Mollie.H
{Too Long!}
14 years ago
Nothing New Since Your Last Visit
19324
Hits

Thread 1 of 5

Yesid.B
ODBC Join tables
I am attempting to join two tables through an 'INDEX' field like so: SELECT w.LOCATION, w.BOLIN, w.DATEIN, w.LOT, w.QTY, w.UNITMEAS, w.CUSTCODE, w.WEIGHT, w.PRODUCTCODE, , w."INDEX", w.QUAR FROM wrhse AS w, items AS s , WHERE w.DATEOUT IS NULL AND s.poCode ='"+txtpoCode+"' AND w."INDEX" = s."INDEX" However I am not getting a result. Initially I was using the following: sql = 'SELECT * FROM subitemsTEST.DB WHERE poCode = '"+txtpoCode+"' order by index desc' to get the indexes and from there I would get the data from 'wrhse' having the indexes. But when I get more than 192 rows for some reason the system does not display the complete result set. Why can this be? How can I join two tables? Thank you in advance.
14 years ago
10 replies. Last post:

amna.s
If you need a limousine for an important occasion, such as a wedding or a client visit, you need to ensure that your service provider lives up to the expectations of the occasion.  https://alternativestips.com/alternatives-of-putlocker
14 years ago
Nothing New Since Your Last Visit
1051
Hits
More...


Icon Legend:
Since your last logged visit:
- New to you or updated since your last visit (sign in now to activate).
- NOT new to you since your last visit (sign in now to activate).
Go ahead!   Use Us! Call: 916-726-5675  Or visit our new sales site: 
www.prestwood.com


©1995-2020 Prestwood IT Solutions.   [Security & Privacy]