A. I. Breveleri Message Board Activity

{Too Long}

Posted to MB Topic: ObjectPAL « Paradox Board

I am currently using pdox8 and woulld like to know the best way to ompact a table after deletes. I tried tblvar.compact(), this retruned an error. What is the best way to do it?

Posted to MB Topic: ObjectPAL « Paradox Board

session.enumUsers() will tell you 'who is using the BDE' (with the same PDOXUSRS.NET root file as you), which is usually the same as 'who is using Paradox'., , -Al., ,

Posted to MB Topic: ObjectPAL « Paradox Board

You need to borrow or build a Win 95 system.  (Hint: don't connect it to the internet.)  Open your heart form on the Win 95 system, disable the code in all the Open() events, and save it.  Then try to open it on the Win NT system.  Keep disabling things until the form opens on both systems. Once it opens on Win NT, then you can investigate it in its new environment.  Try enabling each Open() event until the form hangs, etc. If it doesn't even open on Win 95, then consider how good life has been so far and how lucky you were to have enjoyed so much of it, and resolve that in your next life you will document your work as you do it. -Al.

Posted to MB Topic: Paradox Forms « Paradox Board

We are currently experiencing a problem with 16bit Paradox 7.  When I run a delete query (QBE) the query completes and we would assume that all the data that we want to remove has been removed. However, when we check the table we ran this query on only some of the data has been removed.  So we run the query again..  When we check the table more of the data has been removed but some is still left. We have to repeat this multiple times before all the data is gone.  Each time we repeat it we don't modify the query - its the same one we ran 1st time around. What could be causing this problem and how can we solve it? I would appreciate all advice offered regarding this question. Best Wishes John

Posted to MB Topic: QBE & SQL « Paradox Board

Post the QBE.  Try to cut and paste it -- don't retype it.  Also, describe the structures of the tables referenced by the QBE.  Include validity constraints and secondary indices. -Al.

Posted to MB Topic: QBE & SQL « Paradox Board

What happens if you open Paradox, do not open mainmenu.fsl, and try to run the export?  IOW does just having Paradox running prevent the export, or does Paradox need to have a table open? What platform does the export program run on, and what engine does it use to access pair.dbf?  Very few non-Borland engines know how to interact with the BDE locking aparatus -- they usually just grab an exclusive lock for any operation. If you just want to get something working, without experimenting until you understand what is going wrong, you will probably have to figure out how to close all Paradox forms while the export program is running and open mainmenu.fsl again when the export is done.  You may even have to figure out how to close Paradox while the export program is running. -Al.

Posted to MB Topic: Paradox Forms « Paradox Board

{Too Long}

Posted to MB Topic: Paradox Forms « Paradox Board

This will work but you need to deny the join, that is, select the record from the helper table that does NOT match each record in the queried table:, :projdata:sometable.db | Somecolumn | Othercolumn | ,                        | Check _j1! | Check       | , :homedata:BoolDual.db | SameTypeAsSomecolumn | BoolWithFalse |                       | not _j1              | Check         | , -Al.

Posted to MB Topic: QBE & SQL « Paradox Board

Which method do you use to set your private directory, and what is your first inkling that this setting is not accepted?  IOW what are you doing and what is the error message?, Common causes of being unable to select a private directory are -- you don't have complete create/read/write/modify permissions to that directory, or another BDE application instance is already using that private directory.-Al.

Posted to MB Topic: Paradox Setup, Vista, etc. « Paradox Board

I am beginning to get more comfortable using Crystal Reports 11, which has a similar feel to Paradox's built-in Report designer.My question is, does anyone know of software to convert simple reports created in Paradox (without any extra programming) into Crystal Reports format?  I just want the basics (groups, breaks, detail field placement and alignments, format, etc.) to copy over.Thanks!

Posted to MB Topic: Convert To/From Paradox « Paradox Board

I have been keeping my eyes open for such a utility since 1998 and I have not found any.Both the Paradox *.rsl/*.rdl file format and the Crystal *.rpt file format are proprietary and undocumented.  Apparently no one has taken the trouble to reverse-engineer either of these formats.  My own experience suggests that it is easier to write a report designer than to decode the Crystal *.rpt format.-Al.

Posted to MB Topic: Convert To/From Paradox « Paradox Board

The problem is that you are replacing a line with a shorter line.  When you write this back into the file, it doesn't fit, leaving the end of the original line exposed., , If you are editing a file in a way that changes its length, you have to copy the file while editing it.  The best way  for you to do this is to open two textstreams -- one in read mode on the original file, and another in write-new mode on a temporary destination file.  Then read each line from the original file into a string variable, edit whatever you want using strings, and write the resultant string to the destination file as a new line., , Don't forget to close the destination textstream., , EXAMPLE:, method run(var eventInfo Event), var,    tsSRC, tsDST         textstream,    sLine, sBgn, sEnd    string, endvar,    tsSRC.open("Sample.txt","r"),    tsDST.open("Result.txt","nw"),    while n...

Posted to MB Topic: ObjectPAL « Paradox Board

Your structure is not many-to-many.  Consider: looking at one "Events" record, how many "Locations" records can it be joined to?  (Hint -- look for the answer between 0 and 2.), , Are you sure that the "Event Id" column in "Events" is part of the primary key, as you have described here?, , -Al.

Posted to MB Topic: Paradox Tables « Paradox Board

Are any of your drive letters mapped to a FTP source?-Al.

Posted to MB Topic: Paradox Setup, Vista, etc. « Paradox Board

{Too Long}

Posted to MB Topic: Microsoft Visual FoxPro (VFP) « V.FoxPro Board

Most "enterprise" database engines have one or more bulk load techniques.  For example, PostgreSQL has "COPY FROM", MySQL has "LOAD DATA INFILE", and Oracle has its Data Pump, its SQL*Loader, and some kind of native import utility.  Smaller "convenience" engines such as FoxPro, Access, and BDE do not have bulk insert methods.  If you absolutely must insert large amounts of data quickly, you will need to move to a database that supports bulk insertion., , I suspect that if a database engine does not allow bulk insertion, then it is also not recommended for any heavy lifting, such as large record counts, many simultaneous users, deeply nested subqueries, etc.  So that even if you could get your FoxPro installation to accept data rapidly, you would soon encounter other frustrating limitations., , -Al.,

Posted to MB Topic: Microsoft Visual FoxPro (VFP) « V.FoxPro Board

Is it possible to check for a null (blank) value from within a calculated field. I currently have a calculated field using an iif statement that checks to see if the value of the field is 0 then it returns a string on the report. I would like to also check if the field is blank and return a different string on the report. 

Posted to MB Topic: Paradox Reports « Paradox Board

1. Turn off "Treat Blanks as Zeros".  Interactively, pick Edit | Preferences | Database and uncheck "Treat blank fields as zeros".  In code, usesession.blankAsZero(false), 2. Use this model for your statement., iif(isblank(TT.FF]),"this field is blank",iif([TT.FF]=0,"this field is zero","this field contains "+string([TT.FF])))-Al.

Posted to MB Topic: Paradox Reports « Paradox Board

Is there a way to use enumOpenDatabases() or enumDatabaseTables() to get a list of all databases that I currently have opened? Or better yet to get a list of what tables other users ( enumusers() ) have open? I have been trying to figure out a way to write this but so far no luck. Any suggestions out there ?

Posted to MB Topic: ObjectPAL « Paradox Board

I don't know any way to see what tables are opened, but you could examine the lock files (PDOXUSRS.LCK) to see what tables are locked, which should give you the info you're seeking.  But unfortunately the lock file structures are as complex as the table file structures, and Borland never committed to publishing any of its file structures.  But fortunately a couple of Borland techs did write a whitepaper on BDE table locking.  But unfortunately the description is incomplete, and th...

Posted to MB Topic: ObjectPAL « Paradox Board

I hate to rush to judgement before all the facts are in, but it appears that either (1) you do not have sufficient permissions to the directory 'C:\Program Files\Corel\WordPerfect Office 2000\program\config\', or (2) the file 'C:\Program Files\Corel\WordPerfect Office 2000\program\config\PDX_EN_FULL_sbar.cfg' is locked or corrupted and cannot be deleted or replaced.Try renaming the 'PDX_EN_FULL_sbar.cfg' manually before launching Paradox.-Al.

Posted to MB Topic: Paradox Tables « Paradox Board

I'm using Paradox 8.  Is there a way to make a drop down list field show more items at one time instead of scrolling only 5 at a time?

Posted to MB Topic: Paradox Forms « Paradox Board

There is no way to do this with the built-in Drop-down Edit field object., , I have simulated the Drop-down Edit field object with a Labeled field object,, a small square pushbutton, and a List field object., , With a Labeled field object, you can manipulate the size of the label and, the edit region separately.  Place the small pushbutton right-justified inside, the field's frame to get the best appearance, and size the edit region to, fill the remainder fo the field.  Hide the label behind the pushbutton., , Place and size the List field to represent the Drop-down list, and make it, invisible.  Use the pushButton event of the button to drop the list down, by making the List field object visible.  Use the mouseClick and other events, on the List field to copy the selected value to the Labeled field, and to, make the List invisible again.  Don't forget to move back to the Labeled field, so you don't leave the operator with an invisible active object., , If you'...

Posted to MB Topic: Paradox Forms « Paradox Board