Recital

Login Register

In this article Barry Mavin, CEO and Chief Software Architect for Recital, gives details on Working with user-defined Functions in the Recital Database Server.

Overview

User-defined functions (UDFs) are collections of statements written in the Recital 4GL (compatible with Visual FoxPro) stored under a name and saved in a Database. User-defined functions are just-in-time compiled by the Recital database engine. User-defined functions can be used in SQL statements to extend the power and flexibility of the inbuilt functions. Using the Database Administrator in Recital Enterprise Studio, you can easily create, view, modify, and test Stored Procedures, Triggers, and user-defined functions.

Tip
You can also extend the Recital Database Server with C Extension Libraries and use the functions defined within that library also.

Creating and Editing user-defined functions

To create a new User-defined function,  right-click the Procedures node in the Databases tree of the Project Explorer and choose Create. To modify an existing User-defined function select the User-defined function in the Databases Tree in the Project Explorer by double-clicking on it or selecting Modify from the context menu. By convertion we recommend that you name your User-defined functions beginning with "f_xxx_", where xxx is the name of the table that they are associated with.

Testing the user-defined function

To test run the user-defined function, select it in the Databases Tree in the Project Explorer by double-clicking on it. Once the Database Administrator is displayed, click the Run button to run it.

Example

Example: user-defined function "f_order_details_total".
////////////////////////////////////////////////////////////////////////
// example user-defined function
function f_order_details_total(pUnitprice, pQuantity, pDiscount)
    return (pUnitprice + pQuantity + pDiscount) > 0
endfunc
Example: using the user-defined function in a SQL SELECT statement.
////////////////////////////////////////////////////////////////////////
// sample code to use a user-defined function in a SQL SELECT statement
select * from customers where f_order_details_total(Unitprice, Quantity, Discount)

Using user-defined function libraries with the Recital Database Server

You can place all of the user-defined functions associated with a particular table into a procedure library. You then define an Open Trigger for the table that opens up the procedure library whenever the table is accessed. This is a much faster way of using user-defined functions as it reduces the amount of file open/close operations during a query and also simplifies development and maintenance.

By convertion we recommend that you should name the library using the convention "lib_xxx", where xxx is the name of the table that the library is associated with.

Example: procedure library in lib_order_details.
////////////////////////////////////////////////////////////////////////
// example user-defined functions
function f_order_details_total(pUnitprice, pQuantity, pDiscount)
    return (pUnitprice * pQuantity - pDiscount) > 0
endfunc

function f_order_details_diff(pUnitprice, pQuantity, pDiscount, pValue)
    return f_order_details_total(pUnitprice, pQuantity, pDiscount) - pValue
endfunc
Example: Open Trigger in dt_order_details_open.
////////////////////////////////////////////////////////////////////////
// This trigger will open up the procedure library when the table is opened
set procedure to lib_order_details additive
Example: Close Trigger in dt_order_details_close.
////////////////////////////////////////////////////////////////////////
// This trigger will close the procedure library when the table is closed
close procedure lib_order_details
Example: using the user-defined function in a SQL SELECT statement.
////////////////////////////////////////////////////////////////////////
// sample code to use a user-defined function in a SQL SELECT statement
select * from customers where f_order_details_total(Unitprice, Quantity, Discount)

User-defined functions can also be used with any of the Client Drivers that work with the Recital Database Server.

Published in Blogs
Read more...

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 
Published in Blogs
Read more...

All temporary files created by Recital are stored in the directory specified by the environment variable DB_TMPDIR.

 
In order to have these files stored in memory first create a temporary directory
mkdir /opt/recital/tmp
 
Then mount the directory with the tmpfs command
mount -t tmpfs -o size=1g recitaltmpfs /usr/recital/tmp
 
Then change the DB_TMPDIR variable in the recital.conf to point to the newly created temporary directory.
Published in Blogs
Read more...
Found a nice subversion plugin for finder on the MAC.

The goal of the SCPlugin project is to integrate Subversion into the Mac OS X Finder. 

  • Support for Subversion.
  • Access to commonly used source control operations via contextual menu [screenshot]
  • Dynamic icon badging for files under version control. Shows the status of your files visually. [ screenshot ]
Published in Blogs
Read more...

Warnings

This is a sample info message. Use <p class="gkInfo1">Your info message goes here!</p>.

This is a sample tips message. Use <p class="gkTips1">Your tips goes here!</p>.

This is a sample warning message. Use <p class="gkWarning1">Your warning message goes here!</p>.

This is a sample info message. Use <p class="gkInfo2">Your info message goes here!</p>.

This is a sample tips message. Use <p class="gkTips2">Your tips goes here!</p>.

This is a sample warning message. Use <p class="gkWarning2">Your warning message goes here!</p>.

This is a sample info message. Use <p class="gkInfo3">Your info message goes here!</p>.

This is a sample tips message. Use <p class="gkTips3">Your tips goes here!</p>.

