Castillo Posted January 30, 2014 Share Posted January 30, 2014 So, it works with all the other columns, but not with 'rowid'? Link to comment
Castillo Posted January 30, 2014 Share Posted January 30, 2014 It could be because you created a column set as "PRIMARY KEY", try removing this column from the table: "id INT IDENTITY( 1,1 ) PRIMARY KEY" Link to comment
Maurize Posted January 30, 2014 Author Share Posted January 30, 2014 nope, seems like the column rowid isn't present.. // found solution for my own. addCommandHandler( "call", function( player, cmd ) local db = executeSQLQuery( "SELECT rowid, * FROM db_data", player ) outputChatBox( "Das Ziel trägt die ID: "..db[1]["rowid"], player, 255, 255, 0 ) end ) Link to comment
Castillo Posted January 30, 2014 Share Posted January 30, 2014 Maybe "*" doesn't include 'rowid' column. Link to comment
Maurize Posted January 30, 2014 Author Share Posted January 30, 2014 yeah Maybe. anyway thanks alot Link to comment
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now