problem with query SQLite - Printable Version

problem with query SQLite - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: problem with query SQLite (/showthread.php?tid=604773)

problem with query SQLite - mcreed - 09.04.2016

I have a query problem.

pawn Код:

new DBResult:Resultado;
new query[350];
format(query,sizeof(query),"INSERT INTO (`uNombre`,`uClave`,`uIP`,`uAdmin`,`uVIP`,`uPuntos`,`uMuertes`,`uSancion`,`uPosX`,`uPosY`,`uPosZ`,`uPosA`) VALUES ('%q','%q','%q',0,0,0,0,0,0.0,0.0,0.0,0.0)",NombreJugador(playerid),Jugador[playerid][pClave],IP);
Resultado = db_query(dbh,query);

the query not insert the dates./
the query does not insert data.

Thanks, sorry for my bad english.

Re: problem with query SQLite - AndySedeyn - 09.04.2016

You have to specify in which table you want to add the data to:

Код:

INSERT INTO table_name (column_names) VALUES (values);

Respuesta: problem with query SQLite - mcreed - 09.04.2016

Thank you, that mine dumbest mistake.