SQLite

[fowlplay4]

I was mainly referring to using format instead of an array and format2

Think your player account example but with 19 parameters, 18 of which were variables with .escape() on the end.

[xXziroXx]

Originally Posted by Stefan

Update: fixed it, will work fine with the next npcserver update.

Have that update been yet? If not, could you please update Maloria's NPC server with it?

[Admins]

Originally Posted by fowlplay4

I was mainly referring to using format instead of an array and format2

Think your player account example but with 19 parameters, 18 of which were variables with .escape() on the end.

Well what is the problem then to just loop through the array and call escape() on them?

[fowlplay4]

Yeah that's what I'm doing now.

[Admins]

The npcserver has been uploaded to all machines, restart it manually to get the new escape() command.

[xXziroXx]

Originally Posted by Stefan

The npcserver has been uploaded to all machines, restart it manually to get the new escape() command.

Cheers.

[devilsknite1]

Originally Posted by Inverness

You restarted the NPC-Server already to enable the SQL right?

Yes, I've done this. Multiple times...

[Inverness]

Currently NULL in SQL is represented as "" in Graal, this is a problem and there needs to be a way to differentiate between zero, an empty string, and NULL.

I was thinking perhaps a literal like "\\NULL\\" or "\\0" in GScript. c = '\0' just causes a compiler error.

[Inverness]

TSQLRequest.affectedrows doesn't appear to be working with my update statement even though I can see the change in a later query.

[Admins]

affectedrows is currently only used for mysql, is not touched by the sqlite database.

[[email protected]]

Any idea how to use the auto increment option as a primary key? I can't figure it out- thanks

[Skyld]

Originally Posted by [email protected]

Any idea how to use the auto increment option as a primary key? I can't figure it out- thanks

http://www.sqlite.org/faq.html#q1

Google will serve you well.

[[email protected]]

Originally Posted by Skyld

http://www.sqlite.org/faq.html#q1

Google will serve you well.

Thanks beautiful :}

[TESTRETIS]

Sorry for the bump, but is it possible in a future RC Update to have a console specifically for SQL Management, and to place and receive queries, with the ability to view a table, without relying on an Echo to RC, to do possible click sorting, displaying and indicating primary keys, composite keys, surrogate, etc.

[cbk1994]

Originally Posted by TESTRETIS

Sorry for the bump, but is it possible in a future RC Update to have a console specifically for SQL Management, and to place and receive queries, with the ability to view a table, without relying on an Echo to RC, to do possible click sorting, displaying and indicating primary keys, composite keys, surrogate, etc.

Would be useful. I just downloaded a lightweight SQLite database manager, and set it as the default application for 'db' files, so when I double click it in file browser, it opens up.

I also built a basic in-game "SQL Explorer". If it was finished, it could eventually be added to client-RC (would actually be quite a nifty feature).