Search found 9 matches

I am trying to save objects to the database for the first time, and trying to use the Set/GetPersistentObject functions to do that.

The trouble is that there isn't any proper documentation for tho ...

Yeppers... I wasn't too concerned about the performance at this point, the most important thing was to get the whole thing working in the first place.

I'll add the unique key. Not that it's gonna m ...

*Pyridon pops a bottle of Champagne

It finally works ! Both select and insert work okay, AT LAST.

Now that the ice is broken, it's just work, work work... Smile

Once again thanks for you all wh ...

EDIT: success at last ! I created the table without explicit autoincrement but with 3.2.7 client. The implicit autoincrement still works in 3.2.7, and FINALLY my module performed the select phrase cor ...

NWNX ODBC2 does nothing special to the SQL string. If it works in whatever program you use but not in NWN, there might be a version mismatch.
This isn't about the SQL string. It does not matter. What ...

It is a valid statement, but NOT for the table you listed!!!!

First, I don't understand why you speak of MySQL, as I stated I am using SQLite, not MySQL.

Second, I'm sorry, but it is a valid SQ ...

You have 6 columns in your database, your SQL statement only has 4 of them.....

With your INSERT statement you must account for all columns.

Do you mean NWNX does not support the fields listin ...

Gee, I found nwnx logfile. It states this:

o Got request: SELECT pcid FROM pcdata WHERE pubcdkey='XXXXXXXX' AND pcname='Fallon Woods';
! SQL Error: malformed database schema - near "AUTOINCREMENT" ...

Okay, I am an NWNX noob, not so noob what comes to NWN scripting and databases. I am using SQLite and I made my own player data table and tried to insert into it, but that didn't succeed, and I don't ...

The NWNX Community Forum