IT SOLUTIONS
Your full service technology partner! 
-Collapse +Expand
Paradox
Search Paradox Group:

Advanced
-Collapse +Expand Paradox To/From
To/FromCODEGuides
-Collapse +Expand Paradox Store
PRESTWOODSTORE

Prestwood eMagazine

September Edition
Subscribe now! It's Free!
Enter your email:

   ► MB LobbyCorel Paradox / ObjectPAL Coding Board   Print This    All Groups  

Corel Paradox / ObjectPAL Coding New Activity

Switch to:  New Posts (ALL TYPES)
  


25 Threads:


Thread 25 of 25
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
65 hours 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
59 hours ago
New Stuff Since Your Last Visit
13
Hits

Thread 24 of 25
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
4 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
59 hours ago
New Stuff Since Your Last Visit
21
Hits

Thread 23 of 25
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
18 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. 
17 days ago
Nothing New Since Your Last Visit
77
Hits

Thread 22 of 25
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 21 of 25
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
1826
Hits

Thread 20 of 25
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
76 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.
48 days ago
Nothing New Since Your Last Visit
111
Hits

Thread 19 of 25
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 18 of 25
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.
84 days ago
Nothing New Since Your Last Visit
1972
Hits

Thread 17 of 25
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
2705
Hits

Thread 16 of 25
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
129
Hits

Thread 15 of 25
Thread Starter  

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.
11 years ago
Nothing New Since Your Last Visit
5461
Hits

Thread 14 of 25
Thread Starter  

PS_2827
Paradox 9 SP4
I am trying to find Paradox 9 sp4 to try and fix printing report issue where paradox stops responding.  Anyone have a download link? Thanks
Posted to MB Topic: Paradox Setup, Vista, etc.
4 months ago
2 replies. Last post:

Steven.G
{Too Long!}
4 months ago
Nothing New Since Your Last Visit
69
Hits

Thread 13 of 25
Thread Starter  

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
4 months 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
4 months ago
Nothing New Since Your Last Visit
75
Hits

Thread 12 of 25
Thread Starter  

Delordson
Paradox 10 hanging since upgrade to Windows 10
Hi, Has anyone managed to get Paradox 10 working satisfactorily on Windows 10? Care to share your setup please? We upgraded to Windows 10 last week and since then Paradix hangs 4-5 times a day. We manage to get it going again by having everyone log off and deleting all the lock files but it's getting a but frustrating. We have our data in a shared folder and everyone is pointing to the same .NET file. I've tried every suggestion I've seen here and elsewhere with no luck so far. Any tips, pointers, suggestions gratefully received.  Thanks  Delordson
Posted to MB Topic: Paradox Setup, Vista, etc.
7 months ago
15 replies. Last post:

Steven.G
Chimney Sweep.. but for most folks, I say that you don't want an automated routine cuz it makes it more likely that you won't actually look at the results after the repair.. REAL damage will show easily, via bad number and date values and/or missing records
4 months ago
Nothing New Since Your Last Visit
235
Hits

Thread 11 of 25
Thread Starter  

fredvh
Paradox 10: Unable to open table
{Too Long!}
Posted to MB Topic: Paradox Setup, Vista, etc.
11 years ago
Nothing New Since Your Last Visit
6947
Hits

Thread 10 of 25
Thread Starter  

PS_2762
Opening A Form
I am absolutely brand new to programming in Paradox. I want to make a Main form. For ease of discussion, I just want to create a form which I have done that has one button. I want it to opne a form I already have linked to a table. I get a syntax error. I cannot find any build as you go coder. I have this and it gives me a syntax error: method action(var eventInfo ActionEvent), open("TestReview Form"), endMethod The form is in the same working folder as this Main form. Does anyone know what the syntax is to simply open a form? No parms passed, just open the form in data entry mode.
Posted to MB Topic: Paradox Forms
5 months ago
9 replies. Last post:

Steven.G
first, that code should be on the pushbutton event.. I should have noticed that you put it somplace else second, what is your intended interaction with WP and or QP? third, any modern database platform will usually be SQL-based.. can't make any specific recommendations beyond that
5 months ago
Nothing New Since Your Last Visit
70
Hits

Thread 9 of 25
Thread Starter  

PS_2579

Hello Prestwood,

I

