Android Question Smartstring with ExecQuery (which is actually an ExecQuery2)

JonnyCav

Member
Here's the code and I understand that in a normal ExecQuery2 there would be a " before the word Array. I have had to revert to smartstring because ' space underscore' doesn't seem to work.
I keep getting errors regarding quotation marks however I try.

Can anyone spot the mistake?
B4X: 
Dim query As String =$"
    SELECT attendance.groupName, attendance.studentName, studenttotalattendance.attendCount, studenttotalscore.scoreCount
    FROM attendance
    JOIN studenttotalattendance
    ON attendance.studentID = studenttotalattendance.studentID
    JOIN studenttotalscore
    ON attendance.studentID = studenttotalscore.studentID
    WHERE studenttotalattendance.classPeriod = ? AND studenttotalattendance.classYear= ?,Array As String(period,AcYear))
    "$
    rs = Starter.sql.ExecQuery(query)
 
Solution
M
JonnyCav said:
Can anyone spot the mistake?
Click to expand...
Should be:
B4X: 
dim query As String =$"
    SELECT attendance.groupName, attendance.studentName, studenttotalattendance.attendCount, studenttotalscore.scoreCount
    FROM attendance
    JOIN studenttotalattendance
    ON attendance.studentID = studenttotalattendance.studentID
    JOIN studenttotalscore
    ON attendance.studentID = studenttotalscore.studentID
    WHERE studenttotalattendance.classPeriod = ? AND studenttotalattendance.classYear= ?
    "$
 rs = Starter.sql.ExecQuery2(query,Array As String(period,AcYear))
Sort by date Sort by votes
M

Mahares

Expert
Licensed User
Longtime User
JonnyCav said:
Can anyone spot the mistake?
Click to expand...
Should be:
B4X: 
dim query As String =$"
    SELECT attendance.groupName, attendance.studentName, studenttotalattendance.attendCount, studenttotalscore.scoreCount
    FROM attendance
    JOIN studenttotalattendance
    ON attendance.studentID = studenttotalattendance.studentID
    JOIN studenttotalscore
    ON attendance.studentID = studenttotalscore.studentID
    WHERE studenttotalattendance.classPeriod = ? AND studenttotalattendance.classYear= ?
    "$
 rs = Starter.sql.ExecQuery2(query,Array As String(period,AcYear))
 
Upvote 1
Solution
You must log in or register to reply here.

Similar Threads

  • Question
Android Question sqlite UPDATE
Replies
5
Views
912
JonnyCav
  • Question
Android Question CLV in XUI.CreatePanel appending data, not loading a new Panel
Replies
2
Views
760
JonnyCav
  • Locked
  • Sticky
  • Article
Android Tutorial [B4X] "Code Smells" - common mistakes and other tips
2 3
Replies
43
Views
90K
Erel
  • Locked
  • Article
B4A Library [B4X] B4XTable - Cross platform, sortable, searchable, customizable table
2
Replies
28
Views
61K
Erel
  • Locked
  • Article
Android Tutorial SQL tutorial
7 8 9
Replies
161
Views
285K
luciano deri
Menu
Log in
Register
Cookies are required to use this site. You must accept them to continue using the site. Learn more…