Consultor Eletrônico



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.