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

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

   ► MB LobbyCorel Paradox / ObjectPAL Coding Board   Print This     

Paradox Forms Topic

Including form usage, form coding issues, calculated fields, and the data model.
 Show:
New Activity New Threads Oldest Unanswered Most Active Most Read
  


25 Threads:

Add New ThreadRandom Thread

Thread 25 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
16 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
11 days ago
Nothing New Since Your Last Visit
35
Hits

Thread 24 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.
39 months ago
Nothing New Since Your Last Visit
951
Hits

Thread 23 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
34 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
32 days ago
Nothing New Since Your Last Visit
40
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.
9 months ago
Nothing New Since Your Last Visit
153
Hits

Thread 21 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
106 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.
78 days ago
Nothing New Since Your Last Visit
129
Hits

Thread 20 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
19 years ago
Nothing New Since Your Last Visit
2713
Hits

Thread 19 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.
6 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
6 months ago
Nothing New Since Your Last Visit
74
Hits

Thread 18 of 25
Thread Starter  

rum
Order of Events
{Too Long!}
7 months ago
Nothing New Since Your Last Visit
54
Hits

Thread 17 of 25
Thread Starter  

Ash.B2
Populating drop down from a table
{Too Long!}
9 months ago
5 replies. Last post:

Ash.B2
Thanks so much, Rum! I took your code and refined it to my purposed.  No arrays for me, so I was able to simplify it, and in the end it wound up working better than I actually had planned!  (Was able to sort just by selecting the drop-down menu item, didn't need a separate button, like I thought I would) This worked very well, and I thank you. Ash
8 months ago
Nothing New Since Your Last Visit
374
Hits

Thread 16 of 25
Thread Starter  

PS_1093
Error occurred while reading graphic file
Hi guys, In my form i inserted a graphic object. But when i right click and use the paste from graphic file and selected any graphic file it say, "Disk error occurred while reading file." "Error occurred while reading graphic file." Have you encountered the same error ? Any idea how to resolve this?, , Thank you in advance for your help., , -yuz
8 months ago
1 Reply:

Steven.G
I have not used that funtion in many years.. my first guess is that it doesn't understand the file type.. remember, this is 25 year old technology, based on simple bmp logic
8 months ago
Nothing New Since Your Last Visit
59
Hits

Thread 15 of 25
Thread Starter  

JFWconsult
Implementing a Reusable Progress Bar in Paradox
Mike, Re your "Implementing a Reusable Progress Bar in Paradox" form for download. I have downloaded it but am unable to open it. Paradox suggests that the form may be corrupt. Can you check please.
9 years ago
8 replies. Last post:

Steven.G
it comes back.. it's possessed :-)
11 months ago
Nothing New Since Your Last Visit
1544
Hits

Thread 14 of 25
Thread Starter  

Ash.B2
Bringing the Active record to a new form
{Too Long!}
12 months ago
2 replies. Last post:

Ash.B2
Never mind. Tried for a few days, couldn't get libraries to work (maybe a windows 10 issue?), but I figured it out using a query to a temp table, and pulled the value from the temp table into the second form. Maybe not the most elegant, but it works.
12 months ago
Nothing New Since Your Last Visit
158
Hits

Thread 13 of 25
Thread Starter  

Ash.B2
Form won't open
Inexperienced user here.  Self-taught, and smart enough to know that I don't know much. Paradox 10 running on Windows 10 I spent weeks developing a paradox form and application for a project I'm doing, then the form simply stopped loading. So I did it all again, spending weeks again. Then it stopped loading again. I can open all other forms in the same project, all tables, and all datamodels.  The form in question worked fine when I had it open last, designing and testing it.  Now it won't load.  All I get is the timer circle spinning, and it won't stop until I go to Task Manager and shut Paradox down.  No error message at all.
12 months ago
15 replies. Last post:

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

Thread 12 of 25
Thread Starter  

rum
Forms Event Model Confusion
I have never found just the right combination of events for the following situation. In the following argument..... "C:\Program Files (x86)\Paradox\Programs\pdxwin32.exe" -c -q -pE:\OutsourceWork\V11\priv -wE:\OutsourceWork\V11 _stub.fsl Paradox will launch and display the _stub.fsl   form (no problem) When the form opens I want specific code to run AFTER the form is fully displayed. Two question 1.  How do I WAIT until the form is fully displayed 2. What event should I put the code in? My current problem is that there are 5-10 function calls that take place, each displaying results in a list on the screen.  And regardless of how many SLEEP() I put in the thing it will not display the form until about  halfway through the code execution. Sometimes only flickering onto the screen briefly before closing. Many thanks!
14 months ago
5 replies. Last post:

Steven.G
geez, that was a long-shot.. no wonder it took so long to figure it out.. wow !!
14 months ago
Nothing New Since Your Last Visit
172
Hits

Thread 11 of 25
Thread Starter  

PS_1600
Set Range/Pattern Match
I am working with a PDX8 program which uses Wahl2Wahl's table lookups which work very well. The table lookups do not function correctly on PDX10, the up/down arrows and tab do not work. I am trying to create something similar and combining  set range and locate pattern. I can get either to work but not together. Is there a way to code in such a way that the setRange is the default but the user can also type .. to enable the locate pattern logic? method keyPhysical(var eventInfo KeyEvent), , Var,   s  string, endVar,     doDefault,  ,      s = self.value,      ,      ;PART.setRange( self.value, self.value+"zzz" ),    ,       ignoreCaseInStringCompares(yes),       advancedWildcardsInLocate(Yes) ,       PART.locatePattern("DESC",s),   , endmethod Thanks. Steve
18 months ago
19 replies. Last post:

Jeff.R3
I will take a stab at it, Unfortunately,I am on vacation this week. , send a a few sample records, as well as a rough count on how many records you will be searching. I will use that info to create something. Keep in mind, I have never done this, I only presume that I can do it, AND since I have a similar issue will give it a shot. , Jeff
18 months ago
Nothing New Since Your Last Visit
438
Hits

Thread 10 of 25
Thread Starter  

lja
using alias to oracle, datamodel gives error
{Too Long!}
12 years ago
10 replies. Last post:

John.O2
{Too Long!}
21 months ago
Nothing New Since Your Last Visit
6241
Hits

Thread 9 of 25
Thread Starter  

GaryG
Navigation buttons disabled
I recently upgraded from Paradox 7 to Paradox 11.0.0.676. On one of the forms, the navigation buttons are disabled, yet I am able to scroll through the records using the wheel mouse. Any ideas on what may cause the navigation buttons to be disabled? P.S. I am new to Paradox. Thanks, Gary
23 months ago
3 replies. Last post:

Steven.G
interesting.. two unrelated processes the last full version of paradox was v9 in 2000.. v10 in 2002 had a few minor additions.. v11 is v10 with the service packs added, and hasn't changed in 15 years
23 months ago
Nothing New Since Your Last Visit
384
Hits

Thread 8 of 25
Thread Starter  

vinylsol
Unknown internal operating system error
I cut and paste images into an image field on a Paradox form and I've been doing this with no problems for years; yesterday I got a message saying 'Unknown internal operating system error' with a reference to the .MB file, when I tried to paste an image in. Paradox hung. After restarting, I verified and rebuilt the table and it imported the image ok but when I tried to do it with a new record the same thing happened. I'm using Paradox 10.0.0.663 running on a Lenovo laptop with Vista Home Premium and Service Pack 2. The database has 121,900 records in it but not all of them have images. Does anyone know what might be causing this? Any help would be appreciated, thanks.,
10 years ago
38 replies. Last post:

philiptdotcom
Thanks!  I've used ChimneySweep before (probably have a license for it!), but I'd forgotten about it.  Thanks for the heads-up/reminder!  I'll check it out.  (As I recall, it was very useful in fixing things that the built-in "fixer" couldn't fix.  I'll try to dig it up & see what it can do with these memo fields!) Thanks again! Aloha, -pt
25 months ago
Nothing New Since Your Last Visit
15619
Hits

Thread 7 of 25
Thread Starter  

Kathy D
Forms - Cursor Position Changed
Currently using Paradox 11.0.0.663 - Have an existing input form and have experienced a change this week for one user in the way the cursor is positioned when pressing F2 edit.  For all other users when F2 is pressed the cursor positions itself at the beginning of the field.  For this user upon pressing F2 the cursor is positioned at the end of the field.  I have been unable to find a solution to return the cursor to it's normal position (at beginning of field) upon edit.  I am sure it was a sequence of key strokes hit.  Closing out Paradox does not return cursor to correct position.
9 years ago
Nothing New Since Your Last Visit
2329
Hits

Thread 6 of 25
Thread Starter  

Concordia
EDatabaseError in module +++++.exe at 00054b36....
I have been searching for a correction for this problem. Pls help, Here is the problem, "Exception EDatabaseError in module +++++.exe at 00054B36 Table +++++.db has no index for fields..." then is list all the fields in the table., Im not good at this program, nor did I create it, please help. Tony @ Concordia
18 years ago
Nothing New Since Your Last Visit
5856
Hits

Thread 5 of 25
Thread Starter  

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
31 months ago
10 replies. Last post:

Jeff.R3
Your situation will be different than mine,  On my form,  I have a parent child situation,  and it is the PARENT i am concerned with.   So  I haven't gone any deeper.
31 months ago
Nothing New Since Your Last Visit
823
Hits

Thread 4 of 25
Thread Starter  

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

Thread 3 of 25
Thread Starter  

Dyskdata
Paradox reports, ole container
Can anyone help me I am new to paradox and need to add a tif file to a Paradox report and be able to change it at runtime. I thought of an OLE container but I can't find a way to change it on the fly through code. Any suggestions?
19 years ago
Nothing New Since Your Last Visit
1909
Hits

Thread 2 of 25
Thread Starter  

philiptdotcom
howto display on form if rec exists in child table
{Too Long!}
33 months ago
4 replies. Last post:

Steven.G
in many situations, an empty table can cause an error when you try to address it's field values, especially if you're in View mode and there isn't actually a record there.. it's more obvious when you scan an empty or filtered table
33 months ago
Nothing New Since Your Last Visit
870
Hits

Thread 1 of 25
Thread Starter  

Marv
Splash screen shows then Pdox dies
We've got an intermittent problem when launching Paradox9. The splash screen will show briefly and then go away completely. Any clue? We haven't installed any of the service packs but are pursuing that angle. We're on a WAN & this has 'infected' some but not all sites & is obviously growing concern. Thanks for any hints., , Solberg.Marvin@pbgc.gov
16 years ago
Nothing New Since Your Last Visit
2966
Hits

New Thread

Follow PrestwoodBoards on: 


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