SQLite List records

[jcpetu]

Hi people, I'm trying to query an SQLite Indexed DB but I don't get a way to list all records that fit a condition: For instance, I want to list the records with LastChanged date equal to some date but I get a message :

!   SQLite.au3 Error
--> Function: _SQLite_Query
--> Query:    SELECT ROWID,*  FROM Computers INDEXED BY LastChanged WHERE CLastChanged='20141020-204026'
--> Error:    no query solution

Below the code:

_SQLite_Query(-1, "SELECT ROWID,*  FROM Computers INDEXED BY LastChanged WHERE CLastChanged='" & $LastSchanged & "'", $hQuery)

While _SQLite_FetchData($hQuery, $aRow) = $SQLITE_OK ;

    ConsoleWrite($j & "-->" & $ComputerName & $aRow[1]&"-" &  "Last changed---> "&$aRow[19]&@CRLF)
    $j = $j + 1

WEnd

By the way, How can I get the first and last record of the indexed database?

I'll appreciate any help.

Thanks a lot and regards.

 

[Zedna]

Post schema of your database/table.

Also look here

'?do=embed' frameborder='0' data-embedContent>>

Edited October 24, 2014 by Zedna

[jcpetu]

Hi Zedna, I found it.

I didn't get any result until I reindexed the table only by one field.

It seems that when you use more than one field the query returns an empty set of data.

Thanks a lot for your help.