Query Builder replacement for SQL STRING() function

Classic Servoy
1

Hi All

I wish everyone a happy new year and a good and successful 2018!

I am looking to translate the following SQL statement and can’t find the STRING() function replacement in the Servoy Query Builder:

var query = "\
		SELECT\
			id,\
			STRING('i18n:', name)\
		FROM\
			menus\
		WHERE\
			menu_id IS NULL";

Best regards,

2

Without knowing the STRING() function (what database is this??), it looks like you are looking for the concat function…

3

patrick:
Without knowing the STRING() function (what database is this??), it looks like you are looking for the concat function…

The database is SAP SQL Anywhere 17 (once used by Servoy as default database .-) I tried with concat, but I did not find out how to concat a fixed text like ‘i18n’, followed by a database column name (in my case called name). Any idea?

Regards, Robert

4

How about:

q.result.add(q.functions.concat('i18n:', q.columns.name));
5

Patrick, exactly what I was looking for! Thanks.

patrick:
How about:

q.result.add(q.functions.concat('i18n:', q.columns.name));

Best regards,