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].
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
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?
if the path name is too long, doesn't matter which way you shorten it.. the printer name, you are best to actually be a shared printer, and shorten the network name
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
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.
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?
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?
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
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
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
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
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
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?
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
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 ;-)
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
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
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
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
Paradox
Print This
Paradox Specific Topics
Unanswered: Paradox Message Board