Android Question I need examples

[miquelr]

Where can I find, examples of code, ej. https://www.b4x.com/sqlitedatabase_sourcecode/sqlitelight1/

 

[JohnJ]

There are examples included in the B4A download as well as in the forum. Just search B4A sqlite, you can also look at the b4j examples

 

[klaus]

The SQLite examples are included in the source code for the B4X SQLite Database booklet.
You can download all the booklets and the relative source codes from THIS page

 

[emexes]

examples of code

https://x.com/i/grok/share/ziKgSIRMGiPuxWD44YgfwUA45

does a scarily suprisingly good job.

My side of the conversation, excluding pleasantries, was:

I am using the B4A programming language. It is a dialect of BASIC for Android. I have some questions about using it with Sqlite.

How do I create a database with two tables?

The first table is a list of names and addresses, with columns for: first name, last name, street address line 1, street address line 2, suburb, state, postcode and country, where all those columns are strings, and also columns for latitude and longitude, where those two columns are numbers (decimal degrees, not degrees-minutes-seconds).

The second table is a list of suburbs, with columns for: suburb name, state and postcode (all strings) and latitude and longitude (numeric).

In B4A, when extending a single long program line over multiple text lines, please add a space and an underscore at the end of each line that continues on the next line.

How do I add a suburb to the second table, eg:
suburb name is Kilsyth
state is VIC
postcode is 3137
latitude and longitude are -37.802545 and 145.315868

 

[MicroDrie]

How do I create a database with two tables?

The first table is a list of names and addresses, with columns for: first name, last name, street address line 1, street address line 2, suburb, state, postcode and country, where all those columns are strings, and also columns for latitude and longitude, where those two columns are numbers (decimal degrees, not degrees-minutes-seconds).

The second table is a list of suburbs, with columns for: suburb name, state and postcode (all strings) and latitude and longitude (numeric).

Use (with or without installing it) free portable apps and add FREE DB Browser for SQLite. Create the Db and tables and look to the SQLiite create table query under Database Structure tab.

In B4A, when extending a single long program line over multiple text lines, please add a space and an underscore at the end of each line that continues on the next line.

Use smart string like $"${variableName} _
next line texts "$

How do I add a suburb to the second table, eg:
suburb name is Kilsyth
state is VIC
postcode is 3137
latitude and longitude are -37.802545 and 145.315868

Play with FREE DB Browser for SQLite under 'Execute SQL' tab and look to results under Browse Data tab and convert SQLite queries with safe parameters.

 

[emexes]

Use...

Beyond the call of duty, but thank you.

The archived Grok conversation was a demonstration that AI is a useful and surprisingly good source of what the OP was looking for, ie:

Where can I find, examples of code

which leaves us mere humans free to concentrate on the trickier questions.

 

[emexes]

Play...

I tried redoing the Grok conversation from:

Be impressed, and entertained too:
https://x.com/i/grok/share/CEsmg6mw5pQ8IxYIQfYqAZgKl

to be more to your style:

https://x.com/i/grok/share/QMWl8hFbXjfJyhKUsTwitkiTI

but in the process, I might have learned something new (that "Array(" is possibly not same as "Array As Object(")

Then again, AI isn't always correct.

But on a positive note, I've never seen it afraid to admit when it's wrong. Unlike us "organic twits".

 

[MicroDrie]

Be impressed, and entertained too:
https://x.com/i/grok/share/CEsmg6mw5pQ8IxYIQfYqAZgKl

They always said that Dutch people are direct, I suppose this is Dutch AI ?

 

[miquelr]

The SQLite examples are included in the source code for the B4X SQLite Database booklet.
You can download all the booklets and the relative source codes from THIS page

Thanks Klaus, your page is very useful for me.

 

[miquelr]

https://x.com/i/grok/share/ziKgSIRMGiPuxWD44YgfwUA45

does a scarily suprisingly good job.

My side of the conversation, excluding pleasantries, was:

Thanks emexes

 

[miquelr]

There are examples included in the B4A download as well as in the forum. Just search B4A sqlite, you can also look at the b4j examples

Thanks JohnJ