>>As for _TALLY unless it is going into an array we mostly always capture _TALLY whether we use it or not and if going into an array we test the VARTYPE( of that array ) != "X" before continuing.
>
>As I explained elsewhere, the use of _TALLY is a real requirement if doing a SQL-SELECT into an array, because the array will not have been created if no records could be selected. The use of _TALLY should prevent that the array is actually peeked in. Like in:
Depending on it's usage, I've dealt with this in this manner.
DIMENSION laResult[1]
laResult = "None"
select somefield1 from table1 into array laResult
Now the array will have at least a valid entry in it even if there are no records returned by the SELECT. Comes in handy for ComboBoxes, etc.