Castillo Posted January 30, 2014 Posted January 30, 2014 So, it works with all the other columns, but not with 'rowid'?
Castillo Posted January 30, 2014 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"
Maurize Posted January 30, 2014 Author 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 )
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