Select Count and Unique Array Name VFP 9


I am trying to assign a count into a temporary array. I want a unique
name because the function is actually a VFP9 DBC stored procedure, and
I want to be sure that the return value is unique to a given caller
(this is a heavy multiuser web app doing read-only against the DBC). I
am having a problem with the SQL-SELECT statement, can anyone help?




Function TestThis
LPARAMETERS param , paramparam

LOCAL count as Integer
LOCAL tmpStore as String

tmpStore = SYS(2015)

SELECT COUNT(ColumnA) as uCount FROM TestTable ;
INTO ARRAY &tmpStore

count = &tmpStore(0)


RETURN count

ENDFUNC

.

Loading