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

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

   ► MB LobbyCorel Paradox / ObjectPAL Coding Board   Print This     

ObjectPAL Topic

Programming in Paradox / ObjectPAL.
 Show:
New Activity New Threads Oldest Unanswered Most Active Most Read
  


25 Threads:

Add New ThreadRandom Thread

Thread 25 of 25
Thread Starter  

Sam.S
Shared Printers for Paradox 7
{Too Long!}
11 years ago
Nothing New Since Your Last Visit
2556
Hits

Thread 24 of 25
Thread Starter  

SteveM
Change Date Format to 4-digit Years?
We have almost completed our port from Windows 7 and Paradox 8 to Windows 10 and Paradox 11.  I am down to the last few bugs.  One is that all my date queries suddenly produce no results.  It turns out this is because I had been using 4-digit years, and now only 2-digit years seem to work in queries althought years are displayed as 4-digit in the queried table.  Weird. Anyhow, I suppose I could reprogram all date queries as 2-digit years, but this seem like bad practice.  And hard. So, I wondered if there is anywhere that I can easily reset the date format back to 4-digit years?  I already tried the Windows 10 short format, but it was already set to 4-digit years.  Any other ideas? Thanks! Steve
63 days ago
7 replies. Last post:

Steven.G
biggest issue, if you change, is sort orders.. first thing you have to do is re-index everything, or you're gonna get errors every time it tries to touch an index other issue, is to actually compare the base 256 character sets, to see if there's anything different, and if that matters in your universe
63 days ago
Nothing New Since Your Last Visit
61
Hits

Thread 23 of 25
Thread Starter  

SteveM
Paradox 11 SP3?
I have Paradox 11.0.0.676 and thought some of my woes might be fixed with the lates service pack.  I contacted Corel tech support and they said... to contact you!  You are probably either flattered or annoyed, or prehaps both.  Anyhow, is this service pack available anywhere?  Corel had Service Pack 3 for WordPerfect x7 Pro, which I bought, but it does not include the Paradox service pack with it. Thanks!
63 days ago
3 replies. Last post:

Steven.G
post specific issues, separately, maybe we can offer solutions
63 days ago
Nothing New Since Your Last Visit
52
Hits

Thread 22 of 25
Thread Starter  

SteveM
Running Paradox 8 and Paradox 11 Concurrently?
We are migrating an application from Paradox 8 to Paradox 11 to run on Windows 10. Some things broke, and still need to be fixed.  Since I haven't written any ObjectPAL code in 20 years this isn't as easy as I had hoped.  We are about 90% functional in Paradox 11, but as we chip away at the other 10% I wonder if it is possible to safely run 8 and 11 simultaneously, meaning to pointing at the same tables at the same time? It appears that anything compiled is version-specific, so we can simply use the uncompiled files until migration is complete, except for a couple of parallel libraries that will need to exist.  If this works we will be able to continue to support the mission-critical pieces on Paradox 8 that are still not working on 11.  My big fear is corrupting the data somehow. I appreciate your thoughts! Steve
87 days ago
2 replies. Last post:

Steve.M5
Thanks!  We'll give it a try.  It is really just for backup in case we are struggling to get something working on 11, we can use 8 in a pinch as we port over.
85 days ago
Nothing New Since Your Last Visit
39
Hits

Thread 21 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.
5 months ago
4 replies. Last post:

Steven.G
just an FYI on your "Corel should update" comment in your code.. ain't gonna happen, for many reasons.. paradox 11 is paradox 11.. that's the canvas we have to work with
85 days ago
Nothing New Since Your Last Visit
96
Hits

Thread 20 of 25
Thread Starter  

PeteD
Does Paradox have macro substitution?
I need to use the contents of a parameter to pull a field's contents. Visual FoxPro uses the & character for that sort of thing. Is there a Paradox equivalent? Edit: Fount it - it's called dereferencing, eg  sField = "Name"   ;Assign a field name to the variable., view(tcCustomer.(sField));Dereference the variable using parentheses. from:  https://www.prestwoodboards.com/ASPSuite/KB/Document_View.asp?QID=101169
53 months ago
Nothing New Since Your Last Visit
934
Hits

Thread 19 of 25
Thread Starter  

gwatchmaker
Database not open on executeqbe
{Too Long!}
101 days ago
2 replies. Last post:

Steven.G
{Too Long!}
99 days ago
Nothing New Since Your Last Visit
71
Hits

Thread 18 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
115 days ago
3 replies. Last post:

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

Thread 17 of 25
Thread Starter  

Sam.S
Accessing an FTP with filesystem in ObjectPal
{Too Long!}
48 months ago
Nothing New Since Your Last Visit
2231
Hits

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

