SQLExecDirect("SELECT * FROM ....

[morikahn]

Alright, I should have realized this early on.. but its only hit me now.

There is a limit to have many rows you can retrieve at once from a table.

I'm pretty sure I can work around this, but I'm curious how this limitations is set, and can it be modified.

[Grumalg]

As far as the database engine is concerned, you can get far more records returned than you'll ever need in NWN. The limit you'll hit first is TMI errors from the game engine if you try to loop processing too many records. It is possible to split up the processing if you need to deal with too many records by useing a LIMIT clause in the SQL to set a max number of records you deal with in a chunk.

--- Grumalg ---

[morikahn]

Thanks. I was a TMI.

Now to figure out a way to prevent that .