This is a sample warning message. Use <p class="gkWarning3">Your warning message goes here!</p>.

This is a sample info message. Use <p class="gkInfo4">Your info message goes here!</p>.

This is a sample tips message. Use <p class="gkTips4">Your tips goes here!</p>.

This is a sample warning message. Use <p class="gkWarning4">Your warning message goes here!</p>.

This is a sample info message. Use <p class="gkInfo5">Your info message goes here!</p>.

This is a sample tips message. Use <p class="gkTips5">Your tips goes here!</p>.

This is a sample warning message. Use <p class="gkWarning5">Your warning message goes here!</p>.

Headers

This is heading 1

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Integer semper egestas nunc in volutpat. Fusce adipiscing velit ac eros tempor iaculis. Phasellus venenatis mollis augue, non posuere odio placerat in. Etiam volutpat ultrices lectus. Fusce eu felis erat. Donec congue interdum elit, sed ornare magna convallis lacinia. In hac habitasse platea dictumst. Mauris volutpat consectetur accumsan.

This is heading 2

Cras diam justo, sodales quis lobortis sed, lobortis vel mauris. Sed a mollis nunc. Quisque semper condimentum lectus, eget laoreet ipsum auctor et. Quisque sagittis luctus augue, id fringilla enim euismod quis. Nullam blandit, elit at euismod rutrum, tortor nibh posuere mauris, in volutpat diam ante ac dui. Sed velit massa, imperdiet placerat tristique et, consectetur a lorem. Praesent aliquet turpis in quam tempor eu pulvinar nibh luctus.

This is heading 3

Vivamus rhoncus arcu sit amet est tristique convallis nec vel eros. Vestibulum euismod luctus velit quis porta. Aliquam varius placerat mauris sed vehicula. Integer porta facilisis sapien, in tempus lorem mattis molestie. Suspendisse potenti. Praesent quis diam non dolor convallis mattis eu id nulla.

This is heading 4

Proin urna erat, egestas vel consectetur at, accumsan at purus. Donec est risus, facilisis dignissim placerat nec, euismod lacinia nisi. Nam ac sem sed quam sollicitudin condimentum et eu neque. Nunc enim urna, ultricies ac mollis pretium, imperdiet hendrerit massa. Sed eleifend felis sed tellus cursus lacinia. Aenean venenatis aliquet euismod. Nam quis turpis tellus, vitae malesuada neque.

This is a headline.

This is a subheadline.

Use <p class="gkHeadling">for headline</p>.Use <p class="gkSubHeadline">for subheadline</p>.Proin urna erat, egestas vel consectetur at, accumsan at purus. Donec est risus, facilisis dignissim placerat nec, euismod lacinia nisi. Nam ac sem sed quam sollicitudin condimentum et eu neque. Nunc enim urna, ultricies ac mollis pretium, imperdiet hendrerit massa. Sed eleifend felis sed tellus cursus lacinia. Aenean venenatis aliquet euismod. Nam quis turpis tellus, vitae malesuada neque.

This is a small headline

This is a large headline

Use <p class="gkHeadling">for headline</p>.Use <p class="gkSubHeadline">for subheadline</p>.Proin urna erat, egestas vel consectetur at, accumsan at purus. Donec est risus, facilisis dignissim placerat nec, euismod lacinia nisi. Nam ac sem sed quam sollicitudin condimentum et eu neque. Nunc enim urna, ultricies ac mollis pretium, imperdiet hendrerit massa. Sed eleifend felis sed tellus cursus lacinia. Aenean venenatis aliquet euismod. Nam quis turpis tellus, vitae malesuada neque.

Icon set 1

This is a sample audio message. Use <p class="gkAudio">Your audio message goes here!</p>.

This is a sample webcam message. Use <p class="gkWebcam">Your webcam goes here!</p>.

This is a sample email message. Use <p class="gkEmail">Your email message goes here!</p>.

This is a sample creditcard message. Use <p class="gkCreditcard">Your creditcart message goes here!</p>.

This is a sample feed message. Use <p class="gkFeed">Your feed goes here!</p>.

This is a sample help message. Use <p class="gkHelp">Your help message goes here!</p>.

This is a sample images message. Use <p class="gkImages">Your images message goes here!</p>.

This is a sample lock message. Use <p class="gkLock">Your webcam goes here!</p>.

This is a sample printer message. Use <p class="gkPrinter">Your printer message goes here!</p>.

This is a sample report message. Use <p class="gkReport">Your report message goes here!</p>.

This is a sample script message. Use <p class="gkScript">Your script goes here!</p>.

This is a sample time message. Use <p class="gkTime">Your time message goes here!</p>.

This is a sample user message. Use <p class="gkUser">Your user message goes here!</p>.

This is a sample world message. Use <p class="gkWorld">Your world goes here!</p>.

This is a sample cart message. Use <p class="gkCart">Your cart message goes here!</p>.