Thread 15 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!
20 years ago
Nothing New Since Your Last Visit
1871
Hits

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

Thread 13 of 25
Thread Starter  

The Big Jerm
Opening a Tcursor on Saddam
Var , tc tcursor, sadam butthead, endvar, , tc.open(":buttheads:sadam"), scan tc:
18 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.
9 months ago
Nothing New Since Your Last Visit
2051
Hits

Thread 12 of 25
Thread Starter  

rajab_ali_moham
paradox 11 or 12 standalone
Hi...., how we can optain pdox11 or pdox12 stanalone, is it a good decision upgrate pdox7 to pdox11 or pdox12?, any help...., t...u..... in advance
17 years ago
Nothing New Since Your Last Visit
1572
Hits

Thread 11 of 25
Thread Starter  

SamSpade
trouble using SendDLG() on 2016 RDS svr W/ Outlook
I am starting up a new 2016 RDS server to replace a 2008 R2 Terminal server running a Paradox 11 App. I am having trouble using the M.SendDLG() command, which runs fine on The 2008R2 server. I get a windows error about the default email client and to open Outlook and set it as default I have opened outlook and set it as default I have also set it in control panel default programs and through settings default programs Both servers are running Outlook, the 2016 server where the problem is occuring is running Outlook 2019. There is also a Paradox errormessage that simply says "Main".  I think thats the errorShow for the M.SendDLG() Anyone else run into this?
17 months ago
13 replies. Last post:

Steven.G
we've already switched to an alternative like this, for one process that needs html, as an attachment, with a submit button, in a big batch to our vendors.. everything that email security hates, in one process :-) the only conceptual problem with the alternative, but it didn't matter in this particular situation, is that the alternative can't stuff the "sent" box
14 months ago
Nothing New Since Your Last Visit
308
Hits

Thread 10 of 25
Thread Starter  

SamSpade
DLL problem Importing XLS in Paradox 11 RT
I am running into a DLL problem (I think) when trying to import an old .XLS format spread sheet The same code (importSpreadsheet()) imports the same spreadsheet in my developer pdxwin32.exe But when I go to run it in the production machine in runtime PdxRwn32.exe, I get an error At first, I got an error about a missing DLL (PFit110EN.dll)  I tracted down the DLL in the Programfiles\Paradox\Programs of my developer machine and put it into Programfiles\runtime\Programs\ of the production machine Now I am getting an error about unable to read headers when I use an importSpreadsheet()  I also tracked down a PFit110.DLL that had a newer date (3/7/2003 vs 2/25/2003) and tried that on the production machine, but it didn't help. Has anyone else run into this and found a solution?
14 months ago
1 Reply:

Steven.G
hadn't heard of that one before, that I can recall.. did you try a re-install of runtime, just to be sure? you can check the bug list, too http://hem.bredband.net/bertilisberg/
14 months ago
Nothing New Since Your Last Visit
104
Hits

Thread 9 of 25
Thread Starter  

csgPdx
How to get all files on a drive
I am sure that at one time I had a script or form that would give me a listing of all the files in a directory, including subdirectories. (Perhaps it was just on my todo list.) It would, of course, have involved enumFileList and recursive routines. I would appreciate if anyone might point me to such a utility. I am not finding what I need otherwise out on the internet. Thanks, NK
16 months ago
2 replies. Last post:

Stan.D
The enum can loop down through the system. I use shellExecute and do a dir > list.txt. geometry dash full game
16 months ago
Nothing New Since Your Last Visit
214
Hits

Thread 8 of 25
Thread Starter  

rum
OPAL to DISPLAY QB Tool
hello,   This must be an oversight(or Alzhiemers) on my part. How do I open a query using ObjectPAL  and display it in the query editor so that I can modify? For a table I do the following var,    t string, endvar t = editTableList ; (THIS IS A NAME FROM LIST OF TABLE NAMES) dlgRestructure (t)
20 months ago
6 replies. Last post:

Jeff.R3
Thanks Jay,  but you misunderstood the question.  I dont need the text,  I need the designer to open and display for a query that was pre-designed and saved. In OPAL, var Q Query endvar q.readfromfile("c:\\temp\\somequery.qbe") ; now, i want q.displaydesigner() or q.restructure(), or menuaction.newquery(q) or any other of things I haven't found thanks, Jeff
20 months ago
Nothing New Since Your Last Visit
227
Hits

Thread 7 of 25
Thread Starter  

Klepsis
formatted memo question
I have a form field which I would like to use to modify a formatted memo table field without giving the user direct access to the underlying table.  I can get the table field to display in the form field, but when I try to update it the formatting doesn't seem to work.  (tab and enter keys take me out of the form field).  I have tried both undefined and defined field creation and the only difference is that I have to press F9 when entering text into the defined field version.  How do I enter formatted text into this field?
21 months ago
7 replies. Last post:

