The CASE function has specific syntax you've to follow.
cast( Original_ap_invoices.VENDOR_NUMBER as int)
is correct one. It doesn't look like VFP8 View Designer can handle it, though. It seems to work fine in VFP9 View Designer. You can either:
- Create view in code (w/o View Designer)
- Use third party replacements for VFP View Designer
- Upgrade to VFP9
>I am using the modify data command of the DBC and then select add remote view.
>
>Where do I put the CAST(TableA.Vendor_number) as int
>
>I thought I would try to change it in the JOIN tab by going to the bottom of the fields and building an expression.
>
>I use cast( Original_ap_invoices.VENDOR_NUMBER) as int
>and then hit verify and it says expression OK.
>
>When I try to save the view it says incorrect syntax near expression ‘CAST’, expected ‘AS’
>
>If I use cast( Original_ap_invoices.VENDOR_NUMBER as int)
>then it tells me missing )
>
>
>I am getting CLOSE, but close only counts in horse shoes, hand grenades and atomic bombs. With the SQL syntax it is 100% or ZERO.
--sb--