I.T. Discussion Community!
-Collapse +Expand
Paradox
Search Paradox Group:

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

Prestwood eMagazine

December 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

eMag Nov 2014 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
Message Boards
PrestwoodBoards.com
  November 2014 - Paradox Edition (1671 of 4,766 subscribers receive this group's content.) Year 16 Issue 11  
I.T. Discussion Community!


Expert guidance from working professionals!
psSendMail DLL topic:
v1.1 Documentation
by Wes Peterson
v1.1 of psSendMail will soon be replaced by v2.

IT Water-Cooler for Power-Users topic:
Setup Exchange E-Mail Queue
by Jon Speare

About: An email queue is setup for 2+ workers as a queue where those working the queue move emails to subfolders or delete as they proceed. Subfolders sample: Assigned, Completed, Ignored, etc. Good for groups of staff to work. Our support@prestwood.com is an email queue. Our scheduler and tech staff in our Network Operating Center (NOC) work this queue.






 Paradox Group Top 
Visit Group | My Group Settings
Paradox Tables topic (classic post):
BDE Best Practices: Safely Use Paradox Tables
by Mike Prestwood

Use a file server (not a workstation) to store your data, disable Oplocks on the filer server, and configure the BDE (local share to true and optimize if desired). Finally, if workstations are crashing, fix em so they don't. You want clean running computers that don't crash.


ObjectPAL Coding topic (classic post):
ObjectPAL Calendar Packaged as a Form
by Laura Lage

Some time ago I created a calendar form that I have been using instead of attaching to Microsofts calendar. This calendar works better for me than the OCX version from Microsoft did, so I thought that I would share it with you.


 Monthly Paradox Lesson
OPAL: Wicked Coding Tasks Topic:
Code Snippet of the Month

The following code snippet adds an appointment to your Outlook calendar. Tested with Paradox 9 and Outlook 2003 but should work with later versions of both programs.

Note, you will get a Error opening server 'Outlook.Application' error if your antivirus program is blocking Outlook access.

var

 oleOutlook oleAuto
 oleAppointment oleAuto
endVar
  
;The open will fail if your AntiVirus program is blocking access.

oleOutlook.open("Outlook.Application")
oleAppointment=oleOutlook.CreateItem(1)
  
oleAppointment.Subject = "Test From ObjectPAL"

oleAppointment.Body="You can add appointments from ObjectPAL."
oleAppointment.Start=dateTime() ;Adds an appointment now.
oleAppointment.Duration=60

oleAppointment.ReminderSet=True
oleAppointment.Location="My Office"
oleAppointment.BusyStatus = 2
  
oleAppointment.save()
Interactive Paradox: Using Data Topic:
Definition of the Month: Project Alias
A project alias, like public aliases, point to a folder. Project aliases are stored in the PDOXWORK.CFG file, which is loaded whenever you change working directories.
Paradox & ObjectPAL Topic:
Resource Link of the Month: RDA World Wide
 
Many downloadable ObjectPal examples as well as additional development tools.
Installation, Setup, & BDE Topic:
Question:

I recently upgraded to Windows XP and now Paradox 11 cannot open SQL Server database tables. In the open-dialog-box, I see the aliases, but cannot select one which is linked to a SQL server database. The same thing happens, trying to create a QBE query, new form, etc... All existing queries, forms, ... are working (using these aliases).


Answer:

Solution was to apply the latest BDE patch, all works as it should.

OPAL: Language Details Topic:
Tip of the Month

Two advantages of using constants are that they humanize your code and help make managing your code easier. They humanize your code by making your code easier to read. A constant named tax is easier to remember and understand than 8.125. Constants help you maintain your code by centralizing values. If the tax rate in your area changes from 8.125 to 8.5, you change the constant in one location.




Follow PrestwoodBoards on: 


©1995-2019 PrestwoodBoards  [Security & Privacy]
Professional IT Services: Coding | Websites | Computer Tech