I.T. Discussion Community!
-Collapse +Expand
Paradox
Search Paradox Group:

Advanced
-Collapse +Expand Paradox To/From
To/FromCODEGuides
-Collapse +Expand Paradox Store
PRESTWOODSTORE
   ► MB LobbyAll Groups   Print This    All Groups  

Paradox Coding Message Board

Corel Paradox / ObjectPAL Coding Q&A

Paradox Coding Message Board (Q&A). Free help! Answer questions. Part of our Paradox Group. Corel Paradox for Windows and ObjectPAL group (was Borland Paradox). Covering all versions of Paradox for Dos, Paradox for Windows, and Paradox for Linux including help with the BDE and Paradox tables.

To start a new thread, choose a topic, then click [New Thread].

Paradox Specific Topics

TopicThreadsPostsLast Active Thread 
Paradox Setup, Vista, etc.138768
rum
RE: Paradox9 & Windows 10
MilFlyer, Beware the export limit.  Exporting to the xls format from Paradox will only export the first 16,384 records in a table. If you want to private message me your email.   I have a library that will dump the tables to excel for you.
4 months ago
Nothing New Since Your Last Visit
Paradox Tables80353
grantr
RE: String search and match with (
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
4 months ago
Nothing New Since Your Last Visit
Paradox Forms121554
Steven.G
RE: Print form without user intera
action(DataPrint) is the app equivalent for "File/Print" or hitting Ctrl-P I'm pretty sure there's a "current record capture" option buried in there somewhere, but can't think of it offhand
6 days ago
Nothing New Since Your Last Visit
Paradox Reports52228
afhynes2
LCAppPrint initialize failed Paradox V11
Back after yeeaars in the wilderness. I've tried this again and get the same result. I can print a report if I do it through and objectPAL script. Load the report and print. But if I just open the report, I get the same result and Paradox closes. Also, I can't print things like info structure. Paradox just falls over.
7 months ago
Nothing New Since Your Last Visit
QBE & SQL56218
Steven.G
RE: Connecting to PostgresSQL serv
> ":PostgreSQL35W:" are you certain that the alias itself is correctly defined in the BDE and/or the app? > msginfo("Caliach Database Not Open", "stop") throw in an errorshow(), too.. might answer the question
6 days ago
Nothing New Since Your Last Visit
Application Framework1242?No Subject!
--
Nothing New Since Your Last Visit
ObjectPAL8826113
PS_2032
RE: Libraries
I read somewhere that paradox puts the command into some sort of queue and makes you think it worked. I finally got it to work. It must be the very last line of code before endmethod. Not even an endif statement can be after it. Supposedly you can leave a form open by trapping for an eventID. I haven't tried that yet. This particular thing I was working on was just a script. Didn't used to be so touchie. 
21 days ago
Nothing New Since Your Last Visit
Paradox for Linux1036
rt
RE: Paradox and linux
{Too Long!}
11 years ago
Nothing New Since Your Last Visit
Paradox Third Party Books & Documentation946
FlaglerMuseum
New Paradox User

Help!!!  I am a new Paradox user and I am not a programmer or a techie.  I've been working here for 6 months and have been able to figure out how to create basic forms and reports but I'm trying to find training or manuals that will get me to the next level.  Any suggestions?  Thanks.

13 years ago
Nothing New Since Your Last Visit
Paradox Third Party Software, DLLs, and Controls3088
Jose Brinkmann
RE: ProView
Hello, just copy the file VMPM1.dll to the system32 folder in your windows directory and it should work. Many thanks, Jose
37 months ago
Nothing New Since Your Last Visit
Paradox to/from Other Data Sources75286
Anonymous
RE: Runtime error 216 at 00002E28
6 months ago
Nothing New Since Your Last Visit
Paradox Web Stuff50175?No Subject!
--
Nothing New Since Your Last Visit
Paradox Graphs & Charts1365?No Subject!
--
Nothing New Since Your Last Visit
Paradox Runtime & Distribution47174?No Subject!
--
Nothing New Since Your Last Visit
Convert To/From Paradox1549?No Subject!
--
Nothing New Since Your Last Visit
Paradox for DOS1372?No Subject!
--
Nothing New Since Your Last Visit

Newest Posts...

New Posts: Paradox Board

More...

Thread 10 of 10
Thread Starter  

PS_3060
Connecting to PostgresSQL server
Hi,  I have been dragged back from retirement to fix a small Paradox database we use for design. Previously I used the Paradox ODBC to connect to the DB and all was well. The DB is now a PostgreSQL databse. I have installed the ODBC connection and can connect useing Access.  PostgreSQL35W ODBC System DSN On the paradox form I have a button to connect to the DB useing the following Code dynalias["UserName"] = "aaaaa", dynalias["Password"] = "XXXXXX" if not db.open(":PostgreSQL35W:", dynalias) then   ;Which Is the ODBC System DSN, , msginfo("Caliach Database Not Open", "stop") else message.visible = true ;UPDATE NEW PARTS, message = ("UPDATING PARTS DATA") sqlvar = sql SELECT PTMPTNO, PTMP1CD, PTMSTUM, PTMSEQ,PTMSATX , PTMUSE1, PTMUSE2, FROM altro.PTMFILE altro_ptmfile, WHERE PTMSEQ > ~oldptmseq, endsql executeSql(db, sqlvar, ":caliachData:NewParts"), , endif How do I change this to connect to the Postsgres35 DYN?
Posted to MB Topic: QBE & SQL
7 days ago
1 Reply:

Steven.G
> ":PostgreSQL35W:" are you certain that the alias itself is correctly defined in the BDE and/or the app? > msginfo("Caliach Database Not Open", "stop") throw in an errorshow(), too.. might answer the question
6 days ago
Nothing New Since Your Last Visit
17
Hits

Thread 9 of 10
Thread Starter  

GaryG
Print form without user interaction
I would like to print the current form from a button. This can be done in objectPal by performing postaction(DataPrint) or action(DataPrint) When the postaction(or action) is performed, the printer dialog box pops up. I would like to perform this print action without the user having to click the Print button on the printer dialog box. I have tried using sendKeys with different options. Do you know of a way to print a form without any further using interaction other than clicking the button I have added on the form? Thanks
Posted to MB Topic: Paradox Forms
8 days ago
1 Reply:

Steven.G
action(DataPrint) is the app equivalent for "File/Print" or hitting Ctrl-P I'm pretty sure there's a "current record capture" option buried in there somewhere, but can't think of it offhand
6 days ago
Nothing New Since Your Last Visit
26
Hits

Thread 8 of 10
Thread Starter  

PS_2032
Libraries
I‘ve taken libraries that were originally made in previous versions of paradox. I have successfully resaved them under paradox 9 with no syntax errors. Then I deliver them. Problem is when I try to reference the delivered library vs the source, I get an error that this file doesn‘t have any symbol table information. Anybody know why?
Posted to MB Topic: ObjectPAL
22 days ago
20 replies. Last post:

Rick.E
I read somewhere that paradox puts the command into some sort of queue and makes you think it worked. I finally got it to work. It must be the very last line of code before endmethod. Not even an endif statement can be after it. Supposedly you can leave a form open by trapping for an eventID. I haven't tried that yet. This particular thing I was working on was just a script. Didn't used to be so touchie. 
21 days ago
Nothing New Since Your Last Visit
78
Hits

Thread 7 of 10
Thread Starter  

Ash.B2
Hiding the desktop
I read a short article that says in order to not see the desktop, and only my forms, I need to use app.hide() The problem is that when I try it, I get syntax errors.  I've searched through the boards and through the ObjectPal guide that I have, but I have not been able to find out exactly how to do this (what code and where) I also cannot seem to find where in the Object Explorer it is indicated whether a form is a child or a dialog.  I know this seems simple, but its very frustrating.  Thank you for your help.
Posted to MB Topic: Paradox Forms
8 months ago
Nothing New Since Your Last Visit
146
Hits

Thread 6 of 10
Thread Starter  

grimchri
How to use ObjectPAL to define Lookup Table?
Is there any way to specify Table Lookup settings when using the Table type to create a new table? I've thouroughly searched the PAL help, and then resorted to trying to use sendKeys after creating the temporary table I need, but nothing works. {#confused} (I have had little success and many problems with sendKeys since upgrading to version 9.) If necessary, I will just use an interactively created table and copy it to each machine, but it would be much better to avoid this since the table is of temporary nature., , Thank you!
Posted to MB Topic: ObjectPAL
19 years ago
Nothing New Since Your Last Visit
1828
Hits

Thread 5 of 10
Thread Starter  

GaryG
printerSetCurrent is hanging
Our entire user base is running 11.0.0.676 on Windows 10. I believe this is the latest version of Paradox. Today, there is 1 user whose Paradox app is hanging when executing  the command printerSetCurrent. Rebooting does not correct the issue. code snippet: stPrnName = "Win2PDF" if printerSetCurrent(stPrnInfo) then ; THIS LINE HANGS,      setRegistryValue("Software\\Dane Prairie Systems\\Win2PDF", "PDFFileName", pathstring , regKeyCurrentUser),      setRegistryValue("Software\\Dane Prairie Systems\\Win2PDF", "file options", 2, regKeyCurrentUser),      setRegistryValue("Software\\Dane Prairie Systems\\Win2PDF", "persistent", "0", regKeyCurrentUser), else,      errorShow("Failed to make Win2PDF the current printer"), endIf Has anyone run into similar issues with printerSetCurrent? Thanks, Gary
Posted to MB Topic: Paradox Forms
80 days ago
7 replies. Last post:

josephpnorris
We've had this problem "forever" and haven't figured it out.  Windows 7.    It seems to come and go, but could be related to unusual status of one of your printers.   Try rebooting, etc.  Try removing unneeded printers.
52 days ago
Nothing New Since Your Last Visit
113
Hits

Thread 4 of 10
Thread Starter  

Marcus Davis
Paradox 9 Printing Error
Has anyone received the error shown below when trying to print from Paradox 9? If so, how do I get rid of it? , , /// Print Interface Setup Error ////, PFPS Initialized failed!, , Thanks,, Marcus
Posted to MB Topic: ObjectPAL
19 years ago
Nothing New Since Your Last Visit
2322
Hits

Thread 3 of 10
Thread Starter  

The Big Jerm
Opening a Tcursor on Saddam
Var , tc tcursor, sadam butthead, endvar, , tc.open(":buttheads:sadam"), scan tc:
Posted to MB Topic: ObjectPAL
17 years ago
6 replies. Last post:

uwuefr.n
Opening a tcursor on saddam which is an open training center was for all students as well as students. Students can increase knowledge because it is important for them to increase knowledge after getting all kinds of helping from best paper writing service 2020 and use it in your education.
88 days ago
Nothing New Since Your Last Visit
1974
Hits

Thread 2 of 10
Thread Starter  

juan@pcexperts.com
HowTo: Search for records not in another table
I need to create a query using the QBE that will list all records from table A not in table B. (A not-in query), , Thanks
Posted to MB Topic: Paradox Forms
19 years ago
Nothing New Since Your Last Visit
2706
Hits

Thread 1 of 10
Thread Starter  

Milflyer
Paradox9 & Windows 10
{Too Long!}
Posted to MB Topic: Paradox Setup, Vista, etc.
4 months ago
9 replies. Last post:

Jeff.R3
MilFlyer, Beware the export limit.  Exporting to the xls format from Paradox will only export the first 16,384 records in a table. If you want to private message me your email.   I have a library that will dump the tables to excel for you.
4 months ago
Nothing New Since Your Last Visit
133
Hits
More...

Unanswered: Paradox Message Board

Answer an unanswered thread. Even old threads. Our goal is to have a complete and thorough resource.


Thread 4 of 4

rum
Order of Events
{Too Long!}
Posted to MB Topic: Paradox Forms
6 months ago
Nothing New Since Your Last Visit
52
Hits

Thread 3 of 4

PS_2442
Hello theis is Maior, I am new here.
At one time I was very good at using Paradox, and now I am back to using it again.
Posted to MB Topic: Paradox Web Stuff
9 months ago
Nothing New Since Your Last Visit
115
Hits

Thread 2 of 4

rum
Mouse WHEEL Movement
In PDOX 8,  the mouse wheel had no impact on the paradox environment,  It just didn't work. Now in PDOX 11,  the mouse wheel is allowing users to scroll off of the record they should be Adding/Editing.  The user is then focused on a blank screen. Is there a way to trap that event?  I dont see any clues in the help doicument when it comes to scrolling mouse wheels. Currently I use the KeyPhysical event to prevent users from using the arrow keys to move from record to record,  but does not prevent the MOUSE action
Posted to MB Topic: Paradox Forms
30 months ago
Nothing New Since Your Last Visit
465
Hits

Thread 1 of 4

Mir Hussain
Is MBA Worth it in Today's Fast-Paced World
{Too Long!}
Posted to MB Topic: Paradox Setup, Vista, etc.
46 months ago
Nothing New Since Your Last Visit
975
Hits
More...

Icon Legend:
Recent or not:
- Recent activity (within last two weeks).
- No activity last two weeks.
 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).



New Thread Notifications

New thread subscribers: ASPGuy   augustus    Ben.N   Bob S.   Cfolkes    cirfab   Cottage Builder   csgPdx   edumor    Emilio.O   Enigma Variatio   Gary.A2   H. Tadema    Hawkman   hedrickr   hicham_tawil   howard.a   Jay.M   jn316sc   joaquin.c   Joe.P   joeroark   John Andres   josephpnorris   jrradtke   Kathy D   marianchovan   Martijn.G   Michael Mitsch   OzPaul    ParaDelphi   Paulo.C   Philip G Graham   philiptdotcom    pronegot   PS_1789   PS_193   RalphG   riskmansea   Ruby Yarter   rum   SAJJADS    Sam.S   SamSpade   Steven.G   Techpart87   themadhatter1    tony-jordan   tsensor   

Want to subscribe? Sign in to subscribe to new activity posted to this group.

Follow PrestwoodBoards on: 


©1995-2020 PrestwoodBoards  [Security & Privacy]
Professional IT Services: Coding | Websites | Computer Tech