This is a sample cd message. Use <p class="gkCd">Your cd message goes here!</p>.

This is a sample chart_bar message. Use <p class="gkChartBar">Your chart_bar goes here!</p>.

This is a sample chart_line message. Use <p class="gkChartLine">Your chart_line message goes here!</p>.

This is a sample chart_pie message. Use <p class="gkChartPie">Your chart_pie message goes here!</p>.

This is a sample clock message. Use <p class="gkClock">Your clock goes here!</p>.

This is a sample cog message. Use <p class="gkCog">Your cog message goes here!</p>.

This is a sample coins message. Use <p class="gkCoins">Your coins message goes here!</p>.

This is a sample compress message. Use <p class="gkCompress">Your compress goes here!</p>.

This is a sample computer message. Use <p class="gkComputer">Your computer message goes here!</p>.

This is a sample cross message. Use <p class="gkCross">Your cross message goes here!</p>.

This is a sample disk message. Use <p class="gkDisk">Your disk goes here!</p>.

This is a sample error message. Use <p class="gkError">Your error message goes here!</p>.

This is a sample exclamation message. Use <p class="gkExclamation">Your exclamation message goes here!</p>.

This is a sample film message. Use <p class="gkFilm">Your film goes here!</p>.

This is a sample folder message. Use <p class="gkFolder">Your folder message goes here!</p>.

This is a sample group message. Use <p class="gkGroup">Your group message goes here!</p>.

This is a sample heart message. Use <p class="gkHeart">Your heart goes here!</p>.

This is a sample house message. Use <p class="gkHouse">Your house message goes here!</p>.

This is a sample image message. Use <p class="gkImage">Your image message goes here!</p>.

This is a sample information message. Use <p class="gkInformation">Your information message goes here!</p>.

This is a sample magnifier message. Use <p class="gkMagnifier">Your magnifier message goes here!</p>.

This is a sample money message. Use <p class="gkMoney">Your money goes here!</p>.

This is a sample new message. Use <p class="gkNew">Your new message goes here!</p>.

This is a sample note message. Use <p class="gkNote">Your note message goes here!</p>.

This is a sample page message. Use <p class="gkPage">Your page goes here!</p>.

This is a sample page_white message. Use <p class="gkPage_white">Your page_white message goes here!</p>.

This is a sample plugin message. Use <p class="gkPlugin">Your plugin message goes here!</p>.

This is a sample accept message. Use <p class="gkAccept">Your accept goes here!</p>.

This is a sample add message. Use <p class="gkAdd">Your add message goes here!</p>.

This is a sample camera message. Use <p class="gkCamera">Your camera message goes here!</p>.

This is a sample brick message. Use <p class="gkBrick">Your brick goes here!</p>.

This is a sample box message. Use <p class="gkBox">Your box message goes here!</p>.

This is a sample calendar message. Use <p class="gkCalendar">Your calendar message goes here!</p>.

Icon set 2

This is a sample audio message. Use <p class="gkAudioIs2">Your audio message goes here!</p>.

This is a sample email message. Use <p class="gkEmailIs2">Your email message goes here!</p>.

This is a sample feed message. Use <p class="gkFeedIs2">Your feed message goes here!</p>.

This is a sample images message. Use <p class="gkImagesIs2">Your images message goes here!</p>.

This is a sample lock message. Use <p class="gkLockIs2">Your lock message goes here!</p>.

This is a sample printer message. Use <p class="gkPrinterIs2">Your printer message goes here!</p>.

This is a sample time message. Use <p class="gkTimeIs2">Your time message goes here!</p>.

This is a sample user message. Use <p class="gkUserIs2">Your calendar message goes here!</p>.

This is a sample world message. Use <p class="gkWorldIs2">Your world message goes here!</p>.

YThis is a sample cart message. Use <p class="gkCartIs2">Your cart message goes here!</p>.

This is a sample cd message. Use <p class="gkCdIs2">Your cd message goes here!</p>.

This is a sample chart line message. Use <p class="gkChartLineIs2">Your chart line message goes here!</p>.

This is a sample chart pie message. Use <p class="gkChartPieIs2">Your calendar message goes here!</p>.

This is a sample clock message. Use <p class="gkClockIs2">Your clock message goes here!</p>.

This is a sample config message. Use <p class="gkCogIs2">Your config message goes here!</p>.

This is a sample computer message. Use <p class="gkComputerIs2">Your computer message goes here!</p>.

This is a sample error message. Use <p class="gkErrorIs2">Your error message goes here!</p>.

This is a sample exclamation message. Use <p class="gkExclamationIs2">Your exclamation message goes here!</p>.

This is a sample movie message. Use <p class="gkFilmIs2">Your movie message goes here!</p>.

This is a sample folder message. Use <p class="gkFolderIs2">Your folder message goes here!</p>.

This is a group calendar message. Use <p class="gkGroupIs2">Your group message goes here!</p>.

