Marcia:
Some progress, I got it to work if the result has more than one row, but if only one row returns from the sql, when I use the ains command to add a row it will replace all the values to .f.. What do I have to do to insert a row for the one demension array?? thanks
sherry