Search Results

SQLite has the string function Instr, which finds the first occurrence of a specified string in... another string. As I needed this I made another custom SQL function (I have several of these) to do...
link: strSQL = strSQL.Replace(strStringToReplace, _ $"coalesce(max...
link: SQLite has the string function Instr, which finds the first occurrence of a specified string in...

: The API performs input validation and sanitization to prevent common security vulnerabilities such as SQL.... Available Resources 🌟 Ultimate Guide: Manage Any MySQL Database with DatabaseAPI and api.php...
link: = Recommended example: &db_type=mysql Even if MySQL is the default value, it is considered best...
link: thrilled to unveil Magic API Library 6.0, the tool that transforms your MySQL databases...
link: Actualmente, la librería utiliza una única clave API fija, por lo que no es posible asignar una cla...

.sql.SQLException: Abort due to constraint violation (columns lang, key are not unique) Any Idea...
link: Definitely is something to do with LibreOffice! I replaced my file with the original from the zip, a...
link: Don’t let any free cell between keys nor values you’ll get .db file combine errors. It doesn't...
link: Don’t let any free cell between keys nor values you’ll get .db file combine errors....

the complex SQL syntax differences (quoting, schemas, and identifiers) automatically on the server side. 🌟 Key Features in v7 Multi-Engine Compatibility: Full support for MySQL, MSSQL, SQLite, PostgreSQL, Oracle, and Firebird. Intelligent Quoting: New server-side logic that automatically detects... milestone, transforming the library from a specialized MySQL tool into a Universal Database Bridge for... on the engine. Unified Initialization: A cleaner, single-method entry point for all your projects. SQLite...

of this application. This small application might be a great help in creating reports and SQL statements. 155927 155928 In the first tab you can select a SQLite database file and get all the tables in...
link: Good. i needed to download: https://repo1.maven.org/maven2/mysql/mysql-connector-java/5.1.27/ and dr...
link: Check out the second spoiler. It's another example of the possible integration of this applicati...
link: This small application might be a great help in creating reports and SQL statements. 155927...

an empty b4a app with #AdditionalJar: sqlite-jdbc-3.7.2, with the Jdbcsql library,did not finish compilation. I had to extend the process timeout to 360 and release mode ! the next time it compiled, after the compiler switched from optimized to standard. I can't wait long time for every...
link: Why not use the built-in SQLite engine? I do when the DB is local, I need the b4a app to work...
link: Why not use the built-in SQLite engine?...

Version: 2.00 155123164904 GitHub: https://github.com/pyhoon/user-login-client-b4x Server: User Login Server Description: B4X client apps connect to a server with SQLite/MySQL database Shows a list of users with their last login time You can use these client apps for displaying any contents that requires user authentication and authorization e.g quiz, subscriptions and e-commerce. ...

How do I use a SQL with parameters with LoadSQLiteDB with the Table class? With Table class I mean.../ I can only see the option to use a plain SQL string. Or should I just run ExecQuery2 and populate...
link: Whenever you need to get a link to a specific post (permalink), just use what is returned clicking o...
link: LoadSQLiteDB4 as well with a cursor argument: I will not add LoadSQLiteDB4, I don't see the utility....
link: How do I get a link to the specific post? Couldn't find that. Whenever you need to get a link to...

Using activities makes everything 10 times more difficult. Switch to B4XPages and you will see it....
link: When a execute SQL, all code go to module. This module open database, execute sql, get data...

How to open/use this template? 144004 Just drop the files to B4J Additional Libraries folder and y...
link: data into SQLite. Add a button for uploading the data using jRDC2. Uploading can be mean sending...
link: SQLite back to the MySQL "Inventory table". I have created a basic program that works...
link: data into SQLite. Add a button for uploading the data using jRDC2. Uploading can be mean sending new...