Using tables other than "pwdata"

[cma_dev]

From the error logs that I have been getting from ODBC, it seems that I cannot use any other table than "pwdata".

This poses a problem for me. I really would like to stick to database/SQL best practices and not have everything crammed into one single table called "pwdata".

I wanted to have separate tables using primary and foreign keys and then use SQLExecDirect() to link them to retrieve the needed value.

How do I allow for tables other than "pwdata"? It would just drive me nuts to be limited to only one table.

I'm using MS SQL Server and may even use Oracle.

Thanks for any help.

PS - which is better for storing and retrieving data, SQLExecDirect() or the SET and GET persistent functions? Thanks!

[JeroenB]

It depends on how much data you are retreiving. If you only need one function, you could easily call the Get and Set functions. In the otherhand, if you need multiple data from a table then its best to you create an SQL statement yourself to retreive it.

I would also recommend using MySQL as that one is directly supported by the plugin, plus it is free to download and fast enough for NWN. You can ofcourse use other tables. You only have to design and create them yourself with either a tool or an SQL statement(s). Then you can easily add , modify etc data in that table.