General information
Category:
Coding, syntax & commands
Title:
Invalid subscript error
Hello:
I'm trying to load an array into my grid and am getting invalid subsript.
I add a record, save and then do this statmenet to load into my grid.
My select statement is :
select gidetail.sin, client.surname,client.firstname, client.phone1;
from gidetail, client;
where gidetail.sin = client.sin;
and gisum.sessionkey = gidetail.sessionkey;
into array aclient
in the control source of my grid for column2 of the grid(surname) I have :
iif(empty(gidetail.sin), "",surdesc("Aclient", gidetail.sin))
my function surdesc is as follows:
Function surdesc
Parameters arrname, cd
tmpnum = Ascan((arrname), cd)
if empty(tmpnum)
return " "
else
return &arrname(round(tmp/4,0),2)
endif
I've set up my arrays as : public array aclient(1,4)
Shouldn't this just redimension itself when it loads from the
select statement. I can't understand why I'm getting this error.
Any input would be appreciated.
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only