[suggestion] SQLExectDirectAndSingleFetch

[caloup]

Hi, the purpose of this post is to suggest a new function in nwnx_sql :

[kungfoowiz]

Hello, so you only want the first row's column data; or all the rows' column data put into a single string?

---
kung

[caloup]

In fact, perhap's i had misunderstanding the SQLFetch function...

If I want just one data - for example :i want to get a data named "honor" in the honor table witch corresponding to a player name and his Id. There is just one row corresponding to Player name...

I had to make my script like that, no ? :
[quote]

void main()
{

object oPlayer = GetPCSPeaker();
string sName = GetName(oPlayer);
string sReturn;
string sSQL;
sSQL = "SELECT honor FROM honor WHERE Player="+sName;
SQLExectDirect(sSQL)

if (SQLFetch() == SQL_SUCCESS)
{
sReturn=SQLGetData(1);
}

SendMessageToPC(oPlayer, "you have "+sReturn+" point of honor");
}

But if i have the same request for another table and column...I need to rewriter the same type of script...What i suggest is to make a generic script in nwnx_sql with alllow to have just one function to cast...So it can simplify the scripting...

But if it's possible to make on function gneric for more than one row...Why not

Perhaps i said something stupid, i'm not a professional developper !

[Papillon]

So you suggest a nwscript function that does something like this:

1) SQLExecAndFetch("SELECT honor FROM honor WHERE Player='XYZ'");
2) The functions executes the statement, and
3) returns the first column of the first row as a string ?

Is that what you want ?
_________________
Papillon

[Kallistor]

I think what you are asking is for a generic script to access all tables that you create. Currently I have four seperate tables - players, characters, quests and module. I use generic functions SQLSetString, SQLGetString, SQLSetInteger and SQLGetInteger to access all four tables. What I do is in the function call a GetWhereStatement and pass the table to that WhereStatement to generate the WHERE part, same for INSERT also. I do this as all four tables have different keys, and I believe that is what you were eluding too with your second post????? Oh yeah I also use a function to generate the key of the table. Anyway here is my SELECT statement where sKey and sWhere are generated from the above mentioned functions

[caloup]

[Papillon]

The idea isn't stupid at all. In fact, I think this might be a nice little function that should be added to the nwscript include file.
_________________
Papillon

[Urlord]

By default, nCol could equal 1.
_________________
Jim (aka, Urlord)
Visit the Persistent World of Nymri

[caloup]

[Disco]

Well, in the same style...

Is it possible to let INSERT return the ID of the table entry upon SQLExecAndFetch? 0 would still mean a failure, of course. It would make the access of certain records via a variable stored on a PC or item a breeze.