Search Results

Unless you store multiple address for each student, why are the student and STinfo in separated tables in the first place? yes your are right tables were for test and learn...
link: tables in the first place?...
link: $"SELECT Students.id, name, gr, phone, city, streetname FROM students, grades, stinfo WHERE S...
link: hi guys i have three table 104223 i want to get date from three table with one query i confuse...

@DonManfred thanks for the correction - slip of the pen (or rather fingers!). Hope I've got it ...
link: @manfred!!!! You're a star! I am NOT the User manfred... My Name is DonManfred (if you want to m...
link: yeah, I just fixed it in the post above ;) didn't notice the b_id, c_id & d_id...
link: @manfred!!!! You're a star! Thanks - your statement works perfectly! @sorex. Thanks, but it does...

You should use ExecNonQuery2 for an UPDATE command....
link: this is the code i have been working on, Query = "UPDATE inventory SET item = ?, instock = ?, ordamt = ?, Type = ?, contai...
link: How do you use the UPDATE statement to Update two joined tables in SQLite, I have table1 that has 9...

Ok, thanks I'll take a look. In addition to what Brian pointed out to you, if you use this search: join sqlite tables You will get this link, which has a ton of information and examples on how to join tables in the same database. Then, when you draft your code, post it for members to correct and help you finalize it https://www.b4x.com/android/forum/pages/results/?query=join+sqlite+tables...

B4XTable is a paged based table. The UI is made of a horizontal xCLV. The data is stored in an in-memory SQLite database. https://www.b4x.com/basic4android/images/SS-2019-02-07_15.33.03.png How to...(data) 'this is an asynchronous method. If you want to access the table immediately after SetData... of the table colors are set in the designer properties. The arrows colors are set with ArrowsEnabledColor... that refreshes the table synchronously. SetData returns a ResumableSub object and can be used...

tables (JOINs) come into play. There's that, and the fact that it was fun to develop (and I wanted to...As I don't use SQLite (or any other SQL) all the time and am no database expert, it's...: BCTextEngine, DesignerUtils, jControlsFX9, jSQL, XUI Views - Non-core libraries: sqlite-jdbc-3.39.2.0 (or newer) - Modules from the project's root folder: Arrows.bas, wmSQLiteSelectBuilder.bas, wmWiLNetChart.bas - Files from the project's Files folder: BBCV.bjl, wmSQLiteSelectBuilder.bjl Example...

This thread will be used by Erel, Melamoud and myself to discuss / post new releases of the Table class. The table class is a flexible UI component that enable scrollable table like UI, with sortable columns, multiselect rows etc the table is very efficient, maintaining labels only for visible.../19254-class-tableview-supports-tables-any-size.html#post110901 The class depend on following...) - ScrollView2D (additional) List of major features. 1. scrollable table UI 2. sortable columns 3...

Attached you find a small project to convert csv files to a SQLite database. The program: - detects..., the Database generic file name is the same as the csv file name. - by default, the Table name is also...: 2022.11.01 Version 1.4 Removed invalid characters in Table names. Added: Number of rows / Time to load csv / Time to convert. The CsvToSQLiteExe file is still the old file, a new file with Java 11 is too big. I left also the previous version zip file. EDIT: 2021.09.18 Added the use of SQLite...

to it! Sqlite-jdbc version 3.25.2 (2018.10.01) available for download HERE Implements UPSERT, ALTER TABLE ... RENAME COLUMN and added the Geopoply module. Sqlite-jdbc version 3.27.2 (2019.03.15) available for download HERE Upgrade to SQLite 3.27.2 Sqlite-jdbc version 3.27.2.1 (2019.03.20...Hi everybody! This thread is supposed to get all SQLite JDBC library version links together so as to find and download them easier. As a heavy B4J+SQLite user, I'm always looking forward to...

SQLite databases are very easy to use as they don't require any additional software or configuration. SQLite support for concurrent access is not comparable to server based databases... there aren't many writings (ExecNonQuery). B4J v2.00 adds support for concurrent access to SQLite... classes. Don't use a ConnectionPool with SQLite database. - When you create the database you need to...) You only need to set the journal mode to wal once. Read more about wal mode: https://www.sqlite.org/wal...