Eugene.W
OK.  The Shift F2 makes it work like I thought it should.  I'm sure that that is somewhere in the reference manual and I've been glossing over it.  I'll need to include a text reminder on the screen above the field in order to have the users update the field properly, :-)  but that's no biggie.  Thanks for the help.  
21 months ago
Nothing New Since Your Last Visit
214
Hits

Thread 6 of 25
Thread Starter  

afhynes2
ObjectPal msgQuestion
I have not done any script writing for many years and my memory isn't what it used to be. In one of my scripts I have a msgQuestion that brings up a dialogue box. The default answer in the box is "Yes". Can I change it to "No" because that is the prevailing answer. Rarely do I need to select "Yes"
22 months ago
2 replies. Last post:

jochen.h
Why don;t you just change the text of the msgQuestion so that the defaulty answer is Yes ???
22 months ago
Nothing New Since Your Last Visit
247
Hits

Thread 5 of 25
Thread Starter  

Cottage Builder
Passing a variable in an export process
HI folks, I have the following code with a form;             exportASCIIVar(":RSA:Mailing Emails.db",":RSA:Reports\\Temporary Mail List.csv", "\t","\"",False,True), ,             MsgInfo("Well Done","The E Mail List for "+s+" has been updated.") S has been populated before this point, but I would like to replace "Temporary Mail List.csv" with a file name made up of the value of s, plus ".csv" Does anyone have any suggestion?
22 months ago
1 Reply:

Steven.G
s = ":RSA:Reports\\Temporary Mail List.csv" exportASCIIVar(":RSA:Mailing Emails.db",s, "\t","\"",False,True) if that's not what you meant, you'll have to explain differently
22 months ago
Nothing New Since Your Last Visit
181
Hits

Thread 4 of 25
Thread Starter  

ForestCat
Export All Custom ObjectPal Code?
Hi, It's probably asking a lot, but is there some way to get a nicely formated (indented) document  listing all the ObjectPAL attached to a form?  Thanks for reading
24 months ago
2 replies. Last post:

Neil.N
 Thank you, Steven, that's awesome.  Of course I feel stupid that the capability is built in to the language itself and I didn't find it.  I was looking for it in the ui, but alas, it was burried in the 1000+ pages of paper manuals I got (and still have) w/ Borland Paradox For Windows in '93.  Ah those were the days ;-)
24 months ago
Nothing New Since Your Last Visit
339
Hits

Thread 3 of 25
Thread Starter  

Andrew.G
Adding Breakpoint causes Paradox to close
{Too Long!}
26 months ago
6 replies. Last post:

Steven.G
something to avoid? nothing that we know of.. computers aren't perfect.. stuff happens copy/paste? yes, that's what I've done.. I had to re-create a very complex form last year, for a client.. one piece at a time, test it, move on.. never found a specific piece that would fail.. eventually, it was all done, and I could finally make changes that they'd needed for several years
26 months ago
Nothing New Since Your Last Visit
462
Hits

Thread 2 of 25
Thread Starter  

PS_291
LSL Dependency Problem - Pdox7 to Pdox11 Upgrade
{Too Long!}
43 months ago
9 replies. Last post:

John.O2
Cheers! If only the port away from pdox could go a easily, but hey- I'll take Win 10/Server 2019 compatibility in the meantime!
26 months ago
Nothing New Since Your Last Visit
1117
Hits

Thread 1 of 25
Thread Starter  

Lothar.K
ObjectPAL version incompatable...?
Howdy, I run Paradox 9, under Win 10. I made a minor edit to a particular report. Let's call it Report1. Typically, I print that report using code that is on the doubleclick of a field on an MRO on a form called Form1. Now, when I launch Form1, and doubleclick on the appropriate field in the MRO, I get the error: "The objectPAL version used in this form is incompatible with this version of Paradox. You must recompile from source." So, I opened the form in Edit mode, viewed the code on the field's doubleclick, saved it, and delivered it. Next, I did just that for Report1. I relaunched Paradox, and also rebooted the system, but still get the error. In addition, I can launch the report, and can print it manually, with no problem. How can I correct this error when trying to use the code to do the printing from Form1? Sincere thanks, Lothar
26 months ago
2 replies. Last post:

Lothar.K
Hi Steven, I thank you for your suggestion and did try it. While experimenting, I stepped through the code, and found something odd, that allowed me to tweak it. With that, all worked well. So though I had success, I confounded the experiment, and I don't know which of the tweaks corrected things. In any case, as before, sincere thanks, Lothar
26 months ago
Nothing New Since Your Last Visit
457
Hits

New Thread

Follow PrestwoodBoards on: 


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