How to get information in SQLITE? Help

[ricsoft74]

I know how to render a sqlite table, thats not the problem.

I want to get a content in sqlite as an string or a value.

For example, this sqlite table

A B C
Un 2 3
Do 7 5
Tr 2 1

How to ger the values or string in this sqlite table to transform in a sum or any operation???

"columnname$" just get the column name, and nextrow$ does not understand at alll what it does.

please any help

i tried to post in the forum related to sqlite, but the option "post" did not appear.

[StefanPendl]

Jul 15, 2008 14:16:25 GMT -5 ricsoft74 said:

For example, this sqlite table

A B C
Un 2 3
Do 7 5
Tr 2 1

How to ger the values or string in this sqlite table to transform in a sum or any operation???

"columnname$" just get the column name, and nextrow$ does not understand at alll what it does.

NEXTROW$ returns a string delimited by the character you choose.

So using your query that renders to the above table, would use someting like the following to build the sum of column 2.

    sum = 0
    for i = 1 to #sqldb rowcount()
        theRow$ = #sqldb nextrow$(";")
        sum = sum + val(word$(theRow$, 2, ";"))
    next i