New symptom!

the SQL alias' the table

Select datefield from sometable a where a.idfield = variable and a.trantype = variable into array xxx


Now getting variable 'trantype' is not found

What the heck is going on here guys? Especially considering it's gone through 3 other SQL into the same table with almost the same where conditions (the trantype variable differs) with no problems.




>>Has anyone seen the following?
>>
>>Both test and production servers are running VFP9 sp1
>>
>>
>>On Test Server:
>>
>>dime xxx[1]
>>xxx[1] = {}
>>Select somedate from somefile where someconditions into array xxx
>>
>>?xxx[1] - returns Subscript is out of range error
>>?alen(xxx) returns 0
>>
>>However, on the Production Server we get
>>
>>?xxx[1] = / /
>>?alen(xxx) returns 1
>>
>>What might be causing this?
>
>Might there be a different strictdate setting?

Both servers have StrictDate = 1