SQLite Complie error

[scotland42]

I am getting an error (30001) right after SQLite.Compile...
For the life of me, I can't seem to figure it out. Does anyone have any suggestions?

function getStoredCRC(f)
Application.SetLastError(0)
SQLite.Compile(db, "SELECT * FROM CRCTable WHERE Filename = " .. f .. ";")
Debug.Print(Application.GetLastError())
SQLite.Step(db)

local crctbl = SQLite.GetRowDataAssoc(db)

SQLite.Finalize(db)
return crctbl.CRC

end

Thanks in advance!
Nathan

[Dermot]

Hi Nathan

The problem is this line:
SQLite.Compile(db, "SELECT * FROM CRCTable WHERE Filename = " .. f .. ";")

It should be:
SQLite.Compile(db, "SELECT * FROM CRCTable WHERE Filename = '" .. f .. "'")