IT SOLUTIONS
Your full service technology partner! 
A. I. Breveleri -Collapse +Expand
-Collapse +Expand
AIBreveleri
-Collapse +Expand Profile
Member Info
Member Narration

POSTS:
MB Posts (286)◄╣
KB Comments (8)

Search AIBreveleri:

Advanced
   ► MB Lobby   Print This     

AIBreveleri Message Board Activity

  


25 Message Board Posts:


Thread 25 of 25
Thread Starter or a Reply (but not last)  Group

AIBreveleri
RE: Filebrowser & Files Types
I'm afraid there is no way to do what you are attempting with a single Filesystem call.  The Filesystem type is only a simple wrapper around the underlying DOS file system, which does not support advanced searches in the filename space. I recommend using <Filesystem>.enumFileList ( "*.*", <string array> ) to extract all the file names in a directory and then using advMatch() on each array item to filter the file list -- as opposed to using multiple Filesystem calls to build up a compound file list. -Al.
Posted to MB Topic: ObjectPAL « Paradox Board
7 years ago
Nothing New Since Your Last Visit
Corel Paradox / ObjectPAL Coding

Thread 24 of 25
Thread Starter or a Reply (but not last)  Group

AIBreveleri
RE: Win7/Paradox 9
This problem is usually caused by multiple workstations referencing the NET DIR differently., , The NET DIR parameter in IDAPI.CFG on all workstations should be configured using the exact same path (only the drive letter may differ).  On each workstation, start the BDECFG32 program (normally located in Program Files\Borland\Common Files\BDE), click Paradox, and set the NET DIR parameter to reference the same location., , This is a common problem and you can learn a lot about it by googling "paradox directory is controlled by other net file"., ,
Posted to MB Topic: Paradox Setup, Vista, etc. « Paradox Board
8 years ago
Nothing New Since Your Last Visit
Corel Paradox / ObjectPAL Coding

Thread 23 of 25
Thread Starter or a Reply (but not last)  Group

coconut73
There is no disk in drive error paradaox 10 win 8.
Paradox is running fine but when i get "There is no  disk in the drive. Please insert disk into drive" mostly when opening forms i click the continue button 2 times and it opens form.  It is random when the error window opens. Any help would be great. thank you!! paradox 10.0.0.663 windows 8.1 brand new machine not running any compatibility mode
Posted to MB Topic: Paradox Setup, Vista, etc. « Paradox Board
8 years ago

AIBreveleri
{Too Long!}
8 years ago
Nothing New Since Your Last Visit
2400
Hits

Corel Paradox / ObjectPAL Coding

Thread 22 of 25
Thread Starter or a Reply (but not last)  Group

AIBreveleri
RE: {Too Long}
{Too Long!}
Posted to MB Topic: Paradox Setup, Vista, etc. « Paradox Board
8 years ago
Nothing New Since Your Last Visit
Corel Paradox / ObjectPAL Coding

Thread 21 of 25
Thread Starter or a Reply (but not last)  Group

AIBreveleri
RE: .NET Control File location set...
BDE Administrator, /Configuration\, Drivers | Native | PARADOX, NET DIR = drive:path , That is:, , Run the BDE Administrator utility "bdeadmin.exe". This is commonly located at , "C:\Program Files\Borland\Common Files\BDE\bdeadmin.exe"., , Select the Configuration tab., , In the navigation pane choose Drivers, Native, PARADOX., , In the data pane find the key named "NET DIR" and set its value to the drive and path of your "PDOXUSRS.NET" file., , e.g. if net file is F:\Common\NetDir\PDOXUSRS.NET then  drive:path is F:\Common\NetDir.
Posted to MB Topic: Paradox Tables « Paradox Board
8 years ago
Nothing New Since Your Last Visit
Corel Paradox / ObjectPAL Coding

Thread 20 of 25
Thread Starter or a Reply (but not last)  Group

AIBreveleri
RE: Tcursors rounding number field...
Short answer: num = format("w.3",tc.gallons) Long answer: The exact details of what is happening depends on the data type of your variable "num". If it is a number, then the conversion occurs when the "~num" in the query is expanded. If it is a string, then the conversion occurs in the statement "num = tc.gallons"., , In either case you are getting two decimal places because you are using a default format supplied by Paradox or Windows., , The best way to get the string you want is to take control of the format used in the string conversion. The easiest place to do this is at the "num = tc.gallons" statement., , 1) Look up "format procedure" in the online help for "ObjectPAL Reference", , 2) define a string variable in your Var section:, , var, ..., num string, endvar, , 3) replace the "num = tc.gallons" statement with a format() call:, , num = format("w.3",tc.gallons), , -Al., ,
Posted to MB Topic: Paradox Tables « Paradox Board
9 years ago
Nothing New Since Your Last Visit
Corel Paradox / ObjectPAL Coding

Thread 18 of 25
Thread Starter or a Reply (but not last)  Group

