Page 1 of 1

replace statement

Posted: Wed 19 Feb 2014 16:13
by 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

Re: replace statement

Posted: Thu 20 Feb 2014 15:06
by 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.