SA-MP Forums Archive
SQL Problem - 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: SQL Problem (/showthread.php?tid=319844)


SQL Problem - Konstantinos - 20.02.2012

Solved.

Re: SQL Problem - Rob_Maate - 20.02.2012

pawn Код:
INSERT INTO `Users` (`Userid`, `Username`, `Password`, `Ip`, `Score`) VALUES('%d','%s','%s','%s','%d')
You need to define which columns accept the data

Re: SQL Problem - Konstantinos - 21.02.2012

Thanks Rob_Maatenow it works, but I thought it was optional to defined them and it worked the first time.


Re: SQL Problem - Rob_Maate - 21.02.2012

Well no, with your version of the code, you were telling SQLite to insert:

1, John, Psasword01, 127.0.0.1, 5

Into " " column.

Re: SQL Problem - Konstantinos - 21.02.2012

Quote:
Originally Posted by Rob_Maate
Посмотреть сообщение
Well no, with your version of the code, you were telling SQLite to insert:

1, John, Psasword01, 127.0.0.1, 5

Into " " column.
Yes, I understand my mistake. It works and I added more data and all insert into/load fine.
Thank you!

Re: SQL Problem - Rob_Maate - 21.02.2012

Noproblemo