Corel Paradox / ObjectPAL Coding New Activity

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

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

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

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

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.  (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

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

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

Var , tc tcursor, sadam butthead, endvar, , tc.open(":buttheads:sadam"), scan tc:

Posted to MB Topic: ObjectPAL

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

{Too Long!}

Posted to MB Topic: Paradox Setup, Vista, etc.

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.

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.

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

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.

{Too Long!}

Posted to MB Topic: Paradox Setup, Vista, etc.

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

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

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

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.)

Posted to MB Topic: Paradox to/from Other Data Sources

{Too Long!}

Posted to MB Topic: QBE & SQL

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.

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.

{Too Long!}

Posted to MB Topic: Paradox Forms

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

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.