Android Question string literals and single quotes

RB Smissaert · Nov 21, 2021

Have a string variable (strObject, will be a table or a view) that needs to be enclosed in single quotes:

B4X:

strSQL = $"select ObjectType, ObjectName, ColumnName, Affinity, ColumnID
 from SysColumns where ObjectName = ${Chr(39) & strObject & Chr(39)}
 order by ColumnID asc"$

(In this particular Sub using a parameter SQL will be incovenient.)

Can I do this by putting in the ' character directly, rather than using Chr(39)?

RBS

Mahares · Nov 21, 2021

B4X:

$"select ObjectType, ObjectName, ColumnName, Affinity, ColumnID
 from SysColumns where ObjectName ='${strObject}'"$

Erel · Nov 21, 2021

Correct solution is to use parameterized queries.

Mahares · Nov 21, 2021

Erel said:
Correct solution is to use parameterized queries.

That is precisely what I was going to suggest, but OP explicitly does not want a parameterized query. I don't know sometimes whether to impose what I think the correct way or simply respond with the OP wishes in mind.

RB Smissaert · Nov 21, 2021

Mahares said:

B4X:

$"select ObjectType, ObjectName, ColumnName, Affinity, ColumnID
 from SysColumns where ObjectName ='${strObject}'"$

Did you notice the order clause? Your solution uses a different SQL.

RBS

RB Smissaert · Nov 21, 2021

Erel said:
Correct solution is to use parameterized queries.

As said, am aware of that, but it would mean extra lines of code.
I should have given an example not involving SQL, to avoid this confusion.

RBS

Mahares · Nov 21, 2021

RB Smissaert said:
Did you notice the order clause? Your solution uses a different SQL.

The emphasis was on the single quote. You have worked long enough with SQLite to know where to add the ORDER clause.

B4X:

$"select ObjectType, ObjectName, ColumnName, Affinity, ColumnID
 from SysColumns where ObjectName ='${strObject}'  order by ColumnID"$

or even this although the first is preferred:

B4X:

$"select ObjectType, ObjectName, ColumnName, Affinity, ColumnID
 from SysColumns where ObjectName ='${strObject}' "$ & " order by ColumnID"

Unfortunately, your nitpicking always gets in your way.

RB Smissaert · Nov 21, 2021

Mahares said:
The emphasis was on the single quote. You have worked long enough with SQLite to know where to add the ORDER clause.

B4X:

$"select ObjectType, ObjectName, ColumnName, Affinity, ColumnID from SysColumns where ObjectName ='${strObject}' order by ColumnID"$

or even this although the first is preferred:

B4X:

$"select ObjectType, ObjectName, ColumnName, Affinity, ColumnID from SysColumns where ObjectName ='${strObject}' "$ & " order by ColumnID"

Unfortunately, your nitpicking always gets in your way.

>> Unfortunately, your nitpicking always gets in your way.

??? I am not familiar with these smart string literals and it was not directly obvious to me.
It is somewhat confusing how the $, the { and the "" exactly work.
No idea how you came to the conclusion I always nitpick.

RBS

Android Question string literals and single quotes

RB Smissaert

Well-Known Member

Mahares

Expert

Erel

B4X founder

Mahares

Expert

RB Smissaert

Well-Known Member

RB Smissaert

Well-Known Member

Mahares

Expert

RB Smissaert

Well-Known Member

Similar Threads

Android Question string literals and single quotes

Well-Known Member

Expert

B4X founder

Expert

Well-Known Member

Well-Known Member

Expert

Well-Known Member

Similar Threads

Privacy & Transparency

Privacy & Transparency