• Sql error
    2 replies, posted
Hi, When creating a table I get the error: near "TEXT": syntax error Code: local tablename = ("LOCKER_" .. ply:UniqueID()) local query = ("CREATE TABLE '" .. tablename .. "' (Name TEXT, Primary TEXT, Secondary TEXT, Equipment TEXT, Perk1 TEXT, Perk2 TEXT, Perk3 TEXT)") I used sql.LastError() to get this error message. I have used the datatype TEXT before in other code and it worked fine.
Primary is a reserved word. It should be [Primary].
This worked thank you.
Sorry, you need to Log In to post a reply to this thread.