SQLQuery in a SQL Query while loop

[hacknisty]

Hi all,

First of all, let me thank you for your work.

I'm fairly new to nwnx and i want to execute something like this :

[odenien]

Probably the simplest thing to do is a compound query like

"INSERT INTO test (player) SELECT player FROM pwdata"

but the data does not ever make it to the mod. I think one problem with this system is there is assumed one and only one statement active at a time, therefore you can not do what you are trying without saving the entire resultset first.

[Kosmous]

SQLExecDirect("SELECT player FROM pwdata");
while ( SQLFetch() == SQL_SUCCESS)
{
sPlayer = SQLGetData(1);
DelayCommand(1.0, SQLExecDirect("INSERT INTO `test` ( `player` ) VALUES ( '"+sPlayer+"' ));
}

simplest way to deal with this minor problem

[hacknisty]

Many Thx KosMous !!! ) I would have never think it was so simple to workaround this little problem.

But i've got one more question :

Which minima is required for this type of query to work ?
It works fine with 1s but if I have 20 elements it would take 20 seconds to run ?

Is 0.2s delay work ?

[Acrodania]

Any "delay"shifts it out of the run and into the que, so yes, 0.2 seconds will work.

A minor warning: Beware stacking too many of these. At some point the DelayCommand que can no longer handle any more entries and will not store them. In my test module this happens at around 90 commands..... Note that this is 90 DelayCommands in the ENTIRE MODULE, not just the one script

[Papillon]

Among other reasons, this one made me create the hashset plugin. You can store resultsets quite efficiently there and then loop through it afterwards.
_________________
Papillon