>I found the part the causes problem: if I use a variable instead of a value in the where cause it won't work. For example:
>
>CLIENT = 'test'
>TEMP = "Select clClientID from CLIENTTYPE where clClientID = CLIENT"
>?SQLEXEC(gnquoteConn,TEMP,"Qt_num")
>It will return -1.
do this instead:
>CLIENT = 'test'
>TEMP = "Select clClientID from CLIENTTYPE where clClientID
?= CLIENT"
>?SQLEXEC(gnquoteConn,TEMP,"Qt_num")
ramil
~~ learning to stand still