Howard
This is a parameter view, judging by the ?lnPBRMainFK, but why the parenth. around it, why not just:
WHERE Pbrwork.pbrmainfk = ?lnPBRMainFK ;
>I'm trying to upgrade my app to VFP9 from VFP8. It's giving me the "SQL expression is too complex" on this view:
>
>SELECT *;
> FROM ;
> mc!pbrwork ;
> INNER JOIN mc!pbrmain ;
> ON Pbrwork.pbrmainfk = Pbrmain.primarykey;
> WHERE Pbrwork.pbrmainfk = ( ?lnPBRMainFK );
> ORDER BY Pbrwork.pbrmainfk, Pbrwork.linenumber
>
>Any ideas?
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.