Search Results

Hello my friends, I use MSMySQL lib from @DonManfred. I use a for-loop to get about 10 Async...) startDate=dateList.Get(i) Main.db.QueryASync("SELECT...
link: Or you can use the new wait for feature and wait for the result inside the loop......
link: (i) Main.db.QueryASync("SELECT astynomikos.agms, convert(cast(convert(ypiresies_db.ypiresia using...
link: . Main.db.QueryASync("SELECT astynomikos.agms, convert(cast(convert(ypiresies_db.ypiresia using...

maybe i was wrong :) class mySQL Sub Class_Globals Public mySQL As SD_SQL Private... this method if needed. Public Sub Initialize(CallbackModule As Object, EventName As String) mySQL...
link: Hello, I have Android tablet and Android Pos Sunmi V2 wich work on same sql server, Andorid tablet...
link: Thank's Erel! I learn about Rpi an JRDC2 May be!! ----> The difference is in the Mariadb dri...
link: I cant find the code portability between B4J and B4A. B4A JdbcSQL = B4J jSQL. Same library...

Exactly, my code is combination of great Erel's example....
link: There is a timeout set to 30 seconds here, when connection is failed Success is false. you can test...
link: Maybe this post can help Post in thread ' WaitForWithTimeout --> TimeoutHandler' https:...
link: As ResumableSub MSQL.InitializeAsync("mssql", driver, jdbcUrl, Username, Password) TimeoutImpl...

Honestly you should always use the Async methods. Edit: Especially when working with a Remote-Database....
link: use the async methods....
link: Hello! I can't find an async version of ExecQuerySingleResult. Should I use ExecQueryAsync...

Hi, Search the forum I can not find what I need. I like to use ExeCQueryAsync. Now I miss the option to also make use of a Taskid. This is not possible here or I miss something. SQLRespond_querycomplete(Success As Boolean, RS As ResultSet) Something like this SQLDB.ExecQueryAsync("SQLRespond...
link: Stupid off me have not think off this. Many thanks Erel...
link: Currently there is no task id. As a workaround you can add a "dummy" column to the query and use it as the query id. Somet...

with that but in the tooltip for execQueryAsync there is an example passing a Null value. public Sub fillCmb(query As String,params() As String,cmb As ComboBox) Dim sf As Object = sql.ExecQueryAsync...
link: The reason that it doesn't happen in jRDC2 is that when you initialize DBCommand the parameters ...
link: lol you are right! return ExecQuery2(Query, null); all the queries are executed from here and it ...
link: weird. The kicker is that in the source of the SQL library (https://github.com/AnywhereSoftware/B4J_SQL...

switch to SQL.ExecQueryAsync: Dim SenderFilter As Object = sql.ExecQueryAsync("SQL".... The new standard way to insert data is: For i = 1 To 1000 sql.AddNonQueryToBatch("INSERT INTO table1 VALUES (?)", Array(Rnd(0, 100000))) Next Dim SenderFilter As Object = sql.ExecNonQueryBatch("SQL") Wait For (SenderFilter) SQL_NonQueryComplete (Success As Boolean) Log...
link: You don't need the "SenderFilter" parameter with InitializeAsync. sql1...

Use JdbcSQL: https://www.b4x.com/android/forum/threads/jdbcsql-directly-connect-to-remote-databases.84016/#content...
link: the referenced links provided. But looking at the Library Reference folder in B4A, I can only see SQL...
link: Please note, that the library in B4A is now included and is called jSQL. Previously...
link: . I followed the video on JRDBC2 on mySQL by Erel but am lost on applying it to MSSQL example Thanks....

How can you write a Resumable Sub that returns 2 values, just like ExecQueryAsync? I always see Resumable Subs that returns just one value Dim SenderFilter As Object = sql.ExecQueryAsync("SQL", "SELECT * FROM table1", Null) Wait For (SenderFilter) SQL_QueryComplete (Success As Boolean, rs As ResultSet)...

Web API Updates: Latest B4XPages user login client apps (using B4J server): https://www.b4x.com/android/forum/threads/project-template-user-login-client-b4x.161914/ Older project: https://www.b4x.com/android/forum/threads/b4j-mysql-api-server-key-token-and-b4x-user-login-apps.126081/ 94106 94119 94118 Android App 94107941089411194112 94109 102583 This is the 3rd version of login exam...