Android Question Re: To develop one Invoice project

[sivakrith]

Hello,

Probably after purchasing B4A long back, I'm surprised to see that the product is free now !

Well, now I plan to develop one Invoicing system using B4A. Would like to have your expert opinions regarding
1. Where to start. Will go through documents to learn the basics. Would like to know whether tables are supported (where we can have many rows and many columns) and the possible ways to edit those rows / columns.
2. Any required add-ons
3. Need to store data locally inside the Android unit. Suggested database [ know there is SQLite], any other possibilities ?
5. Can remotely connect to web server to fetch any data?
6. Can remotely connect to local server to fetch any required data or not ?

Probably many would have asked, but my search didn't get the required result. That's why I'm asking (repeating ?).

Happiness Always
BKR Sivaprakash

 

[BelRagazzo]

Hello,

Probably after purchasing B4A long back, I'm surprised to see that the product is free now !

Well, now I plan to develop one Invoicing system using B4A. Would like to have your expert opinions regarding
1. Where to start. Will go through documents to learn the basics. Would like to know whether tables are supported (where we can have many rows and many columns) and the possible ways to edit those rows / columns.
2. Any required add-ons
3. Need to store data locally inside the Android unit. Suggested database [ know there is SQLite], any other possibilities ?
5. Can remotely connect to web server to fetch any data?
6. Can remotely connect to local server to fetch any required data or not ?

Probably many would have asked, but my search didn't get the required result. That's why I'm asking (repeating ?).

Happiness Always
BKR Sivaprakash

Answers:

1. You just have to be clear about what you want to do and specifically search the forum, B4A is extremely powerful, everything depends on you.

2. It requires nothing more than the B4A and the correct libraries.

3. To save data locally on the device, SQLite is the most recommended.

SQLiteLight four simple SQLite projects

Some users asked here for a simple SQLite project as an example to make their first steps in SQLite. The already existing examples seem beeing somewhat complicated for beginners. These examples are explained in the B4XSQLiteDatabase Booklet. Attached three small projects: - SQLiteLight1 A...

www.b4x.com

Android SQLite Viewer

SQLite Viewer is an open source application that allows you to view the contents of SQLite databases right from your Android device. Choosing the database file is done with an external file manager or with agraham's FileDialog. After choosing a database file, you will see a list with the...

www.b4x.com

5-6. If you are going to synchronize local data to a remote server, I recommend that you use MYSQL.

[B4X] jRDC2 - B4J implementation of RDC (Remote Database Connector)

RDC is a middleware server that makes it simple to safely connect clients and remote SQL database servers. jRDC2 is the latest version. All new projects should use this version. jRDC2 is made of two components: - B4J server. The server receives the requests from the clients, issues the SQL...

www.b4x.com

JdbcSQL - Directly connect to remote databases

This is a port of B4J jSQL library. The SQL type was renamed to JdbcSQL and ResultSet was renamed to JdbcResultSet, this allows using it together with the SQL library. SQL library - local SQLite databases. JdbcSQL - Any remote SQL database with a supported JDBC driver. MySQL and MS SQL are...

www.b4x.com

 

[John Naylor]

1. Where to start. Will go through documents to learn the basics. Would like to know whether tables are supported (where we can have many rows and many columns) and the possible ways to edit those rows / columns.

Tables are supported fully via several libraries depending what exactly you want to do. You'll have plenty of options.

2. Any required add-ons

This depends very much on your final requirements and approach.

3. Need to store data locally inside the Android unit. Suggested database [ know there is SQLite], any other possibilities ?

See above about requirements / approach. I use SQLite for storing lists of combobox entries for example. Things that are unlikely to change too much. I check for changes against my main online database when my app starts or receives a force update message.

5. Can remotely connect to web server to fetch any data?

Look at JRDC2 - It's incredibly powerful and lightweight. It sits as middleware between your app and [in my case] a MySQL database. It handles everything quickly and securely.

6. Can remotely connect to local server to fetch any required data or not ?

See 5 - Use JRDC2 on a local server too.

 

[sivakrith]

Thanks BelRagazzo & GymReaper. I'll learn further before diving into development.