fn CONCAT

Discussion of open issues, suggestions and bugs regarding UniDAC (Universal Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
jlund
Posts: 22
Joined: Wed 17 Nov 2004 18:50

fn CONCAT

Post by jlund » Mon 20 Jul 2009 14:48

Hi

I am converting to UniDAC, and now i get a problem with my CONCAT statement.

The statement {fn CONCAT("Field 1",' ',"Field 2")}
results in CONCAT(`Field 1`, ')

and {fn CONCAT("Field 1","Field 2")}
results in CONCAT(`Field 1`, Field 2`)

Both are wrong

Please help
TIA Jens Lund

Challenger
Devart Team
Posts: 925
Joined: Thu 17 Nov 2005 10:53

Post by Challenger » Tue 21 Jul 2009 10:28

The CONCAT function supports only two paremeters. We have fixed the problem with missing first character of the second parameter. As a workaround you can add a space char just after comma:

Code: Select all

{fn CONCAT("Field 1", "Field 2")}

jlund
Posts: 22
Joined: Wed 17 Nov 2004 18:50

Thanks

Post by jlund » Tue 21 Jul 2009 10:38

Thank you very much.

Any ETA on the new version ?

/Jens Lund

Challenger
Devart Team
Posts: 925
Joined: Thu 17 Nov 2005 10:53

Post by Challenger » Fri 24 Jul 2009 13:02

We are planning to release the new builв in UniDAC in a week.

Post Reply