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 Sep 2015 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
  September 2015 - Paradox Edition (1682 of 4,774 subscribers receive this group's content.) Year 17 Issue 9  
Your full service technology partner!


Expert guidance from working professionals!
Tech Services Info topic:
HD Data Recovery, Send Away
by Mike Prestwood

DriveSavers Partner. After our recovery attempts, offer to send to DriveSavers or equivalent. Price ranges from $500 to $1,500.


IT Water-Cooler for Power-Users topic:
How To Configure Auto Logon In Windows 7
by Eric Prestwood

Configure your computer to auto log on to a user (even an admin)


Role-Based Tech Talk topic:
Crash, Bomb, Hang, and Deadlock
by Scott Wehrly
This article explores and defines the following terms: crash, bomb, hang, deadlock, exception, fatal error, and blue screen of death.

American I.T. workforce topic:
Sharpening your skills - A short story
by Ramesh R
Here is a short story about a woodcutter and his job. From this job, we have lot of learnings that implies to our career and sharpening our skills. Such examples in life are very important for shaping our career. Enjoy the short story.





 Paradox Group Top 
Visit Group | My Group Settings
Installation, Setup, & BDE topic (classic post):
Can I install Paradox 10 or 11+ on Windows 7? Vista?
by Mike Prestwood

Bottom line is you should skip Vista and either stick with XP or move to Win 7. If you have to use Vista, you might be better off with Paradox 9.


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 Basics Topic:
Code Snippet of the Month

Declaring variables is optional unless you click Program | Compiler Warnings while in the ObjectPAL editor for every form, script, and library you create. Using Compiler Warnings is strongly recommended to avoid incorrectly typing an existing variable and to avoid any confusion about variable scope. Also recommended is turning on Compile with Debug for every form, script, and library too for tighter, cleaner code.

Undeclared variables are AnyType variables. Common data types include Currency, Date, Datetime, Logical, LongInt, Number, SmallInt, String, and Time.

Declare local variables within a method. If you want a local static variable (retains it's value because it is not destroyed), declare the varialbes above the method. Variables declared in an object's Var window are visible to all methods attached to that object, and objects that it contains.

var

    FullName String
    Age SmallInt
    Weight Number
endVar
 
FullName = "Mike Prestwood"

Age = 32
Weight =154.4
msgInfo("", FullName + ", age=" + String(Age) 
             + ", weight=" + String(Weight))

OPAL: Language Basics Topic:
Definition of the Month: Camel Casing
Camel Casing capitalizes the first character of each word except the first word, so it frequently looks like a one or two hump camel. Used by many languages including Paradox's ObjectPAL. You can contrast Camel Casing with Pascal Casing which capitalizes the first character of each word (including acronyms over two letters in length) and was popularized by Pascal.

Camel Casing capitalizes the first character of each word except the first word, so it frequently looks like a one or two hump camel. Used by many languages including Paradox's ObjectPAL.

myAge
theBoxCar

You can contrast Camel Casing with Pascal Casing which capitalizes the first character of each word (including acronyms over two letters in length) and was popularized by Pascal.

P9 Book: Power Programming Topic:
Download of the Month: Paradox 9 Book Support Files

Download the 1,500 KB ZIP support file download (unzips to 5+MB). Contains 200+ forms demoing code from the book PLUS OTHER MATERIAL (much more material). Also includes 7 libraries, 10 scripts, and other support files (reports, queries, tables, datamodels, etc.)

Paradox & ObjectPAL Topic:
Documented Error of the Month: Paradox:03:69e5:
Error: Unexpected Condition GP 0000 at Paradox:03:69e5:
Explanation:

Try rebuilding the table using Table Repair (AKA TUtility).

Paradox & ObjectPAL Topic:
Resource Link of the Month: dBforums Corel Paradox forum

www.dbforums.com offers support for a variety of databases including Corel Paradox.

Professional Paradox/ObjectPAL Help Topic:
FAQ of the Month: Paradox and Large Databases
Question: I like the concept and feature-set of Paradox, but wonder if it can handle very large transactions and storage?

Answer:

We like Paradox's feature set too but it's not the right tool for every situation. For very large transactions and storage, we prefer a true SQL server over ALL file-based databases including over Paradox. Although we judge and discuss the viability of toolsets for each project, we do have standards we steer our clients toward. For example, we steer our Paradox-oriented large transaction/large storage needs clients toward SQL Server 2005 with either VS.Net as a front-end or Delphi (for a true native code solution).

Paradox Tables Topic:
Tip of the Month
If you are developing an application using local tables and you know you are eventually going to move the data onto a SQL server, then do yourself a favor and spend a few hours studying the field and table naming rules of your target SQL server before you create your first table. While creating your local tables, use a naming convention that uses common rules. If you use the naming rules in common between the two database types, then you will save yourself time when you move your data to the SQL server because SQL servers often have different naming rules from the naming rules in Paradox.


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


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