Hi Svein

At 08:22 pm 12/01/2004, you wrote:

> > FROM MSALESREPS MSALESREPS
>
>Ouch Bhavbhuti,
>I guess Firebird is confused by you aliasing one of the tables to the
>actual name of the table. Try a different name and change your query
>to something like:
>
>SELECT MSALESREPS_B.*,
>MSALESREPS_A.CNAME AS CSPONNAME,
>MSALESREPS_A.CCITY AS CSPONCITY,
>MSALESREPS_A.CCODE AS CSPONCODE
>FROM MSALESREPS MSALESREPS_B
>RIGHT OUTER JOIN MSALESREPS MSALESREPS_A
>ON MSALESREPS_B.IPID = MSALESREPS_A.IID
>ORDER BY MSALESREPS_B.CNAME, MSALESREPS_B.CCITY

Bingo, that did it thanks a lot. I am a starter with FB and have tried
the first VFP form as a remote view data. I was getting pretty
disheartened when the original VFP SQL did not work for me. Now I am able
to add, edit and delete records, thanks to you.



Regards

Bhavbhuti


----------


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.561 / Virus Database: 353 - Release Date: 13/01/2004


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