Paradox Forms Topic

Including form usage, form coding issues, calculated fields, and the data model. |
|
|
Thread 25 of 25 | Thread Starter | | |  GaryG | printerSetCurrent causing Paradox to hangA 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
|
 202 Hits | |
Thread 24 of 25 | Thread Starter | | |  GaryG | printerSetCurrent causing Paradox to hangA 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
|
 274 Hits | |
Thread 23 of 25 | Thread Starter | | |  Rabih.C | Customer-retail display screen communicationHi.
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
2 replies. Last post: |  nam.d | Digital signage is an efficient communication channel for keeping retail customers updated. car games
|
|
 2984 Hits | |
Thread 22 of 25 | Thread Starter | | |  EnigmaVariation | Paradox 9 : qbe with tilde variable does not run{Too Long!} |
 299 Hits | |
Thread 21 of 25 | Thread Starter | | |  EnigmaVariation | Form synchronization{Too Long!} 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
|
|
 644 Hits | |
Thread 20 of 25 | Thread Starter | | |  rum | Table Frame controlAnyone know how to programatically show/hide columns in a table frame control? Mind you, I am not talking about the tableview object.
Thanks!!!
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
|
|
 492 Hits | |
Thread 19 of 25 | Thread Starter | | |  PS_3060 | Adding a Graphic to a tableHi,
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
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
|
|
 318 Hits | |
Thread 18 of 25 | Thread Starter | | |  EnigmaVariation | Error Msg : error occured when setting ..proerty{Too Long!} 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?
|
|
 504 Hits | |
Thread 17 of 25 | Thread Starter | | |  Sam.S | Auto email send from memo fieldsI 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
|
 5655 Hits | |
Thread 16 of 25 | Thread Starter | | |  PS_3060 | Setting Upper Case in a search fieldI 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 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
|
|
 499 Hits | |
Thread 15 of 25 | Thread Starter | | |  Pete.D2 | Editing on a form without keying F9Is 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.
|
 1462 Hits | |
Thread 14 of 25 | Thread Starter | | |  GaryG | Print form without user interactionI 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
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
|
|
 386 Hits | |
Thread 13 of 25 | Thread Starter | | |  Ash.B2 | Hiding the desktopI 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.
|
 577 Hits | |
Thread 12 of 25 | Thread Starter | | |  GaryG | printerSetCurrent is hangingOur 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 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.
|
|
 684 Hits | |
Thread 11 of 25 | Thread Starter | | |  juan@pcexperts.com | HowTo: Search for records not in another tableI 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 |
 3116 Hits | |
Thread 10 of 25 | Thread Starter | | |  PS_2762 | Opening A FormI 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.
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
|
|
 498 Hits | |
Thread 9 of 25 | Thread Starter | | |  rum | Order of Events{Too Long!} |
 321 Hits | |
Thread 8 of 25 | Thread Starter | | |  Ash.B2 | Populating drop down from a table{Too Long!} 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
|
|
 903 Hits | |
Thread 7 of 25 | Thread Starter | | |  PS_1093 | Error occurred while reading graphic fileHi 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
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
|
|
 331 Hits | |
Thread 6 of 25 | Thread Starter | | |  JFWconsult | Implementing a Reusable Progress Bar in ParadoxMike,
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.
8 replies. Last post: |  Steven.G | it comes back.. it's possessed :-)
|
|
 1544 Hits | |
Thread 5 of 25 | Thread Starter | | |  Ash.B2 | Bringing the Active record to a new form{Too Long!} 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.
|
|
 588 Hits | |
Thread 4 of 25 | Thread Starter | | |  Ash.B2 | Form won't openInexperienced 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.
15 replies. Last post: |  Steven.G | {Too Long!} |
|
 836 Hits | |
Thread 3 of 25 | Thread Starter | | |  rum | Forms Event Model ConfusionI 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!
5 replies. Last post: |  Steven.G | geez, that was a long-shot.. no wonder it took so long to figure it out.. wow !!
|
|
 521 Hits | |
Thread 2 of 25 | Thread Starter | | |  PS_1600 | Set Range/Pattern MatchI 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
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
|
|
 880 Hits | |
Thread 1 of 25 | Thread Starter | | |  lja | using alias to oracle, datamodel gives error{Too Long!} 10 replies. Last post: |  John.O2 | {Too Long!} |
|
 6688 Hits | |
 |
|
|