logo logo

 Back to main page

The NWNX Community Forum

 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 
 
TIMESTAMP Help

 
Post new topic   Reply to topic    nwnx.org Forum Index -> Scripts and Modules
View previous topic :: View next topic  
Author Message
CelticLord



Joined: 10 Nov 2012
Posts: 3

PostPosted: Sun Nov 11, 2012 2:32    Post subject: TIMESTAMP Help Reply with quote

I cannot get the Timestamp to work in SQLite using NWN2 for NWN, and i have looked and tried almost everything.
I get the default CURRENT_TIMESTAMP in the Create statment.......
Code:

SQLExecDirect("CREATE TABLE " + sTable + " (" +
        "player varchar(64) NOT NULL default '~'," +
        "tag varchar(64) NOT NULL default '~'," +
        "name varchar(64) NOT NULL default '~'," +
        "val blob," +
        "expire int(11) NOT NULL default '0'," +
        "last timestamp NOT NULL default CURRENT_TIMESTAMP," +
        "PRIMARY KEY (player,tag,name)" +
        ")");

Can someone help please.
Back to top
View user's profile Send private message
Squatting Monk



Joined: 28 Jun 2007
Posts: 76

PostPosted: Sun Nov 25, 2012 0:07    Post subject: Reply with quote

This works just fine for me in MySQL. What do your logs say when this statement fails?
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    nwnx.org Forum Index -> Scripts and Modules All times are GMT + 2 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group