sqlite delete record

[faustf]

hi guy

if i want remove specific record in table is correct if i use this sintax

$iocr1 = _GUICtrlListView_GetItemTextArray($List1AC)

_SQLite_Query($Db,"DELETE FROM anagrafica WHERE ana_id"&$iocr1[8]&";",$hQuery)

[jchd]

A query is ... well, a query. Use a query with "select ... from ... where ...".

Also I already advised you to stop using low-level _SQLite_* functions and favor _SQLite_GetTable[2d] instead for querying the DB.

But since you need to delete row(s) here, use _SQLite_Exec like this (with an equal sign in the where condition!):

_SQLite_Exec($hDB, "delete from anagrafica where ana_id = " & $myvariable)

Edited April 22, 2013 by jchd

[faustf]

i try to do in this mode but dont go

Func _elimina_cliente()
$dir_clienti=''
$apri_folder=''
$iocr1 =''
$iocr1 = _GUICtrlListView_GetItemTextArray($List1AC)

_SQL_Startup()

$Db=_SQLite_Open($percorso_Db); Open a permanent disk database
If @error Then
MsgBox(16+262144, "SQLite Error", "Non posso creare il Database!")
Exit -1
EndIf

_SQLite_Query($Db,"DELETE FROM anagrafica WHERE ana_id = "&$iocr1[8]&";",$hQuery)
If @error Then
MsgBox(16+262144, "SQLite Error", "Non posso cancellare il record nel database!")
;Exit -1
EndIf

_SQLite_Close()
_SQLite_Shutdown()
EndFunc

[kylomas]

faustf,

Re-read jchd's post...

[faustf]

o yea i am fuse so sorry

[jchd]

Of course you can read and see that the word query is different from the word exec. Just like my previous post strongly hinted to.

Of course you can probably devise that $myvariable can be changed to the actual variable you need in your context.

What I find surprising is that you consider SQLite so much more difficult than MySQL. At this rate, every SQL engine is going to be hard to you.