This is a sample house message. Use <p class="gkHouseIs2">Your house message goes here!</p>.

This is a sample image message. Use <p class="gkImageIs2">Your image message goes here!</p>.

This is a sample information message. Use <p class="gkInfromationIs2">Your information message goes here!</p>.

This is a sample magnifier message. Use <p class="gkMagnifierIs2">Your magnifier message goes here!</p>.

This is a sample money message. Use <p class="gkMoneyIs2">Your money message goes here!</p>.

This is a sample page message. Use <p class="gkPageIs2">Your page message goes here!</p>.

This is a sample camera message. Use <p class="gkCameraIs2">Your camera message goes here!</p>.

This is a calendar feed message. Use <p class="gkCalendarIs2">Your calendar message goes here!</p>.

This is a sample contact message. Use <p class="gkContactIs2">Your contact message goes here!</p>.

This is a sample facebook message. Use <p class="gkFacebookIs2">Your facebook message goes here!</p>.

This is a sample like it message. Use <p class="gkLikeItIs2">Your like it message goes here!</p>.

This is a sample twitter message. Use <p class="gkTwitterIs2">Your twitter message goes here!</p>.

This is a sample video message. Use <p class="gkVideoIs2">Your video message goes here!</p>.

This is a sample youtube message. Use <p class="gkYoutubeIs2">Your youtube message goes here!</p>.

Icon set 3

This is a sample audio message. Use <p class="gkAudioIs3">Your audio message goes here!</p>.

This is a sample camera message. Use <p class="gkCameraIs3">Your camera message goes here!</p>.

This is a sample lock message. Use <p class="gkLockIs3">Your lock message goes here!</p>.

This is a sample user message. Use <p class="gkUserIs3">Your user message goes here!</p>.

This is a sample cart message. Use <p class="gkCartIs3">Your cart message goes here!</p>.

This is a sample chart bar message. Use <p class="gkChartBarIs3">Your chart bar message goes here!</p>.

This is a sample config message. Use <p class="gkConfigIs3">Your config message goes here!</p>.

This is a sample configuration message. Use <p class="gkConfig2Is3">Your configuration message goes here!</p>.

This is a sample computer message. Use <p class="gkComputerIs3">Your computer message goes here!</p>.

This is a sample coffe message. Use <p class="gkCoffeIs3">Your coffe message goes here!</p>.

This is a sample cross message. Use <p class="gkCrossIs3">Your cross message goes here!</p>.

This is a sample error message. Use <p class="gkErrorIs3">Your error message goes here!</p>.

This is a sample house message. Use <p class="gkHouseIs3">Your house message goes here!</p>.

This is a sample information message. Use <p class="gkInformationIs3">Your inforation message goes here!</p>.

This is a sample magnifier message. Use <p class="gkMagnifierIs3">Your magnifier message goes here!</p>.

This is a sample page message. Use <p class="gkPageIs3">Your page message goes here!</p>.

This is a sample lock message. Use <p class="gkLockIs3">Your lock message goes here!</p>.

This is a sample camera message. Use <p class="gkCameraIs3">Your camera message goes here!</p>.

This is a sample star message. Use <p class="gkStarIs3">Your star message goes here!</p>.

This is a sample telephone message. Use <p class="gkTelephoneIs3">Your telephone message goes here!</p>.

Tooltips

Here are some examples of a ClassicThis is just an example of what you can do using a CSS tooltip, feel free to get creative and produce your own!, CriticalCriticalThis is just an example of what you can do using a CSS tooltip, feel free to get creative and produce your own!, HelpHelpThis is just an example of what you can do using a CSS tooltip, feel free to get creative and produce your own!, InformationInformationThis is just an example of what you can do using a CSS tooltip, feel free to get creative and produce your own! and WarningWarningThis is just an example of what you can do using a CSS tooltip, feel free to get creative and produce your own! CSS powered tooltip. This is just an example of what you can do so feel free to get creative and produce your own!

Highlights

This is a highlight phrase. Use <span class="gkHighlight1">Your highlight phrase goes here!</span>.

This is a highlight phrase. Use <span class="gkHighlight2">Your highlight phrase goes here!</span>.

This is a highlight phrase. Use <span class="gkHighlight3">Your highlight phrase goes here!</span>.

This is a highlight phrase. Use <span class="gkHighlight4">Your highlight phrase goes here!</span>.

Code

Below is a sample of <pre> or <div class="gkCode1">

#wrapper {
position: relative;
float: left;
display: block;
}

Below is a sample of <div class="gkCode2">

#wrapper {
position: relative;
float: left;
display: block;
}

Below is a sample of <div class="gkCode3"><h4>Name of your file</h4>Here goes your code</div>



File

#wrapper {
position: relative;
float: left;
display: block;
}

Unordered lists

Types of unordered lists

<ul class="gkBullet1">

  • Element 1
  • Element 2
  • Element 3

