Search Results

Attached you find a small project to convert csv files to a SQLite database. The program: - detects... csv / Time to convert. The CsvToSQLiteExe file is still the old file, a new file with Java 11...
link: I will look deeper into your code and update the original one....
link: My comment about the ScrollPane was just to clarify why i use it instead of xCustomListView. My last...
link: Sorry for answering only today, these days i am not much on B4X. I had already added your code from ...

Some users asked here for a simple SQLite project as an example to make their first steps in SQLite... are explained in the B4XSQLiteDatabase Booklet. Attached three small projects: - SQLiteLight1 A very...
link: You need to post your project as a zip file. Without seeing what exactly you have done and how it...
link: you to check all the other lines. You may have a look at SQLiteLight3, there the columns are in...
link: Am I on the right track?Yes. But again, you might have a look at SQLiteLight3....

The attached project is a porting of the B4X_SQLiteLight2 project which is included in the B4X SQLLite database booklet. It uses as much as possible XUI objects and common code. Tested...
link: The first post has been updated with the latest version....
link: of the B4X SQLite Database booklet, but, did not update it here. The reason was that i expected using MP...
link: Sorry, I misread your post. I confused landscape app with horizontal CustomListview....

: 2020.04.14 Version 3.14 Added the methods below - LoadSQLiteDB4(SQLite As SQL, Query As String, AutomaticWidths As Boolean) loads SQLite data with data type checking - LoadSQLiteDB5(SQLite As SQL, Query As String, Values() As String, AutomaticWidths As Boolean). loads SQLite data with data type checking , similar to LoadSQLiteDB4 but for parametrized queries. - GetColumnDataTypes As String..., Row As Int) - Changed LoadSQLiteDB2 signature. Replaced the possible values from "T"...

The three projects are portations of the three BA4 SQLiteLight programs to B4i. These examples are explained in the B4XSQLiteDatabase Booklet. - iSQLiteLight1 A very simple project with a very... previous entry - iSQLiteLight2 A simple project with some more functions: A default database... - iSQLiteLight3 Same as SQLiteLight2, all functions are the same. The differences are the database path...
link: differences not SQLite differences....

With the code of Mahares your project works OK. But, what is the purpose of your database. I have seen that you have 55 tables called field1 to field55. And each table has one column called dataxx, where xx is the number of the field. This database structure surprises me....

between B4A, B4J and B4i projects. B4X SQLiteDatabase This booklet explains the use of the SQLite library...

Below you find an application with a SQLite database and a ScrollView based table. What the program...: 2013.02.08 Amended error reported in post #27 Updated zip file SQLiteDB_2D_v_1_2.zip EDIT: 2013.02.09 Amended error reported in post #30 Updated zip file SQLiteDB_2D_v_1_3.zip EDIT: 2013.04.19 Eliminated error with Null values in a database reported in post #45. Updated zip file SQLiteDB_2D_v_1_4.zip...
link: Hi hackhack, Answer to your question in the ScrollView examples summary thread.Hm, do you never write comments when you program? Yes, I rarely write comments in my programs. I try using self explainin...

According to the answer in post #2, have you tried this, ? Do While rs.NextRow LabelforLg.Text = rs.GetString("Body") Labelhead1.Text = rs.GetString("PageTitle") LabelforLg.Height = strUtils.MeasureMultilineTextHeight(LabelforLg, LabelforLg.Text) LG_ScrollView.Panel.Height = LabelforLg.Height Loop Inverting the two last lines ...

@klaus : you forgot to add after try this line: SQL2.EndTransaction Thank you ! I have updated post #4....
link: Or this code: Sub Button1_Click Dim SQL2 As SQL SQL2.Initialize(DBFileDir,DBFileName,True) Log("0") Msgbox("0","") SQL2.ExecNonQuery("Dele...