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

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

   ► MB LobbyCorel Paradox / ObjectPAL Coding Board   Print This    All Groups  

Corel Paradox / ObjectPAL Coding New Activity

Switch to:  New Posts (ALL TYPES)
  


25 Threads:


Thread 25 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)
Posted to MB Topic: ObjectPAL
78 hours 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
53 hours ago
New Stuff Since Your Last Visit
22
Hits

Thread 24 of 25
Thread Starter  

Martin.T2
.lck file issues
{Too Long!}
Posted to MB Topic: Paradox Setup, Vista, etc.
9 days ago
8 replies. Last post:

Martin.T2
{Too Long!}
6 days ago
Nothing New Since Your Last Visit
54
Hits

Thread 23 of 25
Thread Starter  

rum
Private Path
Does anyone know if DURING the install of Paradox (v11),  whether any paths are saved in some hidden/buried config file? This is the issue.  I have a user (Win 10,  PDOX 11) whose software is not acting normally.  while instigating I decided to run table repair.  However,  when table repair launches it throws an error regarding the ERRORS.DB table in the blahblah\pdxpriv folder.  Only the path it is barfing up is not the the private folder that is set/configured in paradox.   Wondering where it is finding this erroneous path. Thanks jeff
Posted to MB Topic: Paradox Setup, Vista, etc.
25 days ago
1 Reply:

Steven.G
depending on how you install and how you configure the bde, there can be any number of entries in the registry.. with p11, there are also the potential conflicts of not clearing that stupid reg cleaner thing from the machine and the registry.. what you see is NOT always what you get
25 days ago
Nothing New Since Your Last Visit
20
Hits

Thread 22 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?
Posted to MB Topic: ObjectPAL
30 days 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.  
29 days ago
Nothing New Since Your Last Visit
33
Hits

Thread 21 of 25
Thread Starter  

PS_2069
Paradox 9 not working after Win 10 upgrade
I need help.  All of my Paradox 9 runtime users are getting the following error message after I upgraded 3 workstations to Windows 10.  Not all workstations have been upgraded but now they all receive the following error message when attempting to login to Paradox... An error was triggered in the 'qlocate' method on an object of TCursor type....TCursor not opened.  Our server is Windows 2012 Any help is appreciated.
Posted to MB Topic: Paradox Setup, Vista, etc.
53 days ago
27 replies. Last post:

Steven.G
F:\IDAPI\BDE\idapi.cfg that way, they're all pointing to one file.. if you change anything, you only change it once in THAT file, make sure it says the net file is in that same folder, too
30 days ago
Nothing New Since Your Last Visit
142
Hits

Thread 20 of 25
Thread Starter  

LC.M
Printing with Office 365
Upgraded to Office 365 & got the LCAppPrint Initialized Failed error.  Installed the Hotfix Runtime patch after un/reinstalling Paradox 11.  Now, when i try to print, the program closes.    Any ideas are welcomed.  (Using Paradox for single user database & reports.)
Posted to MB Topic: Paradox Reports
33 days ago
3 replies. Last post:

Steven.G
external connectivity issues (printing, MAPI email, etc) can change with the versions.. p11 is the same, but the suite is different, , also, if you're using full paradox, a runtime patch isn't related to using that
33 days ago
Nothing New Since Your Last Visit
42
Hits

Thread 19 of 25
Thread Starter  

Jochen
Paradox 10 "invalid alias"
When I try to export a database, ( File | Export ) I am getting a cryptic "invalid alias" message in the message bar. No further info. I must have screwed up my settings somewhere and cannot find what alias it is referring to. My :priv: and :work: aliases are working fine.
Posted to MB Topic: Paradox Setup, Vista, etc.
52 days ago
11 replies. Last post:

Steven.G
Cottage.. there is only one active cfg file at a time.. unless you're actually deploying multiple configurations, depending on which client/app you're working on, having more than one can create oppotunities for confusion the first two, the "bars" configs, are for the toolbars.. yes, if they get hosed, they can be deleted
48 days ago
Nothing New Since Your Last Visit
71
Hits

