Raised This Month: $40 Target: $400
 10% 

SQLite set multiple values


Post New Thread Reply   
 
Thread Tools Display Modes
mug1wara
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
aleeexxx
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:

Code:
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
Reply


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