question of a newbbie

[nevarim]

hi guys

i'm using you tool, but i can't open the start module, when i try to do this toolset goes in crash,.

but this is not important

the question is how can i use the function for get a row from a query?

for example i want to transfer on a variable the result of query:

select id from table_name where table.id=2

and i want to transfer in the script on variable PGID the result (2)

for now i use for to do insert and update the SQLExec("query")

thanks for the help

Mauro

[Saulus]

Well lets say you had

int nPCvar = GetLocalInt(oPC, "SOME_VALUE");
string sPCvar = IntToString(nPCvar);

sSQL = "select id from table_name where table.id="+sPCvar;

SQLExecDirect(sSQL);

Is that what you were asking?

[Asparius]

Ok. First - getting a row from the query:

[Gryphyn]

and make sure you SQL syntax is correct
select id from table where table.id=2 or
select id from table_name where table_name.id=2 or
select id from table_name t where t.id=2