>when i do that (sql server 2005 express)
>
>SQLCOMMAND = "SELECT IDENT,HSCODE,DESC1,DESC2 FROM TB_HS_MESS WHERE IDCLIENT = " + ALLTRIM(STR(l_Custno)) + " ORDER BY hscode"
>
>
>
>STORE sqlexec(hConn ,SQLCOMMAND,'CUR_HSCODE') TO L_N
>
>
>the value of l_n is always 1
>
>
>
>
>how can i know the real number of records ?????
>thanks
You are happy that you always get 1 as a result. 1 means that everything is OK. Number of records you can get from:
STORE sqlexec(hConn ,SQLCOMMAND,'CUR_HSCODE') TO L_N
IF l_n > 0
? RecCount([CUR_HSCODE])
ENDIF
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.