SQLite: Проверить - есть ли данные в ячейке

[antoxa557]

К примеру создал код:

_SQLite_Open(@ScriptDir &"\rest.db")
_SQLite_Exec(-1, 'CREATE TABLE IF NOT EXISTS Music ("Artist", "Year"); INSERT INTO Music VALUES ("El Tarlo", "1995");')
_SQLite_Exec(-1, 'INSERT INTO Music VALUES ("The Usual Suspects", "1995");')
_SQLite_Close(-1)

OffTopic:
Кажеться код должен работать!!

Вот как проверить - есть ли 'The Usual Suspects' в столбце 'Artist'?

 

[XpycT]

antoxa557
Попробуй вот так

#Region Includes
#include <SQLite.au3>
#EndRegion Includes
#NoTrayIcon

Local $hQueryResult, $aResult

_SQLite_Startup()
$hDB = _SQLite_Open(@ScriptDir &"\rest.db")
_SQLite_Exec($hDB, 'CREATE TABLE IF NOT EXISTS Music ("Artist", "Year"); INSERT INTO Music VALUES ("El Tarlo", "1995");')
_SQLite_Exec($hDB, 'INSERT INTO Music VALUES ("The Usual Suspects", "1995");')

_SQlite_Query($hDB, "SELECT Artist FROM Music WHERE Artist = 'The Usual Suspects';", $hQueryResult)
While _SQLite_FetchData($hQueryResult, $aResult) = $SQLITE_OK
	ConsoleWrite($aResult[0] & @CR)
WEnd

_SQLite_Close($hDB)
_SQLite_Shutdown()