Kbase P7644: Is it possible to use the PRO_ELEMENT function with MS SQL DataServer?
Autor |
  Progress Software Corporation - Progress |
Acesso |
  Público |
Publicação |
  10/15/2008 |
|
Status: Verified
GOAL:
Is it possible to use the PRO_ELEMENT function with MS SQL DataServer?
FACT(s) (Environment):
MS SQL DataServer
FIX:
PRO_ELEMENT function is used to access array fields.
The syntax is pro_element(<arrayfieldname>,1,1) for the first element,
pro_element(<arrayfieldname>,2,1) for the second, and so forth.
This function applies only for Progress SQL-92 - NOT for MS SQL DataServer.
It cannot be used when connecting to MS SQL Server using MS SQL server dataserver.