<ul class="gkBullet2">

  • Element 1
  • Element 2
  • Element 3

<ul class="gkBullet3">

  • Element 1
  • Element 2
  • Element 3

<ul class="gkBullet4">

  • Element 1
  • Element 2
  • Element 3

<ul class="gkCircle1">

  • Element 1
  • Element 2
  • Element 3

<ul class="gkCircle2">

  • Element 1
  • Element 2
  • Element 3

<ul class="gkSquare1">

  • Element 1
  • Element 2
  • Element 3

<ul class="gkSquare2">

  • Element 1
  • Element 2
  • Element 3

<ul class="gkSquare3">

  • Element 1
  • Element 2
  • Element 3

Ordered lists

Types of ordered list:

<ol class="gkRoman">

  1. Element
  2. Element
  3. Element
  4. Element

<ol class="gkDec">

  1. Element
  2. Element
  3. Element
  4. Element

<ol class="gkAlpha">

  1. Element
  2. Element
  3. Element
  4. Element

<ol class="gkDecimalLeadingZero">

  1. Element
  2. Element
  3. Element
  4. Element

<div class="gkNumber1"><p><span>here goes a number</span>and here text of element</p>

01 Element

02 Element

<div class="gkNumber2"><p><span>here goes a number</span>and here text of element</p>

01 Element

02 Element

Abbrs and acronyms

This is a sample of an abbreviation Dr. Use <abbr title="Here goes full word or phrase">here goes an abbreviation</abbr>

This is a sample of an acronym NATO. Use <acronym title="Here goes full phrase">here goes an acronym</abbr>

Definition lists

Below are samples of definition lists

<dl class="gkDef1"><dt>Here goes the word you're about to define</dt><dd>Here goes definition</dd></dl>

Butter
it is a dairy product made by churning fresh or fermented cream or milk. It is generally used as a spread and a condiment, as well as in cooking applications such as baking, sauce making, and frying. Butter consists of butterfat, water and milk proteins.
Dairy milk
is an opaque white liquid produced by the mammary glands of mammals (including monotremes). It provides the primary source of nutrition for newborn mammals before they are able to digest other types of food.

<dl class="gkDef2"><dt>Here goes the word you're about to define</dt><dd>Here goes definition</dd></dl>

Butter
it is a dairy product made by churning fresh or fermented cream or milk. It is generally used as a spread and a condiment, as well as in cooking applications such as baking, sauce making, and frying. Butter consists of butterfat, water and milk proteins.
Dairy milk
is an opaque white liquid produced by the mammary glands of mammals (including monotremes). It provides the primary source of nutrition for newborn mammals before they are able to digest other types of food.

<dl class="gkDef3"><dt>Here goes the word you're about to define</dt><dd>Here goes definition</dd></dl>

Butter
it is a dairy product made by churning fresh or fermented cream or milk. It is generally used as a spread and a condiment, as well as in cooking applications such as baking, sauce making, and frying. Butter consists of butterfat, water and milk proteins.
Dairy milk
is an opaque white liquid produced by the mammary glands of mammals (including monotremes). It provides the primary source of nutrition for newborn mammals before they are able to digest other types of food.

Legends

Legend

This is a sample legend note. Use <div class="gkLegend1"> <h4> Title </h4> <p>Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Integer urna. Aenean tristique. Fusce a neque. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus.</p> </div>.

Legend

This is a sample legend note. Use <div class="gkLegend2"> <h4> Title </h4> <p>Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Integer urna. Aenean tristique. Fusce a neque. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus.</p> </div>.

Legend

This is a sample legend note. Use <div class="gkLegend3"> <h4> Title </h4> <p>Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Integer urna. Aenean tristique. Fusce a neque. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus.</p> </div>.

Legend

This is a sample legend note. Use <div class="gkLegend4"> <h4> Title </h4> <p>Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Integer urna. Aenean tristique. Fusce a neque. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus.</p> </div>.

Legend

This is a sample legend note. Use <div class="gkLegend5"> <h4> Title </h4> <p>Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Integer urna. Aenean tristique. Fusce a neque. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus.</p> </div>.

Legend

This is a sample legend note. Use <div class="gkLegend6"> <h4> Title </h4> <p>Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Integer urna. Aenean tristique. Fusce a neque. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus.</p> </div>.

Legend

This is a sample legend note. Use <div class="gkLegend7"> <h4> Title </h4> <p>Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Integer urna. Aenean tristique. Fusce a neque. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus.</p> </div>.

Dropcaps

