At 10:25 PM 26-09-02 -0400, you wrote:

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

You shouldn't have to cast it at all; but if you do, you should match the
data type of the corresponding row from the other subset, i.e. VARCHAR(40).

heLen

>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]
>
>
>
>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/