>I think it's a bug. The DELETE command should delete the same records that returned by query. BTW, UPDATE command works correctly
>
>CREATE CURSOR crsTest (cCode char(4), cText C(20))
>
>INSERT INTO crsTest VALUES('0001', "L 1")
>INSERT INTO crsTest VALUES('0001', "L 1")
>INSERT INTO crsTest VALUES('0001', "L 1")
>INSERT INTO crsTest VALUES('0001', "L 1")
>INSERT INTO crsTest VALUES('0002', "L 2")
>INSERT INTO crsTest VALUES('0002', "L 2")
>INSERT INTO crsTest VALUES('0002', "L 2")
>INSERT INTO crsTest VALUES('0002', "L 2")
>
>CREATE CURSOR crsTest1 (cCode char(4))
>INSERT INTO crsTest1 VALUES('0001')
>
>UPDATE crsTest ;
> SET cText = TRIM(cText) + " Updated" ;
> FROM crsTest ;
> LEFT JOIN crsTest1 ;
> ON crsTest.cCode = crsTest1.cCode ;
> WHERE crsTest1.cCode IS NULL
>Thank you.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