This is a sample text with Dropcap. Use <p> <span class="gkDropcap1">t</span> to make the first letter larger. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Vestibulum condimentum pulvinar justo, sed faucibus ligula feugiat ac. Morbi quis enim nulla, vel congue augue. Duis quis quam sed purus porta eleifend. Vivamus ullamcorper est id libero aliquam ullamcorper. Donec eget dignissim augue. Donec ante felis, aliquam ut consequat eget, lobortis dapibus risus. Aliquam laoreet enim et lectus ornare hendrerit. Aliquam rhoncus enim libero. Morbi aliquam, nibh mattis feugiat dapibus, nisi massa adipiscing justo, sit amet condimentum urna ipsum et lacus. Nam fermentum, eros quis ullamcorper convallis, libero mauris lacinia eros, sed tempus leo lorem vitae purus. Nunc a malesuada felis. Cras ultrices sapien eu nisi elementum non blandit urna sodales. Duis accumsan cursus massa, eu facilisis diam porta ut..</p>.

This is a sample text with Dropcap. Use <p> <span class="gkDropcap2">t</span> to make the first letter larger. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Vestibulum condimentum pulvinar justo, sed faucibus ligula feugiat ac. Morbi quis enim nulla, vel congue augue. Duis quis quam sed purus porta eleifend. Vivamus ullamcorper est id libero aliquam ullamcorper. Donec eget dignissim augue. Donec ante felis, aliquam ut consequat eget, lobortis dapibus risus. Aliquam laoreet enim et lectus ornare hendrerit. Aliquam rhoncus enim libero. Morbi aliquam, nibh mattis feugiat dapibus, nisi massa adipiscing justo, sit amet condimentum urna ipsum et lacus. Nam fermentum, eros quis ullamcorper convallis, libero mauris lacinia eros, sed tempus leo lorem vitae purus. Nunc a malesuada felis. Cras ultrices sapien eu nisi elementum non blandit urna sodales. Duis accumsan cursus massa, eu facilisis diam porta ut..</p>.

This is a sample text with Dropcap. Use <p class="gkDropcap3"> <span class="gkDropcap3">t</span> to make the first letter larger. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Vestibulum condimentum pulvinar justo, sed faucibus ligula feugiat ac. Morbi quis enim nulla, vel congue augue. Duis quis quam sed purus porta eleifend. Vivamus ullamcorper est id libero aliquam ullamcorper. Donec eget dignissim augue. Donec ante felis, aliquam ut consequat eget, lobortis dapibus risus. Aliquam laoreet enim et lectus ornare hendrerit. Aliquam rhoncus enim libero. Morbi aliquam, nibh mattis feugiat dapibus, nisi massa adipiscing justo, sit amet condimentum urna ipsum et lacus. Nam fermentum, eros quis ullamcorper convallis, libero mauris lacinia eros, sed tempus leo lorem vitae purus. Nunc a malesuada felis. Cras ultrices sapien eu nisi elementum non blandit urna sodales. Duis accumsan cursus massa, eu facilisis diam porta ut..</p>.

Floated blocks

Below are samples of text in which part of it is displayed in a separate block

<p> Here goes main part of the text <span class="gkBlockTextLeft">Block of text</span>rest of the text</p>

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Vestibulum condimentum pulvinar justo, sed faucibus ligula feugiat ac. Morbi quis enim nulla, vel congue augue. Duis quis quam sed purus porta eleifend.Lorem ipsum dolor sit amet, consectetur adipiscing elit. Vestibulum condimentum pulvinar justo, sed faucibus ligula feugiat ac. Morbi quis enim nulla, vel congue augue.Donec eget dignissim augue. Donec ante felis, aliquam ut consequat eget, lobortis dapibus risus. Aliquam laoreet enim et lectus ornare hendrerit. Aliquam rhoncus enim libero. Morbi aliquam, nibh mattis feugiat dapibus, nisi massa adipiscing justo, sit amet condimentum urna ipsum et lacus. Nam fermentum, eros quis ullamcorper convallis, libero mauris lacinia eros, sed tempus leo lorem vitae purus. Nunc a malesuada felis. Cras ultrices sapien eu nisi elementum non blandit urna sodales. Duis accumsan cursus massa, eu facilisis diam porta ut. Morbi cursus est vel velit hendrerit dictum.

<p> Here goes main part of the text <span class="gkBlockTextRight">Block of text</span>rest of the text</p>

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Vestibulum condimentum pulvinar justo, sed faucibus ligula feugiat ac. Morbi quis enim nulla, vel congue augue. Duis quis quam sed purus porta eleifend.Lorem ipsum dolor sit amet, consectetur adipiscing elit. Vestibulum condimentum pulvinar justo, sed faucibus ligula feugiat ac. Morbi quis enim nulla, vel congue augue.Donec eget dignissim augue. Donec ante felis, aliquam ut consequat eget, lobortis dapibus risus. Aliquam laoreet enim et lectus ornare hendrerit. Aliquam rhoncus enim libero. Morbi aliquam, nibh mattis feugiat dapibus, nisi massa adipiscing justo, sit amet condimentum urna ipsum et lacus. Nam fermentum, eros quis ullamcorper convallis, libero mauris lacinia eros, sed tempus leo lorem vitae purus. Nunc a malesuada felis. Cras ultrices sapien eu nisi elementum non blandit urna sodales. Duis accumsan cursus massa, eu facilisis diam porta ut. Morbi cursus est vel velit hendrerit dictum.

