>>>>Naomi's on the right track: that field will be set as either 7 chars or 8 chars depending on which option appears in the first row of the current query; but the DBC says it is -- well, whatever showed up when it tried to run it when making the DBC entry (it actually opens the view when doing this). Using CAST() will make it a definite length.
>>>
>>>Hi thanks
>>>the code worked but when my view is run(the original code) if says IIF the status =1 do X as applstatus so yes the length will vary but im not too sure why that would be an error
>>>
>>You get the error you had when the length of any of the columns is non-deterministic (as in your case)
>
>i have a lot of IIF views in the program i should go do them over thanks
If the result of IIF non deterministic - go ahead and fix every case.
If it's not broken, fix it until it is.
My Blog