Advantage OleDb functions

<< Click to Display Table of Contents >>

Navigation:  The Vo2Ado RDD > Appendices >

Advantage OleDb functions

Previous pageReturn to chapter overviewNext page

Below is a (incomplete) list of VO functions and their translations for the Advantage OleDb Provider. These functions are also built into the RDD

If you find a missing function that you use in your applications, please let us know, so we can add the function to our list

 

 

VO Function

 

SQL Function

 

 

STR(%1%,%2%,%3%)

 

RIGHT(SPACE(%2%) + LTRIM(CONVERT( ROUND( %1%,%3%),SQL_VARCHAR)),%2%) (*)

 

SUBSTR(%1%,%2%,%3%)

 

SUBSTRING(%1%,%2%,%3%)

 

LEFT(%1%,%2%)

 

LEFT(%1%,1,%2%)

 

DTOS(%1%)

 

CONVERT(YEAR(%1%),SQL_VARCHAR)+ RIGHT('0'+CONVERT(MONTH(%1%),SQL_VARCHAR),2} + RIGHT('0'+CONVERT(DAYOFMONTH(%1%),SQL_VARCHAR),2)

 

IIF(%1%,%2%,%3%)

 

** NOT SUPPORTED AS FAR AS WE KNOW **

 

UPPER(%1%)

 

UCASE(%1%)

 

LOWER(%1%)

 

LCASE(%1%)

 

TODAY()

 

CURDATE()

 

DAY(%1%)

 

DAYOFMONTH(%1%)

 

MONTH(%1%)

 

MONTH(%1%)

 

YEAR(%1%)

 

YEAR(%1%)

 

CHR(%1%)

 

CHAR(%1%)

 

REPL(%1%,%2%)

 

REPEAT(%1%,%2%)

 

LEN(%1%)        

 

LENGTH(%1%)

 

ASC(%1%)

 

ASCII(%1%)

 

TRIM(%1%)

 

RTRIM(%1%)

 

LTRIM(%1%)

 

LTRIM(%1%)

 

RTRIM(%1%)

 

RTRIM(%1%)

 

ALLTRIM(%1%)

 

LTRIM(RTRIM(%1%))

 

+

 

+

 

(*)  The result may be dependant on your windows number format setting