replace statement

[whit1950]

I have an SQL Select statement in which I use the replace function to replace any commas in a string field with a semicolon. The statement executes fine in PGAdmin III. When I execute via the UniDac component, I get an error.

Any idea on what the problem might be ?

Thanks

Whit

[AlexP]

Hello,

You should either create a persistent field in design-time or use data type mapping http://www.devart.com/unidac/docs/data_type_mapping.htm to create the required field type.