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.

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

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

Yeah that's what I'm doing now.

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

Cheers. :D

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

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.

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

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

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. :)

Thanks beautiful :}

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).

http://img11.imageshack.us/img11/928...1248746452.png