B4A Question Cursor sql - different behavior between versions. - mcqueccu (first post)    Jun 19, 2020 The S23LEREVOLUC Sub is not doing or returning anything.
The vTBEVOLUC is not receiving any query results. B4i Question Zoom canvas - klaus (first post)    Sep 16, 2021   (1 reaction) Attached a small demonstrator program. It is a B4XPages project, tested with B4J, B4A and B4i. The field is scaled and the cursor positions are displayed at the bottom of the screen. The field dimensions are taken from HERE, in meters. The goal is zoomed by a factor of 4, hard coded. When the cursor B4A Question SQL - ExecQuerySingleResult - jatko    Jul 30, 2021 I have a query with single result. I need to get some data from two or three columns and assign the result to two or three variables. The only way what I found is to use cursor. But cursor is used rather for queries with many rows in result. Cursor1= Main.SQL.ExecQuery("select column1, column2, col B4A Question Cursor as Parameter - MarkusR (first post)    Mar 22, 2019   (2 reactions) i would close it where u open it, in the same sub. its easier to understand.
just think about if you need this.
if u would close it in "func" u can't use "func" again.
Sub main
Dim v_Cursor as Cursor = SQL.ExecQuery("SELECT * FROM TABLE")
func(v_Cursor)
func(v_Cursor)
v_Cursor.Close German Frage zu SQL - JOTHA (first post)    Mar 28, 2018   (1 reaction) Hallo Joe73, das müsste so funktionieren: Cursor = SQL1.ExecQuery ("SELECT Spalte_1 FROM Werte_A") For i = 0 To Cursor.RowCount - 1 Cursor.Position = i SQL2.ExecNonQuery ("INSERT INTO Werte_B VALUES('Spalte_3')") Next Cursor.Close B4A Library AndroidProviders (Calendars, Contacts, Calls Log, Telephony, SMS, MMS and more - DonManfred    Mar 14, 2016   (22 reactions) permission.READ_EXTERNAL_STORAGE
Properties:
AlbumsExternal As Cursor
AlbumsInternal As Cursor
ArtistsExternal As Cursor
ArtistsInternal As Cursor
AudiosExternal As Cursor
AudiosInternal As Cursor
FilesExternal As Cursor
FilesInternal As Cursor
GenresExternal As Cursor
GenresInternal As C B4A Question [Solved] How to create a circle like this? - klaus (first post)    Jan 27, 2024   (4 reactions) I played a bit further with this project to show what can be done. When you touch the screen and move the finger a cursor is displayed, the red cross. When the cursor is near a circle, this one is highlighted with a blue circle. In B4A and B4i the cursor is not just underneath the finger but shifted B4J Question Jserver & Connection pool not responsive after some time. - tufanv (first post)    Jan 31, 2019   (1 reaction) I realized stg. Aren't we doing a mistake by calling this in the module :
cursor=Main.pool.GetConnection.ExecQuery("SELECT sembol,name,table_name from genel")
maybe it should be :
cursor=Connection.ExecQuery("SELECT sembol,name,table_name from genel")
can it be the mistake. We are calling th B4A Question The code 'cursor=Starter. Mysql_Jdbc. ExecutQuery (strSQL)' reports an error and the reason cannot be found - bskotu555    Oct 24, 2024 view.ViewRootImpl$ImeInputStage.onFinishedInputEvent(ViewRootImpl.java:4786)
at android.view.inputmethod.InputMethodManager$PendingEvent.run(InputMethodManager.java:2571)
at android.view.inputmethod.InputMethodManager.in
Message longer than Log limit (4000). Message was truncated. B4A Question Update if a SQL record exist, insert if it does not. - Mahares (first post)    Dec 30, 2019 The statement returns a cursor. It should be:
Cursor = sql.ExecQuery("SELECT * FROM AppList ORDER BY LastTimeUsed DESC")
Not sure if it is your isssue. Also you are better off using parameterized query for the UPDATE like you used for the INSERT.
Also, you have an extra space here at the end AFTER T Page: 1   2   3   4   5   6   7   Powered by ColBERT |