Hello Prestwood, I am once again asking for your support.  During the coronavirus lockdown I decided it was a good time to simplify my reports. One of the challenges I face is a set of 2d bar graphs I have created from a table.  Note my X axis data points will vary greatly: I believe I have run into a glitch I will not be able to fix.  The X axis 'ticks' keep counting but the data isnt showing up. If i play around resizing the graph in design, it may or may not fix it. I would like to sort this out so I do not have to manually involve myself further. I uploaded an image of my issue to imgur https://imgur.com/a/uWrA9rC  (imgur is a safe site, with many photos of cats) THANK YOU
Posted to MB Topic: QBE & SQL
5 months ago
2 replies. Last post:

Peter.P3
hahaha, well ill figure something out. Got plenty of time recently
5 months ago
Nothing New Since Your Last Visit
95
Hits

Thread 8 of 25
Thread Starter  

rajab_ali_moham
paradox 11 or 12 standalone
Hi...., how we can optain pdox11 or pdox12 stanalone, is it a good decision upgrate pdox7 to pdox11 or pdox12?, any help...., t...u..... in advance
Posted to MB Topic: ObjectPAL
16 years ago
Nothing New Since Your Last Visit
1535
Hits

Thread 7 of 25
Thread Starter  

harri_kukkonen
Runtime error 216 at 00002E28
Summary: GPV, importing a table from excell. Table is based an access query. Workstation: XP sp2, Network: Windows server, All files, tables and forms etc, on the servers

(Moved from knowledge base.)
12 years ago
4 replies. Last post:

Anonymous
6 months ago
Nothing New Since Your Last Visit
5670
Hits

Thread 6 of 25
Thread Starter  

PS_2579
alpha to numeric
{Too Long!}
Posted to MB Topic: QBE & SQL
7 months ago
2 replies. Last post:

Peter.P3
Hi Steven,  Im sorry i didnt reply earlier, I didnt forget about you :) I finally got around to using this script in my report and so far it seems to be working.  Thanks a million! -Pete
6 months ago
Nothing New Since Your Last Visit
118
Hits

Thread 5 of 25
Thread Starter  

Jeff Wampler
Paradox on Windows 10 Locking Up
I have a customer that insists on continuing to use Paradox. We have the files stored on a file server that has a share that is mapped to all users workstations as a drive. It has been working fine for years. Recently, we migrated the server to from 2008 R2 to 2016. We now have users complaining about the application locking up especially if inactive for a while. I'm wondering if anyone has an ideas to prevent this from happening? Thanks, Jeff
Posted to MB Topic: Paradox Setup, Vista, etc.
10 months ago
24 replies. Last post:

Steven.G
open tcursors are the killer in MANY apps
6 months ago
Nothing New Since Your Last Visit
295
Hits

Thread 4 of 25
Thread Starter  

PS_2258
Paradox to Paradox 11
I purchased Paradox 11without wordperfect. I recall seeing a post about the need to recompile the Data in order to use it in 11. Can someone direct to the post or provide the procedure of how to recompile? Thank you.
Posted to MB Topic: Paradox Setup, Vista, etc.
6 months ago
1 Reply:

Steven.G
if you have libraries and/or other compiled pieces (fdl, rdl, sdl), you need to open each one and compile, then save.. the libraries first, then all the other pieces
6 months ago
Nothing New Since Your Last Visit
48
Hits

Thread 3 of 25
Thread Starter  

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

Thread 2 of 25
Thread Starter  

Bob S.
Database Desktop on Windows 10
I've been using Database Desktop for years to maintain Paradox tables, but it now appears that DBD doesn't work on Windows 10 for build 1703 or later.  Is there an updated DBD that does work?  Or is there an alternative tool I can use?  I've found several tools that will let me view and modify the data in Paradox tables, but none that will let me modify the table structures.  Any suggestions?
Posted to MB Topic: Paradox Tables
31 months ago
9 replies. Last post:

Jeff.R3
{Too Long!}
6 months ago
Nothing New Since Your Last Visit
1971
Hits

Thread 1 of 25
Thread Starter  

coconut73
pssendmail work with windows 10 paradox 11?
https://www.prestwoodboards.com/Products/psSendMail/ i have been using pssendmail since 2009 on win7 paradox 10. i just upgrade to a new windows 10 machine that needs pssendmail and cannot get it to function.   Are there any problems with running on win 10 pro / paradox 11? Thanks scott
Posted to MB Topic: Paradox Setup, Vista, etc.
7 months ago
1 Reply:

Steven.G
I haven't use that, and I'll make sure Mike sees this thread, but.. there are many issues with using the old MAPI Mail() processes that Paradox uses. with Win10
7 months ago
Nothing New Since Your Last Visit
91
Hits
Go ahead!   Use Us! Call: 916-726-5675  Or visit our new sales site: 
www.prestwood.com


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