General information
Category:
Coding, syntax & commands
It must be a bug. One comment on your replacement of Sql_3. Inside the parentheses you should use WHERE rather than HAVING. HAVING is a qualifier for GROUP BY.
>Thanks Tom.
>
>The folowing SQL replaces Sql_3
>SELECT fld_a + fld_b FROM tbl_1 WHERE fld_a + fld_b IN (SELECT fld_a + fld_b FROM tbl_2 HAVING DELETED()) UNION SELECT fld_a + fld_b FROM tbl_1 WHERE DELETED().
>
>BTW - BUG WARNING
>We found that Sql_3 worked in VFP 6 as written the first time, so we are assuming that VFP 3 has a bug.
>
>Thanks to all who chipped in.
>
>Todd Cottengim
>Alpine Land Information Services
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only