MySQL Better Support?

[GodBeastX]

I'm sure someone made a change for this scenario, but I'm basically using NWNX2 out of the box. In the MySQL world you get a result handle as a return from a SELECT operation and all your fetches you pass in the handle. In NWNX2 you call the ODBC plugin which basically seems to use the last result of a query for the fetches.

Basically nested queries jack up cuz of the above. Has anyone made any ODBC changes to allow nested queries? Or should I Start making my own MySQL plugin?

[Papillon]

I am not aware of a modification like this in NWNX2.

In NWNX4, it is possible to call statements like INSERT or UPDATE without overwriting the old result set, among other changes that improve performance. Maybe someone could make a backport from the current NWNX4 SQL plugins to the NWNX2 odbc plugins for Linux and Windows ?

Unfortunately, I do not have enough resources to do this on my own.
_________________
Papillon

[virusman]

I could.

[Papillon]

You might want to get acquainted with the current NWNX4 sources first, which are still under heavy modification. If they get more stable, a backport to NWN1 would be really nice !
_________________
Papillon

[FunkySwerve]

This would be VERY nice. For my player market, I had to write SELECT returns as local psuedoarrays so that I could make other calls using the SELECT data.
Funky

[virusman]

[FunkySwerve]