About the Easysoft ODBC-SugarCRM Driver

The Easysoft ODBC-SugarCRM Driver provides real-time access to SugarCRM data from any application that supports ODBC.

ODBC API and scalar functions

API functions

Use this table to find out what ODBC API functions the Easysoft ODBC-SugarCRM Driver supports:

Function Status

SQLAllocConnect

Supported

SQLAllocEnv

Supported

SQLAllocHandle

Supported

SQLAllocStmt

Supported

SQLBindCol

Supported

SQLBindParameter

Supported

SQLBrowseConnect

Not supported

SQLBulkOperations

Supported

SQLCancel

Supported

SQLCloseCursor

Supported

SQLColAttribute

Supported

SQLColAttributes

Supported

SQLColumnPrivileges

Not supported

SQLColumns

Supported

SQLConnect

Supported

SQLCopyDesc

Supported

SQLDisconnect

Supported

SQLDriverConnect

Supported

SQLDrivers

Supported

SQLEndTran

Supported

SQLError

Supported

SQLExecDirect

Supported

SQLExecute

Supported

SQLExtendedFetch

Supported

SQLFetch

Supported

SQLFetchScroll

Supported

SQLForeignKeys

Supported

SQLFreeConnect

Supported

SQLFreeEnv

Supported

SQLFreeHandle

Supported

SQLFreeStmt

Supported

SQLGetConnectAtt

Supported

SQLGetConnectOption

Supported

SQLGetCursorName

Supported

SQLGetData

Supported

SQLGetDescField

Supported

SQLGetDescRec

Supported

SQLGetDiagField

Supported

SQLGetDiagRec

Supported

SQLGetEnvAttr

Supported

SQLGetFunctions

Supported

SQLGetInfo

Supported

SQLGetStmtAttr

Supported

SQLGetStmtOption

Supported

SQLGetTypeInfo

Supported

SQLMoreResults

Supported

SQLNativeSql

Supported

SQLNumParams

Supported

SQLNumResultCols

Supported

SQLParamData

Supported

SQLParamOptions

Supported

SQLPrepare

Supported

SQLPrimaryKeys

Supported

SQLProcedureColumns

Supported

SQLProcedures

Supported

SQLPutData

Supported

SQLRowCount

Supported

SQLSetConnectAttr

Supported

SQLSetConnectOption

Supported

SQLSetCursorName

Supported

SQLSetDescField

Supported

SQLSetDescRec

Supported

SQLSetEnvAttr

Supported

SQLSetParam

Supported

SQLSetPos

Not supported

SQLSetScrollOptions

Not supported

SQLSetStmtOption

Supported

SQLSetStmtAttr

Supported

SQLStatistics

Supported

SQLTablePrivileges

Not supported

SQLTables

Supported

SQLTransact

Supported

Scalar functions

The Easysoft ODBC-SugarCRM Driver supports a number of scalar functions:

Use either the SQL-92 or ODBC syntax with scalar functions. For example:

SELECT
  Invoice_Id,
  Customer_Name,
  EXTRACT(YEAR FROM Due_Date) as "Year"
FROM
  Invoice

SELECT
  Invoice_Id,
  Customer_Name,
  {fn EXTRACT(YEAR FROM Due_Date)} as "Year"
FROM
  Invoice

String functions

The Easysoft ODBC-SugarCRM Driver supports these string functions:

  • ASCII(string_exp)

  • BIT_LENGTH(string_exp)

  • CHAR(code)

  • CHAR_LENGTH(string_exp)

  • CHARACTER_LENGTH(string_exp)`

  • CONCAT(string_exp1, string_exp2)

  • DIFFERENCE(string_exp1, string_exp2)

  • INSERT(string_exp1, start, length, string_exp2)

  • LCASE(string_exp)

  • LEFT(string_exp, count)

  • LENGTH(string_exp)

  • LOCATE(string_exp1, string_exp2[,start])

  • LTRIM(string_exp)

  • OCTET_LENGTH(string_exp)

  • POSITION(char_exp IN char_exp)

  • REPEAT(string_exp, count)

  • REPLACE(string_exp1, string_exp2, string_exp3)

  • RIGHT(string_exp, count)

  • RTRIM(string_exp)

  • SOUNDEX(string_exp)

  • SPACE(count)

  • SUBSTRING(string_exp, start, length)

  • TRIM(string_exp)`

  • UCASE(string_exp)

Numeric functions

The Easysoft ODBC-SugarCRM Driver supports these numeric functions:

  • ABS(numeric_exp)

  • ACOS(float_exp)

  • ASIN(float_exp)

  • ATAN(float_exp)

  • ATAN2(float_exp1, float_exp2)

  • CEILING(numeric_exp)

  • COS(float_exp)

  • COT(float_exp)

  • DEGREES(numeric_exp)

  • EXP(float_exp)

  • FLOOR(numeric_exp)

  • LOG(float_exp)

  • LOG10(float_exp)

  • MOD(integer_exp1, integer_exp2)

  • PI()

  • POWER(numeric_exp, integer_exp)

  • RADIANS(numeric_exp)

  • RAND([integer_exp])

  • ROUND(numeric_exp, integer_exp)

  • SIGN(numeric_exp)

  • SIN(float_exp)

  • SQRT(float_exp)

  • TAN(float_exp)

  • TRUNCATE(numeric_exp, integer_exp)

Time, date, and interval functions

The Easysoft ODBC-SugarCRM Driver supports these time, date, and interval functions:

  • CURRENT_DATE()

  • CURRENT_TIME[(time-precision)]

  • CURRENT_TIMESTAMP[(timestamp-precision)]

  • CURDATE()

  • CURTIME()

  • DAYNAME(date_exp)

  • DAYOFMONTH(date_exp)

  • DAYOFWEEK(date_exp)

  • DAYOFYEAR(date_exp)

  • EXTRACT(extract-field FROM extract-source)

  • HOUR(time_exp)

  • MINUTE(time_exp)

  • MONTH(date_exp)

  • MONTHNAME(date_exp)

  • `NOW()

  • QUARTER(date_exp)

  • SECOND(time_exp)

  • TIMESTAMPADD(interval, integer_exp, timestamp_exp)

  • TIMESTAMPDIFF(interval, timestamp_exp1, timestamp_exp2)

  • WEEK(date_exp)

  • YEAR(date_exp)

System functions

The Easysoft ODBC-SugarCRM Driver supports these system functions:

  • DATABASE()

  • IFNULL(exp, value)

  • USER()

Conversion functions

The Easysoft ODBC-SugarCRM Driver supports supports both the SQL-92 CAST function and the ODBC CONVERT function for conversion between compatible data types.

SQL support

The Easysoft ODBC-SugarCRM Driver supports these SQL statements, clauses, and operators:

  • SELECT

  • SELECT DISTINCT

  • WHERE

  • ORDER BY

  • AND

  • OR

  • NOT

  • INSERT INTO

  • NULL

  • UPDATE

  • DELETE

  • FIRST

  • MIN

  • MAX

  • COUNT

  • SUM

  • AVG

  • LIKE

  • WILDCARDS

  • IN

  • BETWEEN

  • ALIASES

  • JOINS

  • UNION

  • GROUP BY

  • HAVING

  • EXISTS

  • CASE