Android Question How to convert SQL statements in B4A?

bskotu555 · Oct 25, 2024

'cx' and 'zw' are text variables：
strSQL ="SELECT * FROM smt where cxnm='" & cx & "' and zwnm='" & zw & "'"
Cursor = Starter.Mysql_Jdbc.ExecQuery(strSQL)

walt61 · Saturday at 12:30 PM

Similar to https://www.b4x.com/android/forum/t...ified-conditions-a-and-b.163731/#post-1004256 :

B4X:

strSQL ="SELECT * FROM smt where `cxnm`=? and `zwnm`=?"
Cursor = Starter.Mysql_Jdbc.ExecQuery2(strSQL, Array As String(cx, zw))

bskotu555 · Saturday at 4:30 PM

walt61 said:
Similar to https://www.b4x.com/android/forum/t...ified-conditions-a-and-b.163731/#post-1004256 :

B4X:

strSQL ="SELECT * FROM smt where `cxnm`=? and `zwnm`=?" Cursor = Starter.Mysql_Jdbc.ExecQuery2(strSQL, Array As String(cx, zw))

The statement is incorrect here. The symbols' and ',' and 'should be placed next to each other

walt61 · Sunday at 6:30 AM

Did you use backticks or single quotes? They're not the same character!

bskotu555 · Sunday at 11:05 AM

walt61 said:
Did you use backticks or single quotes? They're not the same character!

I put these two sentences into the program, but it just reported an error. What's the situation?

aeric · Sunday at 1:51 PM

bskotu555 said:
View attachment 158030
I put these two sentences into the program, but it just reported an error. What's the situation?

If your column names are English word without blank spaces, then you don't need to escape them with back ticks.
Just write like this will do:

B4X:

Dim strSQL As String = "SELECT * FROM smt WHERE cxnm = ? AND zwnm = ?"

walt61 · Sunday at 3:09 PM

aeric said:
If your column names are English word without blank spaces, then you don't need to escape them with back ticks.

You are of course absolutely right. I make it a habit of using backticks for column and table names: then, I don't have to worry about them being reserved words or containing special characters.

walt61 · Sunday at 3:10 PM

bskotu555 said:
View attachment 158030
I put these two sentences into the program, but it just reported an error. What's the situation?

You have a NullPointerException. Possibly, your Mysql_Jdbc has not been initialised.

bskotu555 · Monday at 12:50 AM

I made a low-level mistake: the SMT database does not exist, I replaced it with a program, and after making the necessary changes, it will be fine.

walt61 said:
You have a NullPointerException. Possibly, your Mysql_Jdbc has not been initialised.

Android Question How to convert SQL statements in B4A?

bskotu555

Member

walt61

Active Member

bskotu555

Member

walt61

Active Member

bskotu555

Member

aeric

Expert

walt61

Active Member

walt61

Active Member

bskotu555

Member

Similar Threads

Android Question How to convert SQL statements in B4A?

Member

Active Member

Member

Active Member

Member

Expert

Active Member

Active Member

Member

Similar Threads

Privacy & Transparency

Privacy & Transparency