Multiple recordsets

[Timendainum]

I've been an avid user of NWNX2 since release. Also, my roots are in programming database interfaces, and database design. I've taking all of my experience into play, and have been working on v2 of my world.

One of the limitations of NWNX2 has always been that you can only work with one recordset at a time. No nesting recordset outputs.

While you can usually eliminate the need to do nested outputs of recordsets, there is always the time when you can't.

The solution I've come up with is to output the root recordset into an array (using one of the array packages available on the vault), and then nest the array output into another recordset output.

But, this brings me to my question. Shouldn't there be an easier way to handle this?

Would it be possible to create a recordset datatype, much like the hashset that is available? And then return queries into these structures, rather than the delimited string that they come back in now.

Another problem is outputing large recordsets, with lots of fields is also prone to causing TMIs.

Imagine something like this:

recorset rsTheRecordSet = SQLExecDirect("SELECT * from table");

Then things like:
rsTheRecordSet.field1[row]
rsTheRecordSet.someFieldName[row]

Or

rsTheRecordSet.RecordCount
rsTheRecordSet.CurrentRow

Is anything like this possible, or am I just dreaming?
_________________
"Good, bad... I'm the guy with the gun."
TKW

[JeroenB]

Yes, we have been busy with this, and I currently have a demo version running locally. In the future we will expand the NWNX ODBC plugin with this new functionality that will enable the coders to use multiple recordsets.

[Timendainum]

I'd be happy to do some beta testing on my end. As I would make heavy usage of features like this.

Although the testing would only entail my devenopment environment. We are keeping the old mod in production until we are ready for beta of this module.

I'd love to learn more about writing DLLs for NWNX2 but have little clue on how to even get started.
_________________
"Good, bad... I'm the guy with the gun."
TKW

[JeroenB]

I have planned to write a tutorial about developing your own nwnx plugin. So, hopefully that will meet your needs

[Timendainum]

You haven't been psychically invading my personal thoughts have you?


_________________
"Good, bad... I'm the guy with the gun."
TKW

[JeroenB]

I hope not.. that might be too scary