Search Results

Where's your MS SQL database? In another computer in your network? In the same computer you're developing? In internet?

Where is the code for the SQL library located. Maybe we can look at it and see if the ExecSingleResult can be modified to prevent such error without knowing the content of your data in the table.

database.sqlite.SQLiteQuery.<init>(SQLiteQuery.java:37) at android.database.sqlite.SQLiteDirectCursorDriver.query(SQLiteDirectCursorDriver.java:44) at android.database.sqlite.SQLiteDatabase.rawQueryWithFactory(SQLiteDatabase.java:1316) at android.database.sqlite.SQLiteDatabase.rawQuery(S
link: If the application was already installed before you added that column , then try uninstalling the app then recompile.
link: Hi Jahswant ,I need to delete the (B4A Example)application of B4A Bridge and install it again, right? If right, I tried it and can't
link: Sorry and thanks to everyone for your help, I am busy with other things these days and need time to read your comments and research. But when I copied

I guess that you put it in the Files folder, right? It will be embedded in the package. You need to copy it to XUI.DefaultFolder before you can access it, as it needs read-write access.
link: After building a standaone package, I am failing to locate the sqlite database in the build folder. I would really appreciate if some can assist me.
link: yes It's in the files folder.... I can read-write ,but I want to access the sqlite.db file so that i can access it with database admin tool. I am fai

Hello team. I initialize sqlite at starter service. Everything works fine. Where should we call SQL.close? Because i call sql.close at Main activity_pause if user closed and throws me an error if i close app and reopen imediately. Error is about: reopen a closed database. Thank you for your time.

Partially confirmed by the comment "It is also safer as the SQL commands are set in the server side" at the "jRDC2 - B4J implementation of RDC" post. So... try @DarkoT's suggestion, except possibly without the first "where" in the parameter string, because the server-side command already has a "whe

You may be clobbering your SQL server. Why don't you try with one pool running (not 2 or 3). Where is your SQL server located in relation to the the solution you are creating here?
link: one of the MQTT servers is local and the other one in Germany. I am using 2 different ports 1883 and 1884. Speed from Germany to here is fast so I do
link: Ok , that will take some time to do so I will do it in the next couple of hours. I need to open up ports in the router as well as one of my MQTT serve

Where is your SQLite DB located. If, in your app, you copied it to File.DirInternal, you wont see it! If you copied it to File.DirRootExternal, you should see in the Files.Dialog box with Open internal file manager.

Hi all, is there a way in pure SQL to construct a WHERE clause using the IN operator where its list is of variable length? I mean something like: SELECT * FROM Customers WHERE Country IN ('Germany', 'France', 'UK'); but with the Countries' list built at runtime and made up of any number of items

I will be remaking my old B4A app with multiple Activities. I used SQL and TTS here. Now I want to use B4XPages. 1. I used SQL.Initialize... in B4XPage_Created in B4XMainPage file. Where is the best place to put SQL.Close? 2. I will use TTS.Speak on some pages. Where is the best place to place TTS.
link: 1. Nowhere. It will be kept open until the OS kills the process. 2. Anywhere you like. One of the nice things about B4XPages is that the classes are s

Powered by ColBERT