Raised This Month: $40 Target: $400

SQLite set multiple values

Post New Thread Reply   
Thread Tools Display Modes
AlliedModders Donor
Join Date: Jun 2018
Location: Not your business.
Old 08-09-2018 , 20:26   Re: SQLite set multiple values
Reply With Quote #11

Thank you for mentioning me Crasher

I agree with you aswell, would be more convenient.
Taking requests, add me on Steam.

People make themselves understood in a way, others understand in another.
mug1wara is offline
Neuro Toxin
Veteran Member
Join Date: Oct 2013
Location: { closing the void; }
Old 08-09-2018 , 22:40   Re: SQLite set multiple values
Reply With Quote #12

Or potentially add a subforum for MySQL and SQL
Neuro Toxin is offline
Junior Member
Join Date: May 2014
Location: Valhalla
Old 08-13-2018 , 01:52   Re: SQLite set multiple values
Reply With Quote #13

You have an error into your query you need to set the value into quotes, like this:

Format(sQuery, sizeof(sQuery), "UPDATE %s SET value = \"%s\", timestamp = %i WHERE AuthId = \"%s\"", Name, Value, timestamp, AuthId);
Also if you want to use the time for update in sqlite use GetTime();
aleeexxx is offline
Send a message via MSN to aleeexxx

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

All times are GMT -4. The time now is 12:16.

Powered by vBulletin®
Copyright ©2000 - 2018, vBulletin Solutions, Inc.
Theme made by Freecode