IT SOLUTIONS
Your full service technology partner! 
-Collapse +Expand
Paradox
Search Paradox Group:

Advanced
-Collapse +Expand Paradox To/From
To/FromCODEGuides
-Collapse +Expand Paradox Store
PRESTWOODSTORE

Prestwood eMagazine

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

   ► eMag   Print This    All Groups  
View Group Edition:
Full Edition Your Edition || Prev Next || Subscription Center

Prestwood IT Newsletter Jul 2011 Issue - Paradox Edition

Subscribe!

Start subscribing now! It's free!

Each month on or after the 1st, and only once a month, we will send you content from up to 5 community groups. If you select this Paradox group, you'll receive the following content below mixed in with the other groups you elect to include.

Prestwood eMag
Our monthly opt-in coupons+newsletter.
portal.prestwood.com
  July 2011 - Paradox Edition (1682 of 4,774 subscribers receive this group's content.) Year 13 Issue 7  
Your full service technology partner!


Expert guidance from working professionals!
Help Wanted! topic:
Contribute To The Prestwood Community
by Mike Prestwood
We are always looking for talented developers to participate in our message boards, post articles, etc.

IT Water-Cooler for Power-Users topic:
Top 10 Things That Annoy Programmers
by Wes Peterson
http://www.kevinwilliampang.com/2008/08/28/top-10-things-that-annoy-programmers/





 Paradox Group Top 
Visit Group | My Group Settings
P9 Book: Power Programming topic (classic post):
Power: Chapter 18, Reusing Code
by Mike Prestwood
Chapter 18, "Reusing Code" from Paradox 9 Power Programming by Mike Prestwood. Includes coding custom methods, custom procedures, and using ObjectPAL libraries.

OPAL: Language Details topic (classic post):
Looping in ObjectPAL
by Mike Prestwood

Using loop structures in ObjectPAL (for, forEach, scan, while, and looping with timers).


 Monthly Paradox Lesson
OPAL: Language Details Topic:
Code Snippet of the Month

Export to OpenOffice

method openWorkBook(var Excel OleAuto, fileName string) logical

var
 StarDesktop,StarOffice  OLEAuto
 oooDoc,scr,lists,list,zak OleAuto
 massiv AnyType
 fs filesystem
 put,s string
 dlin,k,i smallInt
endVar
ShName.BLANK()

ShiNDEX.BLANK()
try

  scr.open("MSScriptControl.ScriptControl")
 scr.language = "javascript";
 scr.eval("aaa=new Array()")
 massiv = scr.eval("aaa")
 scr.AddCode("function SetItem(ind,val){massiv[ind]=val}")
 StarOffice.Open("com.sun.star.ServiceManager")

 StarDesktop=StarOffice.createInstance("com.sun.star.frame.Desktop")
 dlin=fileName.size()

 
 put=""
 k=1
 i=1
 while i<>dlin

  s=fileName.subStr(i,1)

  if ansiCode(s)=92 then 
   put=put+"http://legacy.prestwood.com/"+fileName.subStr(k,i-k)

   k=i+1
  endIf 

  i=i+1
 endWhile
 put=put+"http://legacy.prestwood.com/"+fileName.subStr(k,i-k+1)
 if put.subStr(put.size()-3,4)=".xls" then

 else
  put=put+".xls"
 endif
 Excel=StarDesktop.LoadComponentFromURL("file://"+put,"_blank", 0,massiv)
 return True

onFail errorClear() return False
endTry
endMethod
OPAL: Language Basics Topic:
Definition of the Month: ObjectPAL
ObjectPAL stands for Object Paradox Application Language.

ObjectPAL stands for Object Paradox Application Language. The acronym portion of the name (PAL) comes from the DOS version of Paradox. The term Object was added to the name because ObjectPAL is an object-based event-driven programming environment that is much more advanced then its PAL predecessor.

Installation, Setup, & BDE Topic:
Documented Error of the Month: Paradox error 11270
Error: Multiple Net Files in use error.
Explanation:

If you wish to run more than one copy of Paradox on the same machine, you must configure each to point to the same Net Folder.

Paradox for Linux Topic:
Resource Link of the Month: Paradox for Linux Resource Page

Our Prestwood Programmer Community page that contains links to varioius Paradox for Linux resources. Part of our Linux Group.

Tool Basics Topic:
FAQ of the Month: Purchasing Paradox
Question:

How can I purchase Paradox?


Answer:

Answer from Corel...

Paradox was not updated from Paradox 10. It was given a new look, but the functionality remains mainly the same. Paradox 11 is available in the WordPerfect Office Professional version and can be purchased through Corel's online store or by calling us [Corel].  Paradox is also available as a standalone if you already own WordPerfect Office, and is [available] through our licensing program.  Within North America, please call 1-800-772-6735, Corel's Customer Support Services, to purchase the Paradox upgrade. We are open from Monday - Friday, 9:00 am - 7:00 pm E.S.T. and would be happy to serve you. For customers outside of North America, please visit www.corel.com/contact to locate a Corel Customer Support Services Center nearest you.

Paradox Tables Topic:
Tip of the Month

Referential integrity and other settings stored in .VAL files sometimes interfere with the development of a project. This particularly is a problem when you are restructuring a child table in a referential integrity link. If this happens to you and you don't mind losing the validity checks for a table or for a set of tables, go ahead and delete or, better yet, rename them.



Go ahead!   Use Us! Call: 916-726-5675  Or visit our new sales site: 
www.prestwood.com


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