Thread 18 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"
Posted to MB Topic: ObjectPAL
54 days 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 ???
52 days ago
Nothing New Since Your Last Visit
31
Hits

Thread 17 of 25
Thread Starter  

tmitchell
Using Corel Web Server
Mike's Paradox book has an excellent section in the back on using web servers with Object Pal. Is there more info out there that can explain how to use .HTT files in more detail, possibly more examples?
Posted to MB Topic: Paradox Web Stuff
19 years ago
5 replies. Last post:

Jeff.R3
Does your pc have a firewall or anti-virus app blocking your IP,  PORT or Webservice?
60 days ago
Nothing New Since Your Last Visit
4183
Hits

Thread 16 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?
Posted to MB Topic: ObjectPAL
64 days 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
61 days ago
Nothing New Since Your Last Visit
47
Hits

Thread 15 of 25
Thread Starter  

gcorvera
Paradox on Windows Server 2012
We migrated from using a run of the mill Windows XP box as a server to Windows Server 2012; one of the applications we use is a simple 3 table database which stopped working the moment the files were being accessed from the new server. We could see data but trying to add anything would result in a Lock Time Out error. I discovered that if I remove Referential Integrity from the detail table structure, and just assign it through the data model on the form, everything works. Would it be OK to leave it like that? or would it be somehow dangerous for the integrity of the data? Could the problem have come from some setting on the server? The person who installed the server for us doesn't think so but I'm not sure he is as familiar with Windows 2012 Server as I thought. For the time being I will be monitoring the data and checking that nothing is lost. Any suggestions? Thanks
Posted to MB Topic: Paradox Setup, Vista, etc.
5 years ago
11 replies. Last post:

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

Thread 14 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
Posted to MB Topic: Paradox Forms
96 days 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
87 days ago
Nothing New Since Your Last Visit
211
Hits

Thread 13 of 25
Thread Starter  

KBNV
Fonts in Win10 v1809
I just set up Paradox on a new system running the latest ver of Win 10 (1809).  My reports on the new system required a complete revision of the fonts used in the report.  I've been using the same ones for years and the fonts have always migrated to the new system.  This time, however, the fonts are not available in the properties, font drop down for any of the fields in my report.  The fonts are installed in the usual place and are available to the other myriad programs.  I installed Paradox from an X9 disc which I know doesn't make a difference.  I even uninstalled Paradox from the system and reinstalled using the X8 disc in the hope that it would make a difference.  It, of course, did not.  I am using other fonts that provide a similar impact.  But, not the same. Any body have any suggestions? Thanks in advance. Karen
Posted to MB Topic: Paradox Reports
114 days ago
1 Reply:

Steven.G
so.. the font isn't seen by paradox, but is seen by everything else ordinary font? unusual font? is anything else from the WP Suite installed? same issue?
114 days ago
Nothing New Since Your Last Visit
101
Hits

Thread 12 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
Posted to MB Topic: ObjectPAL
4 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 ;-)
4 months ago
Nothing New Since Your Last Visit
125
Hits

Thread 11 of 25
Thread Starter  

PS_1789
Printing in Windows10
{Too Long!}
Posted to MB Topic: Paradox Setup, Vista, etc.
4 months ago
11 replies. Last post:

Steven.G
file/open the library program/compile file/save simple, and nothing will change.. but.. if the forms scripts and reports are all delivered (fdl not fsl, rdl not rsl, etc), you have to recompile EVERYTHING
4 months ago
Nothing New Since Your Last Visit
245
Hits

Thread 10 of 25
Thread Starter  

