| David Fishburn 2005-05-10, 11:23 am |
| Paulo Raffaelli < paulo_raffaelli@yaho
o.com> wrote in
news:426ea8e6$1@foru
ms-1-dub of sybase.public.sqlanywhere.ultralite:
PR> I found out what was causing the problem.
PR>
PR> Apparently, the first subquery returning the same parameter twice was
PR> it. Modifying both subqueries so that a parameter does not get
PR> returned in the results fixed it. Strange! I posted it here in case
PR> someone else is struggling with this issue.
Can you show us the final SQL statement that works.
--
David Fishburn
Certified ASA Developer Version 8
iAnywhere Solutions - Sybase
Professional Services
Please only post to the newsgroup
Please ALWAYS include version and MORE importantly BUILD number with
EACH post (dbeng9 -v).
EBFs and Maintenance Releases
http://downloads.sybase.com/swx/sdmain.stm
Developer Community / Whitepapers
http://www.ianywhere.com/developer
CaseXpress - to report bugs
http://casexpress.sybase.com
CodeXchange - Free samples
[url]http://ianywhere.codexchange.sybase.com/servlets/ ProjectDocumentList[
/url]
|