Initialising Structures & SQL

CanelaKid · Mar 2, 2011

Is there a way to initialise a structure with my values in 1 statement similar to below (Which produces an error on the last statement)

Type AlertDefn(Message As String, Sound As Int)
Dim Alerts(2) As AlertDefn
Alerts = Array As AlertDefn(("Sunday",1), ("Monday",2))

Also what is the correct syntax to open an SQL Database which has a password

Erel · Mar 2, 2011

You can create a simple Sub that will act as the type constructor:

B4X:

Sub Create(Message As String, Sound As Int) As AlertDefn
  Dim A As AlertDefn
  A.Initialize
  A.Message = Message
  A.Sound = Sound
  Return A
End Sub

Alerts = Array As AlertDefn(Create("Sunday", 1), Create("Monday", 2))

CanelaKid · Mar 2, 2011

Thanks

For more complex structures this is little more work than B4PPC but yes, it works fine, I thought I might be missing a trick somewhere. What about the Opening of SQL Databases with Passwords?

Erel · Mar 2, 2011

Actually you cannot create complex structures with Basic4ppc. Basic4ppc structures are implemented as arrays.
Basic4android however supports structures of any reasonable complexity. See this for example: http://www.b4x.com/forum/basic4andr...als/6729-creating-linked-list-using-type.html

Android SQLite doesn't support encrypted databases. See this thread for a possible solution: http://www.b4x.com/forum/basic4android-updates-questions/7987-android-database-protect.html

Initialising Structures & SQL

CanelaKid

Member

Erel

B4X founder

CanelaKid

Member

Erel

B4X founder

Similar Threads

Initialising Structures & SQL

CanelaKid

Member

Erel

B4X founder

CanelaKid

Member

Erel

B4X founder

Similar Threads

Privacy & Transparency

Privacy & Transparency