another question about sqlite

[faustf]

hi guy i am in hell of sqlite (mysql is much better ) but i wanna use sqlite

i wanna read a db i have a table name : anagrafica and this structure inside

CREATE TABLE [anagrafica] (
[ana_id] integer NOT NULL PRIMARY KEY AUTOINCREMENT,
[Ana_Nome] varchar(25),
[Ana_Indirizzo] varchar(25),
[Ana_Citta] varchar(25),
[Ana_Provincia] varchar(25),
[Ana_Piva] varchar(25),
[Ana_CdF] varchar(25),
[Ana_telefono] varchar(25),
[Ana_mail] varchar(25),
[Ana_cell] varchar(25),
[Ana_fax] varchar(25),
[Ana_Nazione] varchar(25),
[Ana_Nome_Legale] varchar(25),
[Ana_Indirizzo_Legale] varchar(25),
[Ana_Citta_Legale] varchar(25),
[Ana_Provincia_Legale] varchar(25),
[Ana_Nazione_Legale] varchar(25),
[Ana_Ricordare] varchar(25),
[Ana_Mail_legale] varchar(25),
[Ana_Bank] varchar(25),
[Ana_Iban] varchar(25),
[Ana_Swift] varchar(25),
[Ana_Cell_Legale] varchar(25),
[Ana_Cap] varchar(25),
[Ana_Cap_Legale] varchar(25),
[Ana_Legale_e_Fisico] varchar(25),
[Ana_pagamento_assegnato] varchar(25)
)

i try to do this code

but of course dont go

Func _lettura_anagrafica()
  $Db=_SQLite_Open($percorso_Db); Open a permanent disk database
If @error Then
  MsgBox(16+262144, "SQLite Error", "Non posso Aprire il Database!")
  Exit -1
EndIf
_SQLite_Query($Db, "SELECT RowID,* FROM anagrafica;", $hQuery)
_SQLite_FetchData($hQuery, $aRow)
MsgBox(4 + 64, "Row: " & $aRow[1] ,"Continue Looping?")
_SQLite_QueryReset($hQuery)
_SQLite_QueryFinalize($hQuery)
_SQLite_Close()
_SQLite_Shutdown()
EndFunc

dont open db but i declare at top of script

Global $percorso_Db=@scriptdir & '\ditta.sqlite' ,$DataBase,$Db

[faustf]

do a little correction but dont visualize array

Func _lettura_anagrafica()

_SQL_Startup()
  $Db=_SQLite_Open($percorso_Db); Open a permanent disk database
If @error Then
  MsgBox(16+262144, "SQLite Error", "Non posso Aprire il Database!")
  ;Exit -1
EndIf
_SQLite_Query($Db, "SELECT *,* FROM anagrafica;", $hQuery)
_SQLite_FetchData($hQuery, $aRow)
MsgBox(4 + 64, "Row: " & $aRow[0] ,"Continue Looping?")
_SQLite_QueryReset($hQuery)
_SQLite_QueryFinalize($hQuery)
_SQLite_Close()
_SQLite_Shutdown()
EndFunc

[jchd]

Don't use these low-level functions.

Much simpler and efficient:

; perform this block once at startup
_SQLite_Startup()
Local $Db=_SQLite_Open($percorso_Db); Open a permanent disk database
If @error Then
  MsgBox(16+262144, "SQLite Error", "Non posso Aprire il Database!")
  ;Exit -1
EndIf

_lettura_anagrafica()
; there perform any operations your application needs

; perform this block before termination
_SQLite_Close($Db)
_SQLite_Shutdown()

Func _lettura_anagrafica()
    Local $aRow, $iRows, $iCols
    _SQLite_GetTable2d($Db, "SELECT * FROM anagrafica;", $aRow, $iRows, $iCols)
    _ArrayDisplay($aRow)
EndFunc

[faustf]

o thankz go perfectly but i dont wanna use external listview i wanna integrate how can do???

[kylomas]

faustf,

The listview (_arraydisplay) was just to show it working. "_sqlite_GetTable2D" returns a 2 dimensional array that you can use however you like...

kylomas

[faustf]

i do this but dont go

Local $aRow, $iRows, $iCols

_SQLite_GetTable2d($Db, "SELECT * FROM anagrafica;", $aRow, $iRows, $iCols)

; _ArrayDisplay($iRows)

msgbox(0,'',$iRows[1] )

[kylomas]

faustf,

$irows is a scalar variable, not an array. The result rows are in 2D array $arow.

kylomas

[kylomas]

faustf,

Add code like this to display you resulting rows (not tested)

Local $aRow, $iRows, $iCols
_SQLite_GetTable2d($Db, "SELECT * FROM anagrafica;", $aRow, $iRows, $iCols)

ConsoleWrite('Number of rows returned = ' & $irow & @LF)
ConsoleWrite('Number of cols returned = ' & $icol & @LF)

local $str

for $1 = 0 to $iRows
    for $2 = 0 to $iCols
        ConsoleWrite($arow[$1][$2] & ' ')
    Next
    ConsoleWrite(@LF)
Next

kylomas