Search Results

it seems that you are calling a sql.close somewhere before doing some more with the sql object. With this db's you should only close sql once OR use a pool and open / close a new connection everytime is needed
link: Check the DB module in the server example: https://www.b4x.-web-apps-overview.39811/#content Whenever you need to access the db, you get the connecti

FetchOutputParameters returns the output parameters as a Map. Microsoft SQL Server Example: The sample code below uses the AdventureWorksLT sample database provided by Microsoft. The correct database for your SQL server version can be found here: https://github.com/Microsoft/sql-server- I create
link: It should work with any JDBC driver where the DBMS supports stored procedures. I will do an example using SQL server and post it up. Won't be for a
link: Hi KeirS I was asking if the above will work for MsSQL, but I guess I got my answer after changing the syntax to "exec StoredProcedureToCall ?, ?, ?

:confused::D What is amazing with SQL is that any condition you have in mind can be done. Looks like there are no limits. Just have to find the sintax ...
link: I used the unquoted with MySQL and it worked fine. Yup. I would say that depends on the "smartness" of the SQL engine. This is hilarious: SELECT L

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.

Sorry to say but it is nonsense. SQLite is a very powerful database engine which is used by many servers. It is definitely a tool that developers should consider. Like any other tool it has its advantages and disadvantages. Why do you need to turn each thread into an ongoing argument? No one want
link: This was a tutorial/information thread and not a question. The question has already been answered in those other discussions. All I was showing was th
link: @j_o_h_n exactly what I was trying to show. A lot of developers will just instinctively use a full blown RDBMS for a small application. It just compli

What is the reason to use SQl here. The OP is using KVS which uses an internal SQL database, but I don't see the need to use that SQL code at all, when you can directly access the keys in a list using: kvs.ListKeys. You and the OP seem to go back and forth on this. There must be something to it.
link: Why do you need to use SQL at all. Is there a special reason. Assuming you will be using the new KVS, why not something simple like For Each k As Stri

This is true. This is an SQL(lite) specific problem rather than a B4X specific problem so your best answer may be found on a SQL(lite) forum. If you do find a solution, I'd love to hear what it is.
link: Building a query scrolling through the fields of a table is a procedure I already have and it works But being slow I wanted to improve it and therefor
link: How about this SQLite statement which involves 2 simple queries like this without lists and without variables. I just cannot see it done using one sim

And/or jPoi library: https://www.b4x.-supports-microsoft-excel-xls-and-xlsx-workbooks.57392/
link: Hi guys I want a method to export an small report to excel. Any way to do this? I'm making at the moment DBUtils.ExecuteHtml.
link: With the library stringutils you can export it to a CSV file easily.

Sqlite: SQL1.ExecNonQuery("CREATE TABLE IF NOT EXISTS scalemast (pk INTEGER PRIMARY KEY, loadtype INTEGER, acttype INTEGER, recdate INTEGER, drvid INTEGER, trkid TEXT, trl1id TEXT, trl2id TEXT, trl3id TEXT, gross INTEGER, tare INTEGER, rectype TEXT, lat REAL, lon REAL )") Of course, every ins
link: You will need to teach yourself SQL. The example shows what kind of result you will get from your statement... Dim NumberOfMatches As Int NumberOfMa
link: I want to create a SQL DB with a Primary Key. Have written the following: sql_PLD.ExecNonQuery("CREATE TABLE IF NOT EXISTS BRP (id_nr INTEGER not nul
link: usually i split as: CREATE TABLE IF NOT EXISTS BRP (id_nr INTEGER not null, Datum_Aufzeichnung Text, Datum TEXT, Uhrzeit TEXT, Plus_Zeit Float, Flow_

Which Database are you using? SQLite or MS SQL? The first approach could be to review the design and include dates in indexes and establish relationships to avoid subquery using INNER JOIN.

Powered by ColBERT