General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>>>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
Previous
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