PS_291
PDOX11 over MSSQL (ODBC) - Schema in Table Names
Might anyone here know a way to configure ODBC/SQLEXPRESS under the BDE to return table names without a schema prefix (i.e., tablename rather than dbo.tablename)? Should I be looking at a different SQL DB?  Ideally, I’d like to point the alias that currently references the main paradox database to one referencing tables ported to sql and look at what needs fixing from there.  Thanks to a tool created and shared on codeproject by one of the forum members (thanks Igor!), database conversion to SQLEXPRESS went surprisingly easily, with only a few minor field type changes needed across hundreds of tables. I’m connecting to the SQL db fine from paradox via odbc. That said, I’ll consider a different back end (Firebird? PostgreSQL?) if it means the Paradox app will require fewer changes; I’m dealing with many forms and lots of code and porting the back end is a step toward a full conversion away from Paradox. Thanks! John
6 months ago
10 replies. Last post:

Steven.G
> The real surprise has been just how much has worked without major re-factoring < that is VERY cool
4 months ago
Nothing New Since Your Last Visit
309
Hits

Thread 9 of 25
Thread Starter  

GreatDivideIT
Could not initialize DBE - shared domain computer
{Too Long!}
Posted to MB Topic: Paradox Setup, Vista, etc.
5 months ago
1 Reply:

Steven.G
many possibilities, but most likely this profile is not accessing the shared files correctly, or the config in the BDE isn't the same
5 months ago
Nothing New Since Your Last Visit
151
Hits

Thread 8 of 25
Thread Starter  

coconut73
2003 server to 2016 server lock time out / slow
{Too Long!}
Posted to MB Topic: Paradox Setup, Vista, etc.
6 months ago
5 replies. Last post:

Jeff.R3
6 months ago
Nothing New Since Your Last Visit
212
Hits

Thread 7 of 25
Thread Starter  

Andrew.G
Adding Breakpoint causes Paradox to close
{Too Long!}
Posted to MB Topic: ObjectPAL
6 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
6 months ago
Nothing New Since Your Last Visit
229
Hits

Thread 6 of 25
Thread Starter  

lja
using alias to oracle, datamodel gives error
{Too Long!}
Posted to MB Topic: Paradox Forms
11 years ago
10 replies. Last post:

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

Thread 5 of 25
Thread Starter  

rum
Table Corruption
{Too Long!}
Posted to MB Topic: Paradox Tables
6 months ago
4 replies. Last post:

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

Thread 4 of 25
Thread Starter  

PS_291
LSL Dependency Problem - Pdox7 to Pdox11 Upgrade
{Too Long!}
Posted to MB Topic: ObjectPAL
23 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!
6 months ago
Nothing New Since Your Last Visit
918
Hits

Thread 3 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
Posted to MB Topic: ObjectPAL
6 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
6 months ago
Nothing New Since Your Last Visit
179
Hits

Thread 2 of 25
Thread Starter  

GreatDivideIT
data threshold on reports?
My client closed a large amount of jobs in November and cannot generate reports. The error is '#Record_band is too big'. They are able to use the same report but for a different time period. For example, reports from Jan thru July work. Is there a setting we can change that will accommodate a larger dataset?  Thanks! Tim Albertson, Great Divide IT Consulting LLC, 2995 Skyline Blvd., Suite # 208, Reno, NV 89509, tim@greatdivideit.com, 775-229-4415 (direct), 775-636-5047 (mobile), 775-229-4398 (fax), www.greatdivideit.com
Posted to MB Topic: Paradox Reports
7 months ago
6 replies. Last post:

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

Thread 1 of 25
Thread Starter  

leochaim
Paradox V8.0 on Windows 10 after Creators Update.
Does not start any more (PDXWIN32.exe). Only see a fast Flash of Paradox Initial Screen. Uninstalled and Instaled again, but still does not start. Other apps from the Corel WordPerfect Package. start Ok , On another PC with Paradox 10 it works ok after the Creators Update., Has anybody this problem?
Posted to MB Topic: Paradox Setup, Vista, etc.
27 months ago
50 replies. Last post:

Steve.M5
{Too Long!}
6 months ago
Nothing New Since Your Last Visit
9199
Hits
Follow PrestwoodBoards on: 


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