We are pleased to announce the release of Recital 10.0.2.

Here is a brief list of features and functionality that you will find in the 10.0.2 release. 

• New commands
  SAVE/RESTORE DATASESSION [TO variable]
  CONNECT "connectString"
  DISCONNECT 
• New functions (OData compatible)
  startsWith(haystack as character, needle as character)
  endsWith(haystack as character, needle as character)
  indexOf(haystack as character, needle as character)
  substringOf(haystack as character, needle as character)
  concat(expC1, expC2)
• New system variables
  _LASTINSERTEDSYNCNUM
• Enhanced commands
  Added CONNSTRING "connectingString" to the USE command to connect to remote servers (Recital, MySQL, PostgreSQL, Oracle, ODBC)
• Further SQL query optimizer improvements to boost performance
• Performance improvements in Recital Web
• Forced all temporary files into temp directory (improves performance when local tmpfs is used as temp directory and reduces network i/o)
• Fixed cookie and session variable problems in Recital Web
• Fixed problem with temporary files being left after some server queries involving memos and object data types
• Improved performance of the Windows ODBC driver
• Fixed a security flaw in Recital Web
• Fixed all reported bugs 

Each Recital table can have one or more data dictionaries to provide a central repository for constraints and other metadata. 

Here's how to set up field validation for a field with a small static number of acceptable values.

Using the example.dbf table from the southwind sample database, validation can be added to the title field to ensure it matches one of a list values.

open database southwind
alter table example add constraint;
 (title set check inlist(alltrim(title),"Miss","Mr","Mrs","Ms"))

The inlist() function checks whether the specified expression exists in the comma-separated list which follows.  An attempt to update title with a value not in the list will give an error: Validation on field 'TITLE' failed.

If you have access to the Recital Workbench, you can use the modify structure worksurface to add and alter your dictionary entries, including a customized error message if required.

MQCURMSGS()

Syntax

MQCURMSGS( <expN> )

Description

The MQCURMSGS() function returns the current number of unread messages in the queue specified by <expN>

Example

mqdes=mqopen("/myqueue")
if (mqdes < 0)
   messagebox(strerror()+",errno="+alltrim(str(error())))
   return
endif
do while (mqcurmsgs(mqdes) > 0)
   mstr=mqreceive(mqdes)
   if (empty(mstr))
      messagebox(strerror()+",errno="+alltrim(str(error())))
      return
   endif
   messagebox(mstr)
end do
mqclose(mqdes)

In Adobe's own words:

"Adobe® AIR® is a cross-operating system runtime that lets developers combine HTML, Ajax, Adobe Flash®, and Adobe Flex® technologies to deploy rich Internet applications (RIAs) on the desktop."

The outcome of this combination of technologies is that developers can design and render quite beautiful user interfaces cross platform. For us desktop Linux users it is nice to have an additional avenue for obtaining and running attractive desktop applications.

Examples of great Adobe air applications are Adobe.com for My Desktop, TweetDeck and the Times Reader. You can download these applications and many more at the Adobe Marketplace.

The easiest way to install Adobe Air on Fedora 12 is to download the latest build from Adobe, click here.

Once you have downloaded the .bin file do the following at the shell:

su -
chmod +x AdobeAIRInstaller.bin
./AdobeAIRInstaller.bin

Once you have Air installed, there is a slight tweak you will have to do to get it running on Fedora 12, it is related to the security certificates. This can be remedied in one simple line at the shell prompt as root.

su -
for c in /etc/opt/Adobe/certificates/crypt/*.0; do aucm -n $(basename $c) -t true; done

What this line is doing is using the aucm which is the Adobe Unix certificate manager to set the certificates installed as trusted.
You will now be able to go to the Adobe Marketplace and download and run Air applications without any issues.

Enjoy!