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  

GaryG
printerSetCurrent causing Paradox to hang
A couple of months ago we have started having issues with printerSetCurrent causing Paradox to hang. When this happens I have been telling my user base to reboot and then try again. Printing works for awhile, then it will hang up again. Has anyone else run into this? Do you have any suggestions? Thanks, Gary
4/24/2024
Nothing New Since Your Last Visit
447
Hits

Thread 24 of 25
Thread Starter  

GaryG
printerSetCurrent causing Paradox to hang
A couple of months ago we have started having issues with printerSetCurrent causing Paradox to hang. When this happens I have been telling my user base to reboot and then try again. Printing works for awhile, then it will hang up again. Has anyone else run into this? Do you have any suggestions? Thanks, Gary
4/24/2024
Nothing New Since Your Last Visit
707
Hits

Thread 23 of 25
Thread Starter  

Rabih.C
Customer-retail display screen communication
Hi. I wonder if anyone could help me write a code that allows control from Paradox onto the display screen that shows the price of the item entered throughyou. the bar code reader. Thank 
11/15/2014
2 replies. Last post:

nam.d
Digital signage is an efficient communication channel for keeping retail customers updated. car games
9/11/2023
Nothing New Since Your Last Visit
3317
Hits

Thread 22 of 25
Thread Starter  

EnigmaVariation
Paradox 9 : qbe with tilde variable does not run
{Too Long!}
3/16/2023
Nothing New Since Your Last Visit
608
Hits

Thread 21 of 25
Thread Starter  

EnigmaVariation
Form synchronization
{Too Long!}
2/1/2021
14 replies. Last post:

Steven.G
good to know.. thanks.. making your own "next number" process is a different way to look at your app, but it's very flexible.. and it doesn't break as easily as an AutoInc
2/18/2021
Nothing New Since Your Last Visit
969
Hits

Thread 20 of 25
Thread Starter  

rum
Table Frame control
Anyone know how to programatically show/hide columns in a table frame control?    Mind you,  I am not talking about the tableview object. Thanks!!!
12/29/2020
3 replies. Last post:

Steven.G
I haven't used it, that I'm aware of.. but flipping the colors on a column, or certain records like that, yes, I've done it, it's simple put it in New Value, then it applies to every record.. if this then color=red else color = white endif.. to hide a bigger area, you can have an empty box.. transparent normally, color on color to hide
12/29/2020
Nothing New Since Your Last Visit
738
Hits

Thread 19 of 25
Thread Starter  

PS_3060
Adding a Graphic to a table
Hi, I have a form where I would like to have a Graphic field displayed. The table has 2 fields 1 of which is the graphic field. I have tried to Paste the graphic into this field but nothing is saved. I use another table where graphics are saved and used on the same form with no problem. Is there a limitation on BMP size or any other specification which needs to be ahered to? Cheers Bill
12/3/2020
1 Reply:

Steven.G
2 gig, I think.. maybe 256 meg.. at the time, 2002, it didn't matter, it was an absurd number :-) in general, for MANY reasons, it is far better to use a text field, save the link to the real file, and use a "viewer" process to open whatever it may be.. excel will open an excel file, the windows viewer will open pics, etc
12/4/2020
Nothing New Since Your Last Visit
510
Hits

Thread 18 of 25
Thread Starter  

EnigmaVariation
Error Msg : error occured when setting ..proerty
{Too Long!}
11/12/2020
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/13/2020
Nothing New Since Your Last Visit
684
Hits

Thread 17 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
1/8/2012
Nothing New Since Your Last Visit
5855
Hits

Thread 16 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
10/4/2020
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
10/9/2020
Nothing New Since Your Last Visit
708
Hits

Thread 15 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.
7/11/2017
Nothing New Since Your Last Visit
1688
Hits

Thread 14 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
9/16/2020
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
9/18/2020
Nothing New Since Your Last Visit
572
Hits

Thread 13 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.
1/20/2020
Nothing New Since Your Last Visit
795
Hits

Thread 12 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
7/6/2020
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.
8/3/2020
Nothing New Since Your Last Visit
925
Hits

Thread 11 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
3/20/2001
Nothing New Since Your Last Visit
3322
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.
4/17/2020
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
4/20/2020
Nothing New Since Your Last Visit
723
Hits

Thread 9 of 25
Thread Starter  

rum
Order of Events
{Too Long!}
3/3/2020
Nothing New Since Your Last Visit
479
Hits

Thread 8 of 25
Thread Starter  

Ash.B2
Populating drop down from a table
{Too Long!}
1/23/2020
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
2/25/2020
Nothing New Since Your Last Visit
1158
Hits

Thread 7 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
2/1/2020
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
2/3/2020
Nothing New Since Your Last Visit
521
Hits

Thread 6 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.
6/28/2011
8 replies. Last post:

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

Thread 5 of 25
Thread Starter  

Ash.B2
Bringing the Active record to a new form
{Too Long!}
10/24/2019
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.
10/27/2019
Nothing New Since Your Last Visit
798
Hits

Thread 4 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.
10/21/2019
15 replies. Last post:

Steven.G
{Too Long!}
10/23/2019
Nothing New Since Your Last Visit
1070
Hits

Thread 3 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!
8/1/2019
5 replies. Last post:

Steven.G
geez, that was a long-shot.. no wonder it took so long to figure it out.. wow !!
8/2/2019
Nothing New Since Your Last Visit
691
Hits

Thread 2 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
4/16/2019
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
4/25/2019
Nothing New Since Your Last Visit
1136
Hits

Thread 1 of 25
Thread Starter  

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

John.O2
{Too Long!}
1/24/2019
Nothing New Since Your Last Visit
6889
Hits

New Thread
www.prestwood.com For service: 916-726-5675
or support@prestwood.com
Copyright (C) Prestwood IT Solutions.
All Rights Reserved.
Printed 1/16/2026