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

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

Prestwood eMagazine

November 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  

gwatchmaker
Database not open on executeqbe
{Too Long!}
Posted to MB Topic: ObjectPAL
63 hours ago
2 replies. Last post:

Steven.G
{Too Long!}
27 hours ago
New Stuff Since Your Last Visit
10
Hits

Thread 24 of 25
Thread Starter  

PS_3060

Hi,

I have started

Hi, I have started look at distributing my program in the office.  I moved the Data tables to the Server, deleted the .NET file and changed the .Net file in the BDE. Forms, files and reports work but it is crazy slow. The desktops are Core I5 250GB Ram and the server is running Windows Server 2016 Does anyone have any ideas as to why it is so slow
Posted to MB Topic: Paradox Setup, Vista, etc.
9 days ago
1 Reply:

Steven.G
it could be many different things, or any combination of them.. the app itself could be doing stuff in a manner that isn't sharing intelligently, it could be creating too much network traffic, it could be trying to lock stuff for multi-user use poorly, etc and/or the network could be getting swamped
8 days ago
Nothing New Since Your Last Visit
12
Hits

Thread 23 of 25
Thread Starter  

EnigmaVariation
Error Msg : error occured when setting ..proerty
{Too Long!}
Posted to MB Topic: Paradox Forms
12 days ago
3 replies. Last post:

Steven.G
let me see if I understand the context, first.. you're using a form to display a lookup table, instead of using the built-in lookup help, and move to the appropriate lookup record, as you move thru the main table.. yes?
11 days ago
Nothing New Since Your Last Visit
35
Hits

Thread 22 of 25
Thread Starter  

PS_3060

Hi All, I'm trying to chang

Hi All, I‘m trying to change the first field in a table which has copied data from another table. I have tried using the following code but it does not change the last record. I have tried this code as a stand alone bit of code on another button on the form and it works. The variable as can be viewed and are correct Paradox  11 is the version. if not tc2.open(":caliachData:CopyWindingData.DB") then errorshow(), else while tc2.eot() = false, tc2.edit() if tc2.fldTrfWdgPartNum = oldpno then tc2.fldTrfWdgPartNum = cpno tc2.nextrecord() Endif, , endwhile, , Endif Thanking yo in advance Cheers Bill
Posted to MB Topic: ObjectPAL
17 days ago
3 replies. Last post:

Bill.S6
Thanks, worked perfectly..
13 days ago
Nothing New Since Your Last Visit
33
Hits

Thread 21 of 25
Thread Starter  

Jay.M
Paradox 11 + Window 8.1.. Tablelookup problem
When trying to establish a table lookup thru restructure. I get the message paradox has stopped working.  I get a debug option and close option.. if I take debug.. the program shuts down.  Anyone know of a solution to this?
Posted to MB Topic: Paradox Setup, Vista, etc.
54 months ago
64 replies. Last post:

Steven.G
I'll repeat my comments from the newsgroup, we have a different audience here first, you should be using p11 0676, not 0411.. probably minor, if at all, but it's totally external second, I'm not aware of it testing anything "non-paradox".. it's testing that every table is valid, every linked table is valid, and every val file is valid
13 days ago
Nothing New Since Your Last Visit
3667
Hits

Thread 20 of 25
Thread Starter  

Sam.S
Auto email send from memo fields
I recently converted an app from 7.5 to paradox 11 and I am finding when entering Memo fields  with @ and . in them automatically do a mail.sendDLG() opening a new email message with the contents of the memo field as the TO: field. Does anyone know how to control this? Thanks
Posted to MB Topic: Paradox Forms
8 years ago
Nothing New Since Your Last Visit
5171
Hits

Thread 19 of 25
Thread Starter  

PS_3078
WordPerfect Office Pro 2020; No Change in Paradox?
Based in part on information from this board, I bit the bullet and upgraded to WP Office Pro 2020 from Version 8. The installation went smoothly, but when I opened Paradox it was still Version 11. Comparing it to my laptop, it's exactly the same release, 11.0.0.676! I then uninstalled and reinstalled Paradox with the same result. Did I do something wrong? Is there a newer version of Paradox, and if so why don't the update program install it? If this is true, then Corel is ripping off customers — I could have saved $100 by purchasing the standard upgrade instead of the Pro version (Paradox being the only difference, I think). 
Posted to MB Topic: Paradox Setup, Vista, etc.
45 days ago
3 replies. Last post:

Steven.G
thanks.. to Corel, paradox is just a black box that they include with the suite.. I thought the reg cleaner was removed, evidently I'm wrong and/or they put it back
43 days ago
Nothing New Since Your Last Visit
51
Hits