<p> Here goes main part of the text <span class="gkBlockTextCenter">Block of text</span>rest of the text</p>

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Vestibulum condimentum pulvinar justo, sed faucibus ligula feugiat ac. Morbi quis enim nulla, vel congue augue. Duis quis quam sed purus porta eleifend.Lorem ipsum dolor sit amet, consectetur adipiscing elit. Vestibulum condimentum pulvinar justo, sed faucibus ligula feugiat ac. Morbi quis enim nulla, vel congue augue.Donec eget dignissim augue. Donec ante felis, aliquam ut consequat eget, lobortis dapibus risus. Aliquam laoreet enim et lectus ornare hendrerit. Aliquam rhoncus enim libero. Morbi aliquam, nibh mattis feugiat dapibus, nisi massa adipiscing justo, sit amet condimentum urna ipsum et lacus. Nam fermentum, eros quis ullamcorper convallis, libero mauris lacinia eros, sed tempus leo lorem vitae purus. Nunc a malesuada felis. Cras ultrices sapien eu nisi elementum non blandit urna sodales. Duis accumsan cursus massa, eu facilisis diam porta ut. Morbi cursus est vel velit hendrerit dictum.

Other span blocks

This is a sample pin note. Use <span class="gkClear">Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Integer urna. Aenean tristique. Fusce a neque. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. </span>

This is a sample pin note. Use <span class="gkClear-1">Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Integer urna. Aenean tristique. Fusce a neque. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. </span>

This is a sample pin note. Use <span class="gkClear-2">Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Integer urna. Aenean tristique. Fusce a neque. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. </span>

This is a sample pin note. Use <span class="gkColor">Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Integer urna. Aenean tristique. Fusce a neque. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. </span>

This is a sample pin note. Use <span class="gkColor-1">Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Integer urna. Aenean tristique. Fusce a neque. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. </span>

This is a sample pin note. Use <span class="gkColor-2">Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Integer urna. Aenean tristique. Fusce a neque. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. </span>

This is a sample pin note. Use <span class="gkColor-3">Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Integer urna. Aenean tristique. Fusce a neque. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. </span>

This is a sample pin note. Use <span class="gkColor-4">Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Integer urna. Aenean tristique. Fusce a neque. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. </span>

This is a sample pin note. Use <span class="gkColor-5">Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Integer urna. Aenean tristique. Fusce a neque. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. </span>

This is a sample pin note. Use <span class="gkColor-6">Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Integer urna. Aenean tristique. Fusce a neque. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. </span>

This is a sample pin note. Use <span class="gkColor-7">Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Integer urna. Aenean tristique. Fusce a neque. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. </span>

Blockquotes

This is a sample quote text. Use < blockquote > Your quoted text goes here!< /blockquote >
This is a sample quote text. Use< blockquote><div class="gkBlockquote1"><div> Your quoted text goes here!< /div>< /div>< /blockquote >
This is a sample quote text. Use< blockquote><div class="gkBlockquote2"><div> Your quoted text goes here!< /div>< /div>< /blockquote >
This is a sample quote text. Use< blockquote><div class="gkBlockquote3"><div> Your quoted text goes here!< /div>< /div>< /blockquote >
This is a sample quote text. Use< blockquote><div class="gkBlockquote4"><div> Your quoted text goes here!< /div>< /div>< /blockquote >

Tables

Table Header (thead)
Table Footer (tfoot)
Column 1 Column 2
Cell 3 - part of tbody Cell 4 - part of tbody
Cell 5 - part of tbody Cell 6 - part of tbody
Cell 7 - part of tbody Cell 8 - part of tbody

Table Header (thead)
Table Footer (tfoot)
Column 1 Column 2
Cell 1 - part of tbody Cell 2 - part of tbody
Cell 3 - part of tbody Cell 4 - part of tbody
Cell 5 - part of tbody Cell 6 - part of tbody

 

 

Template additional styles

In order to get the video you have to use code like this:


<a class="gk_video_frame" href="http://www.vimeo.com/16274294" rel="mediabox[720 410]">
    <img src="/images/stories/demo/demo_video_1.png" border="0" alt="Video 1" />
    <span class="gk_vframe">Frame</span> 
    <span class="gk_voverlay">Overlay</span> 
    Watch the video 
</a>

As a href attribute you set the video address. In the rel attribute you can specify the video size. Image element is the thumbnail in the frame.

You can also create a blocks with icons. The structure is always similar - you have to change only second class near gk_block:


<div class="gk_block tablet">
<h3><a href="#">Mobile Ready</a></h3>
<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit. Cras quis erat elit. Donec pretium condimentum</p>
</div>

Available blocks styles with classes:

android

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Cras quis erat elit. Donec pretium condimentum

