Alternative way of addressing elements of a structure?

[kpeters58]

Is there an alternative way of addressing elements of a structure, such as indexing into it like with an array?

So rather than doing (pseudo code)

Structure WideDatabaseRecord
Column1.s
;...
Column200.s
EndStructure

NewList VirtualRecords.WideDatabaseRecord()

; select * from WideTable

VirtualRecord\Column1 = GetDatabaseString(1)
; ...
VirtualRecord\Column200 = GetDatabaseString(200)

I could loop though the structure elements assigning column values to them rather than having 200 lines of repetitive code....

[wilbert]

Array inside structure ?

Code: Select all

Structure WideDatabaseRecord
  Array Column.s(200)
EndStructure

a.WideDatabaseRecord

a\Column(1) = "column 1"
a\Column(2) = "column 2"

Debug a\Column(2)

[kpeters58]

Array inside structure ?

Code: Select all

Structure WideDatabaseRecord
  Array Column.s(200)
EndStructure

a.WideDatabaseRecord

a\Column(1) = "column 1"
a\Column(2) = "column 2"

Debug a\Column(2)

That would only work if all database columns were of the same type....

[wilbert]

That would only work if all database columns were of the same type....

Can you give a bit more information about how a record looks and what types you need to use for the columns ?

[citystate]

would using an array of pointers work for you?

[fabulouspaul]

How about using a SQLite-database in memory and accessing the data with SQL-commands? [OpenDatabase(#db_handle, ":memory:",..)]

[kpeters58]

That would only work if all database columns were of the same type....

Can you give a bit more information about how a record looks and what types you need to use for the columns ?

I typically use SQLite's INTEGER & TEXT storage classes only (very rarely BLOBs as well).

[kpeters58]

How about using a SQLite-database in memory and accessing the data with SQL-commands? [OpenDatabase(#db_handle, ":memory:",..)]

Hmm - interesting suggestion. Hadn't thought about that one yet...

[kpeters58]

How about using a SQLite-database in memory and accessing the data with SQL-commands? [OpenDatabase(#db_handle, ":memory:",..)]

Hmm - interesting suggestion. Hadn't thought about that one yet...

[kpeters58]

How about using a SQLite-database in memory and accessing the data with SQL-commands? [OpenDatabase(#db_handle, ":memory:",..)]

Hmm - interesting suggestion. Hadn't thought about that one yet...