This worked in IB 6. What should I cast it to?

Helen Borrie wrote:

>At 04:17 PM 26-09-02 -0400, you wrote:
>
>
>>We use literals in views all the time and have to cast them to the
>>appropriate type.
>>
>>For some reason this doesn't work with this view.
>>
>>I get this error:
>>"SQL Runner Error
>> ISC ERROR CODE:335544569
>>
>> ISC ERROR MESSAGE:
>> Dynamic SQL Error
>> SQL error code=-104
>> Invalid command
>> Data type unknown"
>>
>>
>
>[snip]
>
>You need to make sure that all corresponding columns in union views match
>exactly by data type and size. Your first subset casts a literal as
>CHAR(40) whilst the corresponding column in the other subset,
>BSS_USER_CONTROL.USER_ID, is VARCHAR(40).
>
>heLen
>
>
>
>To unsubscribe from this group, send an email to:
>ib-support-unsubscribe@egroups.com
>
>
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>
>
>

--
Thomas Miller
Delphi Client/Server Certified Developer
BSS Accounting & Distribution Software
BSS Enterprise Accounting FrameWork

http://www.bss-software.com



[Non-text portions of this message have been removed]