blackberry

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Cras quis erat elit. Donec pretium condimentum

calendar

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Cras quis erat elit. Donec pretium condimentum

chat

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Cras quis erat elit. Donec pretium condimentum

clock

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Cras quis erat elit. Donec pretium condimentum

cog

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Cras quis erat elit. Donec pretium condimentum

firefox

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Cras quis erat elit. Donec pretium condimentum

info

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Cras quis erat elit. Donec pretium condimentum

mac

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Cras quis erat elit. Donec pretium condimentum

mail

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Cras quis erat elit. Donec pretium condimentum

mobilephone

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Cras quis erat elit. Donec pretium condimentum

phone

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Cras quis erat elit. Donec pretium condimentum

recycledbag

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Cras quis erat elit. Donec pretium condimentum

shoppingcart

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Cras quis erat elit. Donec pretium condimentum

tablet

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Cras quis erat elit. Donec pretium condimentum

user

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Cras quis erat elit. Donec pretium condimentum

Published in Blogs
Read more...
TIP
If you are using the Oracle Gateway in Recital, make sure the Oracle environment (ORACLE_HOME, ORACLE_SID etc.) is set up before starting the Recital Server.  If not, you will see the error ORA-01019.  A call to the Oracle environment setup script can be added to the /etc/init.d/recital script if your Recital Server is set to run on startup.
Published in Blogs
Read more...

RTOS()

Syntax

RTOS( [ <workarea> ] )

Description

The RTOS() function returns all the fields in the current row as a string. The string will begin with the unique row identifier and then the deleted flag, followed by the data in the record. An optional workarea can be specified, otherwise the current workarea will be used

Example

use backup in 0
use accounts in 0
nrecs=reccount()
for i = 1 to nrecs
  if rtos(accounts) != rtos(backup)
     debug("record "+recno()+" don't match")
  endif
next

Published in Blogs
Read more...
 
System Requirements:
  • Minimum memory: 4MB
  • Minimum Diskspace: ~20MB
The Recital Runtime System (RTS) executes the object code generated by the Recital compiler. Object files are read from disk and loaded dynamically into shared memory segments. The advantage of this is that when an application has been loaded and is being run by one user, further users share the same object code in memory. This results in performance gains, reduced memory consumption and also provides a high degree of scalability for Recital applications.
Published in Blogs
Read more...

Many motherboards nowadays have integrated gigabit ethernet that use the Realtek NIC chipset.

The Realtek r8168B network card does not work out of the box in Redhat/Centos 5.3: instead of loading the r8168 driver, modprobe loads the r8169 driver, which is broken as can be seen with ifconfig which shows large amounts of dropped packets. A solution is to download the r8168 driver from the Realtek website and install it using the following steps:

Check whether the built-in driver, r8169.ko (or r8169.o for kernel 2.4.x), is installed.

# lsmod | grep r8169

If it is installed remove it.

# rmmod r8169

Download the R8168B linux driver from here into /root.

Unpack the tarball :

# cd /root
# tar vjxf r8168-8.012.00.tar.bz2

Change to the directory:

# cd r8168-8.012.00

If you are running the target kernel, then you should be able to do :

# make clean modules   
# make install
# depmod -a
# insmod ./src/r8168.ko (or r8168.o in linux kernel 2.4.x)

make sure modprobe knows not to use r8169, and that depmod doesn’t find the r8169 module.

# echo "blacklist r8169" >> /etc/modprobe.d/blacklist
# mv /lib/modules/`uname -r`/kernel/drivers/net/r8169.ko   \ /lib/modules/`uname -r`/kernel/drivers/net/r8169.ko.bak

You can check whether the driver is loaded by using the following commands.

# lsmod | grep r8168
# ifconfig -a

If there is a device name, ethX, shown on the monitor, the linux driver is loaded. Then, you can use the following command to activate it.

# ifconfig ethX up

After this you should not see any more dropped packets reported.

Published in Blogs
Read more...

I am a fan of the previous incarnation of the PlugComputer so I was excited to see that Marvell have unveiled a new PlugComputer dubbed imaginatively "PlugComputer 3.0."

PlugComputer 3.0 Features:

Smaller sleeker design,
More powerful CPU - 2gz Armanda 300 CPU,
120GB 1.8-inch SATA hard drive,
Wifi,
Bluetooth,
10/100/1000 wired Ethernet,
USB 2.0
.
512MB of RAM
512MB of Flash memory


I for one would like to see an additional Ethernet port added to increase application flexibility, for some applications where you are using clustered plugs or even for routing, having multiple Ethernet ports is a must.

Even without multiple ethernet ports, these low power consumption devices really could have a place in SME environments, replacing large cumbersome legacy hardware with compact Linux plug servers.

More information about the PlugComputer can be found here
Published in Blogs
Read more...

Copyright © 2025 Recital Software Inc.

Login

Register

User Registration
or Cancel