Problem Adding SQL Commands to Repository

[ganjass]

CR10
CE10
Progress 9.1D

Hi ALL,

I'm having a problem adding some SQL commands to the CE10 Repository. They are based the following :


{fn convert(pro_element("si-alpha",2,2), SQL_CHAR)}


These are used to split out array field values for the merant driver, which can't handle array fields. When parsing the formula in CR10, no error, and they function as they should. When trying to add These Through the DataSource and Add Commands i get an error message :

[Progress] Syntax error (7587)

Any ideas, i can pass simple SQL Queries, but i really want to add these to the repository as they are used a lot

Thanks in advance