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



SQLite - GoldenLion - 02.03.2017

Hi, I started scripting a gamemode with SQLite so I got a question: do I need to get a result from an update or insert query and free it? I know that I need to do that with select queries, but what about update and insert?


Re: SQLite - azzerking - 02.03.2017

No you don't since you have not requested any information to be returned.

There is no need to free results that don't exist.


Re: SQLite - GoldenLion - 02.03.2017

Quote:
Originally Posted by azzerking
Посмотреть сообщение
No you don't since you have not requested any information to be returned.

There is no need to free results that don't exist.
Right, I realized that a few minutes ago lol.


Re: SQLite - Smokinn - 02.03.2017

Hello everyone. I have a problem.. Idk how to make a new post ) only reply, so:

Error: warning 213: tag mismatch

Source: format(querySting, sizeof(querySting), "INSERT INTO `houses` (`HouseID`, `HousePrice`, `HouseInterior`, `HouseLocked`, `HouseOwned`, `HouseOwner`, `HouseLabel`, `HousePickup`, `HouseVW`, `HousePosX`, `HousePosY`, `HousePosZ`) VALUES \
('0', '%d', '%d', '%d', '%d', '%s', '%s', '%d', '%d', '%f', '%f', '%f')",
HouseInfo[i][HousePrice], HouseInfo[i][HouseInterior], HouseInfo[i][HouseLocked], HouseInfo[i][HouseOwned], HouseInfo[i][HouseOwner], HouseInfo[i][HouseLabel], HouseInfo[i][HousePickup], HouseInfo[i][HouseVW], HouseInfo[i][HousePos][0], HouseInfo[i][HousePos][1], HouseInfo[i][HousePos][2]);


Re: SQLite - YouHack - 02.03.2017

Here's where to make a new thread, it's better to remove your comment.
http://forum.sa-mp.com/newthread.php?do=newthread&f=12