Gary.L3
Custom method call in a calculated field
Can someone please help with this? In Corel Paradox 8, I have a custom method that returns a string that I want to display in the field value box.   However the only thing that displays is ERROR.   The help menus say that the method has to be in the "RSL runtime library." My method was attached at the form level.   Any help would be appreciated.
Posted to MB Topic: Paradox Forms « Paradox Board
9 years ago

AIBreveleri
{Too Long!}
9 years ago
Nothing New Since Your Last Visit
3474
Hits

Corel Paradox / ObjectPAL Coding

Thread 17 of 25
Thread Starter or a Reply (but not last)  Group

AIBreveleri
RE: Custom method call in a calcul...
You must add code to refresh the field whenever the record changes. Paradox does this automatically for any objects that have been bound to (defined with) columns in the data model.  If you just plunk a field down on the form without defining its data source, it remains completely ignorant of any record changes or other data navigation events. I think you may be using the wrong technique to display the data you want to see.  Can you explain what you are trying to do? -Al.
Posted to MB Topic: Paradox Forms « Paradox Board
9 years ago
Nothing New Since Your Last Visit
Corel Paradox / ObjectPAL Coding

Thread 14 of 25
Thread Starter or a Reply (but not last)  Group

AIBreveleri
RE: Packing Paradox Tables
{Too Long!}
Posted to MB Topic: ObjectPAL « Paradox Board
9 years ago
Nothing New Since Your Last Visit
Corel Paradox / ObjectPAL Coding

Thread 13 of 25
Thread Starter or a Reply (but not last)  Group

andreK
Packing Paradox Tables
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
21 years ago

AIBreveleri
{Too Long!}
9 years ago
Nothing New Since Your Last Visit
3194
Hits

Corel Paradox / ObjectPAL Coding

Thread 11 of 25
Thread Starter or a Reply (but not last)  Group

AIBreveleri
session.enumUsers()
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
10 years ago
Nothing New Since Your Last Visit
Corel Paradox / ObjectPAL Coding

Thread 10 of 25
Thread Starter or a Reply (but not last)  Group

AIBreveleri
RE: paradox 7 to 9 help
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
10 years ago
Nothing New Since Your Last Visit
Corel Paradox / ObjectPAL Coding

Thread 9 of 25
Thread Starter or a Reply (but not last)  Group

John.C
Problem with Delete QBE Queries
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
10 years ago

AIBreveleri
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.
10 years ago
Nothing New Since Your Last Visit
2739
Hits

Corel Paradox / ObjectPAL Coding

Thread 8 of 25
Thread Starter or a Reply (but not last)  Group

AIBreveleri
RE: Problem with Delete QBE Querie...
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
10 years ago
Nothing New Since Your Last Visit
Corel Paradox / ObjectPAL Coding

Thread 7 of 25
Thread Starter or a Reply (but not last)  Group

AIBreveleri
RE: Can't update table, form has l...
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
10 years ago
Nothing New Since Your Last Visit
Corel Paradox / ObjectPAL Coding

Thread 6 of 25
Thread Starter or a Reply (but not last)  Group

owensct
Can't update table, form has lock on .DBF
{Too Long!}
Posted to MB Topic: Paradox Forms « Paradox Board
10 years ago

AIBreveleri
{Too Long!}
10 years ago
Nothing New Since Your Last Visit
2751
Hits

Corel Paradox / ObjectPAL Coding

Thread 5 of 25
Thread Starter or a Reply (but not last)  Group

AIBreveleri
RE: Creating a new logical column ...
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
11 years ago
Nothing New Since Your Last Visit
Corel Paradox / ObjectPAL Coding

Thread 4 of 25
Thread Starter or a Reply (but not last)  Group

AIBreveleri
RE: Problem finding Private Direct...
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
11 years ago
Nothing New Since Your Last Visit
Corel Paradox / ObjectPAL Coding

Thread 3 of 25
Thread Starter or a Reply (but not last)  Group

AIBreveleri
RE: Paradox Report (.rsl) to Cryst...
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
12 years ago
Nothing New Since Your Last Visit
Corel Paradox / ObjectPAL Coding

Thread 2 of 25
Thread Starter or a Reply (but not last)  Group

AIBreveleri
RE: Special Characters (\t = tab e...
{Too Long!}
Posted to MB Topic: ObjectPAL « Paradox Board
12 years ago
Nothing New Since Your Last Visit
Corel Paradox / ObjectPAL Coding

Thread 1 of 25
Thread Starter or a Reply (but not last)  Group

AIBreveleri
RE: Implementing Many To Many Rela...
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
12 years ago
Nothing New Since Your Last Visit
Corel Paradox / ObjectPAL Coding
Go ahead!   Use Us! Call: 916-726-5675  Or visit our new sales site: 
www.prestwood.com


©1995-2022 Prestwood IT Solutions.   [Security & Privacy]