Hey guys,
I am wondering how I retrieve the row id in a SQLite table?
My script looks like this
function createDB()
executeSQLQuery("CREATE TABLE IF NOT EXISTS spawncar(id INT, x TEXT, y TEXT, z TEXT, xr TEXT, yr TEXT, zr TEXT, r INT, g INT, b INT, r2 INT, g2 INT, b2 INT, nitro TEXT, lockType TEXT, lockedTo TEXT)")
createMarkers()
end
addEventHandler("onResourceStart", resourceRoot, createDB)
function createMarkers()
SQLmarker = executeSQLQuery("SELECT * FROM spawncar")
markers = {}
for i,v in ipairs(SQLmarker) do
local marker = createMarker(v.x,v.y,v.z-1, "cylinder", 2, 255,0,0,150)
setElementData(marker,"row",v.rowid)
-- At here I wanted to retrieve the data about the rowid and assign the ID to the marker, but how can I do that?
setElementData(marker, "carspawner",true)
setElementData(marker, "carid", v.id)
setElementData(marker, "x",v.x)
setElementData(marker, "y",v.y)
setElementData(marker, "z",v.z)
setElementData(marker, "xr",v.xr)
setElementData(marker, "yr",v.yr)
setElementData(marker, "zr",v.zr)
setElementData(marker, "r",v.r)
setElementData(marker, "g",v.g)
setElementData(marker, "b",v.b)
setElementData(marker, "r2",v.r2)
setElementData(marker, "g2",v.g2)
setElementData(marker, "b2",v.b2)
setElementData(marker, "nitro",v.nitro)
setElementData(marker, "lock",v.lockType)
setElementData(marker, "lockedTo",v.lockedTo)
end
end