Android Question Concatenation of two field names in query

Pahbie · 2024-11-17T06:22:11+0000

Apologies if asked already.

i am trying to display the first and last names from a table and cannot figure out how to concatenate the two fields in a query
Prolly very simple but I am stumped!

I tried getstring but cannot seem to be able to concatenate both firstname and lastname. i've tried the & and + operators to no avail.

teddybear · 2024-11-17T06:53:03+0000

Which database are you using?

PaulMeuris · 2024-11-17T07:44:53+0000

Results from a Google search:
SQLite concat
MySQL concat
The operator you were looking for is the || operator.

klaus · 2024-11-17T08:30:32+0000

For SQLite you may have a look HERE.
Instead of using this:

B4X:

Query = "SELECT FirstName, LastName, City FROM persons"
ResultSet1.GetString("FirstName") & "  /  " & ResultSet1.GetString("LastName")

You could use this:

B4X:

Query = "SELECT FirstName || '  /  ' || LastName As FullName"
ResultSet1.GetString("FullName")

Do not worry about the colors above. The single quotes are not a comment.

Android Question Concatenation of two field names in query

Pahbie

Member

teddybear

Well-Known Member

PaulMeuris

Active Member

klaus

Expert

Similar Threads

Android Question Concatenation of two field names in query

Pahbie

Member

teddybear

Well-Known Member

PaulMeuris

Active Member

klaus

Expert

Similar Threads

Privacy & Transparency

Privacy & Transparency