Sql problem

[Piorun]

Hi guys - i have problem with my database. I made some db in "sqlite browser" and i made table named "characters" and then i put some records. Here is lua code:

addEventHandler("onResourceStart", resourceRoot,  
function() 
    database = dbConnect("sqlite", "projectsa.db") 
    local query = dbQuery( database, "SELECT * FROM characters") 
    outputChatBox(tostring(query)) 
    local result, rows, msg = dbPoll(query, 0) 
    if result == false then 
        outputConsole( "dbPoll failed. Error code: " .. tostring(rows) .. "  Error message: " .. tostring(msg) ) 
    end 
end) 

,

but when im starting script im getting:

dbPoll failed. Error code: 1  Error message: no such table "characters" 

What's wrong?

I'm sure that table is in there, and im get connection from "dbConnect" function and query from "dbQuery".

[Metall]

That's because you never created that table, use this:

addEventHandler("onResourceStart", resourceRoot, 
function() 
    database = dbConnect("sqlite", "projectsa.db") 
    local exec = dbExec(database, "CREATE TABLE IF NOT EXISTS 'characters' ( characterID TEXT PRIMARY KEY )" ) 
    local query = dbQuery( database, "SELECT * FROM characters") 
    outputChatBox(tostring(query)) 
    local result, rows, msg = dbPoll(query, 0) 
    if result == false then 
        outputConsole( "dbPoll failed. Error code: " .. tostring(rows) .. "  Error message: " .. tostring(msg) ) 
    end 
end) 

Which is this:

    local exec = dbExec(database, "CREATE TABLE IF NOT EXISTS 'characters' ( characterID TEXT PRIMARY KEY )" ) 
  

[Piorun]

e ok but why "characterID" is "TEXT" type?

[Metall]

e ok but why "characterID" is "TEXT" type?

I guess it's because TEXT means that it's a text, like the name of a vehicle or so.

So i think that'll work anyways.

[Piorun]

Mhm ok i test it.

[Piorun]

Another question - what is good program to open .db files?

[Vision]

SQLite Database Browser.

[Piorun]

Ye but when im opeining database with tables made by dbExec i dont see any in database structure. I have 2.0 b1 ver.

[iPrestege]

Try this one ; http://sourceforge.net/projects/sqlitebrowser/

[Piorun]

Same.

[Piorun]

Anyway - if i made some table in "database browser" i cant manage this table using db... functions.

[Piorun]

I fixed that .. i thought that .db file is in main folder, but yes it was but i was in "database" folder too so i thought that this in main is my database which im connecting so i all the time open this one. Now i know it was wrong .. thanks for help.