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...

I created a new library to show a table (or grid) similar to the one in EXCEL. There are already excellent classes that allow many to accomplish things, such as xCustomListView by @Erel (B4X) and with the FlexibleTable by @klaus (B4A). I wanted to make something slightly different suited to my needs. WARNING The use of libraries for personal and / or commercial use is permitted. It is not allowed to modify the sources or change the name of the library. Reverse engineering is not...

I wanted a quick way to generate a layout file (add the views and their names and events) to then fine-tune it with the Designer - MakeBxL does that, either from - a list of names (for the views) that you add in its TextArea, or - from an SQLite database table Some additional options are available... and restart the entire program * Added column 'JSON' to the TableView, which shows the view... the ChoiceBox/ComboBox issue, @Mariano Ismael Castro ) Start: 150562 SQLite-based: 150328 150563...

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...