SA-MP Forums Archive
How to set a field value null in sqllite? - 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: How to set a field value null in sqllite? (/showthread.php?tid=605772)


How to set a field value null in sqllite? - GhostHacker - 24.04.2016

Hello Fellas how can i do that ^^ hmm take an example if a vip player can have alterate name so the db field is null in default but when the player uses a function in the gm it(alt name) will get in that field and now (this is prob) i guess i made a function to remove this altname and player used and i wanted the field to be back to null how can i do that what value should i add in
PHP код:
format(query,sizeof(query),"UPDATE data SET AltName = "here what value should i add to make it null" WHERE username = '%s'",DB_Escape(name)); 


Re: How to set a field value null in sqllite? - GhostHacker - 24.04.2016

sorry for bump i need it quicker

Re: How to set a field value null in sqllite? - GhostHacker - 24.04.2016

No one knows?

Re: How to set a field value null in sqllite? - Lordzy - 24.04.2016

Just set it to NULL and that's all you need.

SET `column`=NULL (without quotes)

Re: How to set a field value null in sqllite? - GhostHacker - 24.04.2016

Thank very much +rep