Bug? Strange error reporting B4J 7 Beta

Star-Dust

Expert
Licensed User
Longtime User
I wrote this code that queries an online database using the resumable SUb.
It works properly
B4X:
Dim Query As String = $"SELECT * FROM ${TabellaMovimenti} WHERE (Data>='${DaDt}' AND Data<='${ADt}' AND Conto=${Conto})"$
'Load from DB
Wait For (PHP.ReadMov(Query)) Complete (Lista As List)

Then I wanted to replace the variable Query with the string ... and doing so tells me error
B4X:
'Load from DB
Wait For (PHP.ReadMov($"SELECT * FROM ${TabellaMovimenti} WHERE (Data>='${DaDt}' AND Data<='${ADt}' AND Conto=${Conto})"$)) Complete (Lista As List)
Syntax error

Now I put the Query variable back on, but I'm wondering why.
 

JohnC

Expert
Licensed User
Longtime User
Try removing all the "$" before and after the quotes.
 

Star-Dust

Expert
Licensed User
Longtime User

Star-Dust

Expert
Licensed User
Longtime User
I already use 7.00 and I have this error
 

Star-Dust

Expert
Licensed User
Longtime User
Ok, Thank's
 

Star-Dust

Expert
Licensed User
Longtime User
With B4J 7 Beta#2

The problem that small string literal did not accept was solved, but WAIT FOR does not work now.

Inserting the String (Smart String Literal) in the Query variable everything works fine
upload_2018-12-24_13-2-23.png


but if I insert the smart string literal in Wait For ...
B4X:
Wait For (PHP.ReadQuery($"SELECT SUM(Dare) AS value_sum1, SUM(Avere) AS value_sum2 FROM ${TabellaMovimenti} WHERE (Data<'${DaDt}' AND Conto=${Conto} AND Sottoconto=${Sottoconto})"$,Array As String("value_sum1","value_sum2"))) Complete (SUM As List)

The SUM List is marked in red as if there was an error, but debugging does not report an error
upload_2018-12-24_13-8-21.png


but if I send it running everything works fine
 

Star-Dust

Expert
Licensed User
Longtime User
Here you find an example where the SUM variable is marked red as if it were in error
 

Attachments

  • SampleError.zip
    1.2 KB · Views: 288

Star-Dust

Expert
Licensed User
Longtime User
Yes, Work fine
 

Star-Dust

Expert
Licensed User
Longtime User
:(
 
Top