Paradox Coding Message Board (Q&A). Free help! Answer questions. Part of our Paradox Group. Corel Paradox for Windows and ObjectPAL group (was Borland Paradox). Covering all versions of Paradox for Dos, Paradox for Windows, and Paradox for Linux including help with the BDE and Paradox tables.
To start a new thread, choose a topic, then click [New Thread].
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.
Please ignore. I ended up solving it after adding the advancedWildcardsInLocate(Yes), and then changing from locatePattern() to simply locate(). I probably made the change prior for some reason haha.
Grant
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
Back after yeeaars in the wilderness. I've tried this again and get the same result. I can print a report if I do it through and objectPAL script. Load the report and print. But if I just open the report, I get the same result and Paradox closes.
Also, I can't print things like info structure. Paradox just falls over.
> ":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
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.
Help!!! I am a new Paradox user and I am not a programmer or a techie. I've been working here for 6 months and have been able to figure out how to create basic forms and reports but I'm trying to find training or manuals that will get me to the next level. Any suggestions? Thanks.
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?
> ":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
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
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
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?
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.
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.
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!
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
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.
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
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.
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.
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
Paradox
Print This
Paradox Specific Topics
(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!
Unanswered: Paradox Message Board