B4J Question Using dbutils

[kelvo01]

How to execute a query. obtain some rows of results and parse field results?

...
ExecuteMemoryTable( selet *fom

Do While NOT EOF ...
Loop

the exact code ? an example ?

 

[DonManfred]

https://www.b4x.com/android/forum/threads/sql-tutorial.35185/

The forumsearch is working btw... i´m pretty sure there are plenty of examples if you just would use the search.
Also look at Klaus Booklets. They include SQL Parts too.
https://www.b4x.com/b4a.html#documentation
https://www.b4x.com/b4j.html#documentation

 

[kelvo01]

A mean a short way to make this with dbutils 2

cerca="SELECT MVNUMDOC, MVALFDOC, MVDATDOC, MVTIPDOC, MVCODMAG, CLCODCLI, CLRAGSOC, MVTOTDOC "
    cerca=cerca&" FROM MOVIME LEFT JOIN CLIFOR ON MVCOD_CF = CLCODCLI "
    cerca=cerca&" WHERE MVTIPDOC='DT' AND MVTPCLFO='1' AND MV__ANNO='2019' "
    cerca=cerca&" ORDER BY MVALFDOC, MVNUMDOC "'limit 100 "
    
    Dim rs As ResultSet

    rs = gSQL.ExecQuery(cerca)
    Do While rs.NextRow
        Log(rs.GetString("MVALFDOC"))
    Loop
    rs.Close

 

[DonManfred]

Use ExecQuery2 and SmartStringLiteral. This will make it much easier to build the query.

 

[universengo]

A mean a short way to make this with dbutils 2

cerca="SELECT MVNUMDOC, MVALFDOC, MVDATDOC, MVTIPDOC, MVCODMAG, CLCODCLI, CLRAGSOC, MVTOTDOC "
    cerca=cerca&" FROM MOVIME LEFT JOIN CLIFOR ON MVCOD_CF = CLCODCLI "
    cerca=cerca&" WHERE MVTIPDOC='DT' AND MVTPCLFO='1' AND MV__ANNO='2019' "
    cerca=cerca&" ORDER BY MVALFDOC, MVNUMDOC "'limit 100 "
   
    Dim rs As ResultSet

    rs = gSQL.ExecQuery(cerca)
    Do While rs.NextRow
        Log(rs.GetString("MVALFDOC"))
    Loop
    rs.Close

You can replace the "cerca=cerca&" by using "& _" as below

cerca="SELECT MVNUMDOC, MVALFDOC, MVDATDOC, MVTIPDOC, MVCODMAG, CLCODCLI, CLRAGSOC, MVTOTDOC " & _
   " FROM MOVIME LEFT JOIN CLIFOR ON MVCOD_CF = CLCODCLI " & _
   " WHERE MVTIPDOC='DT' AND MVTPCLFO='1' AND MV__ANNO='2019' " & _
   " ORDER BY MVALFDOC, MVNUMDOC "'limit 100 "

 

[Erel]

Better like this:

cerca=$"SELECT MVNUMDOC, MVALFDOC, MVDATDOC, MVTIPDOC, MVCODMAG, CLCODCLI, CLRAGSOC, MVTOTDOC 
   FROM MOVIME LEFT JOIN CLIFOR ON MVCOD_CF = CLCODCLI 
   WHERE MVTIPDOC='DT' AND MVTPCLFO='1' AND MV__ANNO='2019'
   ORDER BY MVALFDOC, MVNUMDOC"$