Search Results

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 day or so though.
link: MainForm.Show Dim MyResults As Map Dim MyResultSet As ResultSet MySQLConnection.Initialize2("com.mysql.jdbc.Driver","jdbc:mysql://localhos
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 ?, ?, ?

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: Tried all 3 versions, each works, and all with rare errors of this kind... Why these errors ? Is it disconnect from DB ? p.s. file-based SQLite has
link: is not used at all. Why ? Server app is to be 24\7 working...

I'm not sure I fully understand your question. MS Sql Management Studio is a tool to create databases, this thread however is for creating web apps that save data to databases esp mysql.
link: Could you please explain the pros and cons of using such builder compared to the vanilla Microsoft SQL Server Management Studio?

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.
link: im using mysql dates are already indexed , i dont get what u mean by relationships ? this is only 1 table
link: hi falks i dunno if this is the right place for this question .. i m trying to find all hospital admissions that occurred within 1 month from last dis

Hello Dear, The Database is MS SQL (.bak file) is included in the .zip file (the source code) I think you still didn't restore the database to your own MS SQL and you are still connected to our server database :) The MySQL script is for the database creation which will be the same as MS SQL datab
link: Hello Dear, The MS SQL database engine is free, just use the express version. and you can install it on any VPS, PC,Laptop. In our case it's install
link: ok now i understand. you mean for the table creation. got. it. actually, i have only tested it and looked at the code. i plan to connect it to my m

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

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.

Hi An sqLite database is the most flexible way of doing what you want. Pretty much everything done with a database is done with the Structured Query Language (sql). You can create a database file or an in-memory data base. You can add a table with fields specified, names, data types etc. You c
link: If you decide to use an SQlite database, you could use DB Browser for SQLite to design your database and test queries against the design. DB Browser f
link: Yes, I use db Browser as well as sqLite. I think sqLite is better for database management and design, however DB Browser has a graphing feature whic
link: Yes, that is completely correct, but by using a SQLite database you do not have to worry about memory management and it becomes much easier to use all

I try this and nochange
link: Is it a better pratice to make a connection pool and close it each time I connect to a table? Sub Handle(req As ServletRequest, resp As ServletRespons
link: Finally, fund my problem. I fund a Dim sql1 As SQL=Main.Pool.GetConnection without sql1.Close somewhere in 600 lines of code Resolved

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.

Powered by ColBERT