[Resolved] SC_CONCAT macro missing in SC6??

Applications Forms
#1

I cannot use sc_concat anymore in SC6, why???
Where are youuuuuuuuuuuu sc_concat???

http://imageshack.us/photo/my-images/59/lookupy.jpg

Pls answer that.
Thanks.

#2

Re: SC_CONCAT macro missing in SC6??

I might be confused, but if you’re using mysql then you can use the mysql concatenate function.

Alan

#3

Re: SC_CONCAT macro missing in SC6??

That’s right, but with sc_concat you are able to change later database easily, because SC then uses another internal syntax which is quite different between oracle and mysql

Regards
Uwe

#4

Re: SC_CONCAT macro missing in SC6??

Ok, thanks for the info.
Alan

#5

Re: SC_CONCAT macro missing in SC6??

Hello,

What happened when you tried to use sc_concat? Try the syntax below:


SELECT sc_concat(someField, ' - ', otherField)
FROM myTable
WHERE someID = '{someID}'

regards,
Bernhard Bernsmann

#6

Re: SC_CONCAT macro missing in SC6??

sc_concat function not found or something like that, i do not have SC here…