Thread 18 of 25
Thread Starter  

rum
How to Trap a mouse?
Are there any examples of how to trap an event for a scroll wheel of a mouse?, , I am having an issue with users unitentionally adding a record by scrolling the mouse wheel.   The form proprty AutoAppend is set to false,  and I trap Pg up and Pg down keys to prevent this issue.   Unfortunately I have not been able to trap the mouse wheel.
Posted to MB Topic: ObjectPAL
43 days ago
2 replies. Last post:

Steven.G
and I know that was the specific reason I turned auto append off on that form.. I remember the problem it created when somebody decided to play "wheel of fortune" on that form (sigh)
43 days ago
Nothing New Since Your Last Visit
38
Hits

Thread 17 of 25
Thread Starter  

PS_3060
Setting Upper Case in a search field
I have a search firld on a form which works fine except I need to change all characters to upper case. This is the code. It used to work but something has changed. var, pn string, endvar doDefault pn = self.value, pn = pn.upper() PTMPTNO.setRange( pn, pn+"z" ) Cheers
Posted to MB Topic: Paradox Forms
51 days ago
10 replies. Last post:

Steven.G
ok, an undefined field.. first, that little bit of code should work.. but second, you can still use real fields from dummy tables, in situations liek this, if pictures, lookup tables, etc. can help
46 days ago
Nothing New Since Your Last Visit
62
Hits

Thread 16 of 25
Thread Starter  

PS_3078
Paradox View Setting
Is there a way to force Paradox to open forms in the "fit width" mode? The font it uses otherwise is rather small and difficult to read. However, if I change it to "fit width," it reverts to 100% when I exit and restart the program. Thanks.  
Posted to MB Topic: Paradox Setup, Vista, etc.
53 days ago
1 Reply:

Steven.G
MAXIMIZE() and/or any of the MenuProperty options MENUACTION(MENUPROPERTIESZOOM100)
50 days ago
Nothing New Since Your Last Visit
25
Hits

Thread 15 of 25
Thread Starter  

PS_3078
Paradox Settings not Retained
{Too Long!}
Posted to MB Topic: Paradox Setup, Vista, etc.
56 days ago
16 replies. Last post:

Steven.G
yes.. you edit the shortcut on the desktop, then move it to the taskbar.. that's what I said, too I keep it clean by keeping all of my shortcuts grouped into a few folders on the desktop
55 days ago
Nothing New Since Your Last Visit
92
Hits

Thread 14 of 25
Thread Starter  

Sam.S
Accessing an FTP with filesystem in ObjectPal
{Too Long!}
Posted to MB Topic: ObjectPAL
44 months ago
Nothing New Since Your Last Visit
2109
Hits

Thread 13 of 25
Thread Starter  

Pete.D2
Editing on a form without keying F9
Is it possible not to have to press F9 to start editing fields on a form? The form I am working on ties the fields to a Paradox db table.
Posted to MB Topic: Paradox Forms
40 months ago
Nothing New Since Your Last Visit
965
Hits

Thread 12 of 25
Thread Starter  

PS_3060
Fixed No of Rows in Table Frame
Is it possible to fix the number of rows in a MRO table frame even if only the first 4 or 5 are populated? I'm trying to make a complex form and report which fills the total area available.
Posted to MB Topic: Paradox Reports
60 days ago
1 Reply:

Steven.G
most anything you can change while editing a form, you can change by setting values when you open it.. you just need to find the right parameters to set fm.open(myform) fm.thistext = "Hello" fm.thisfield = "George" fm.wait()
59 days ago
Nothing New Since Your Last Visit
47
Hits

Thread 11 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
68 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
67 days ago
Nothing New Since Your Last Visit
56
Hits

Thread 10 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
69 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
67 days ago
Nothing New Since Your Last Visit
50
Hits

Thread 9 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
83 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. 
82 days ago
Nothing New Since Your Last Visit
113
Hits

Thread 8 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
10 months ago
Nothing New Since Your Last Visit
165
Hits

Thread 7 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
1842
Hits

Thread 6 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
4 months 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.
113 days ago
Nothing New Since Your Last Visit
141
Hits

Thread 5 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
2348
Hits

Thread 4 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.
5 months ago
Nothing New Since Your Last Visit
1997
Hits

Thread 3 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
2731
Hits

Thread 2 of 25
Thread Starter  

Milflyer
Paradox9 & Windows 10
{Too Long!}
Posted to MB Topic: Paradox Setup, Vista, etc.
6 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.
6 months ago
Nothing New Since Your Last Visit
170
Hits

Thread 1 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
5484
Hits

Follow PrestwoodBoards on: 


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