Android Question Concatenation of two field names in query

teddybear

Well-Known Member

Licensed User

• Nov 17, 2024

• #2

Which database are you using?

 

Upvote 0

P

PaulMeuris

Well-Known Member

Licensed User

• Nov 17, 2024

• #3

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

 

Upvote 0

klaus

Expert

Licensed User

Longtime User

• Nov 17, 2024

• #4

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.

 

Upvote 1

P

Pahbie

Member

Licensed User

Longtime User

• Nov 19, 2024

• #5

Here is my code:

pm.Initialize(Activity)

cur = Starter.sql.ExecQuery("select * from person")

cur.position=0

Activity.Title=cur.GetString("lstname")
-----------------------------------
I can not display the lastname from the SELECT query but no more. i cannot figure out how to combine the use of the FIRSTNAME field in the query or the output

 

Upvote 0

Daestrum

Expert

Licensed User

Longtime User

• Nov 19, 2024

• #6

What are the field names in the database table? It would make it easier for people to answer with a proper example if they knew the names.

 

Upvote 0

klaus

Expert

Licensed User

Longtime User

• Nov 19, 2024

• #7

You need to give more details on what exactly you want to do.
Why do you use ?

B4X:

cur = Starter.sql.ExecQuery("select * from person")

And not ?

B4X:

curs = Starter.sql.ExecQuery("SELECT FirstName || '  /  ' || LastName As FullName from person"

You must, of course, adapt the column names and the table name to your application.

Or, as already suggested, post your project or better a small project showing the problem.
So we can see what you have done and how.

 

Upvote 0