Hi Dan, I think it is the handling of the query in ODBC. Normaly all that DECLARE xx CURSOR FOR is done behind the scenes (if at all) and so the "raw" query should be able to do without (ODBC should handle the declaration etc. of cursor itself e.g. when preparing, so using the declare cursor this way is in a way not backed by specification). The clients differ in when to expect and collect a result, I think that SQL Studio takes the "oops we have a result so just display it" approach to it. The appendix for SQL3 of Date the Date/Darwen SQL-Standard Guide shows a "with recursive" query without the declare cursor decorations, I think SAPDB could easily be adjusted to do it and assume that syntax only does not work yet because it is rejected by the client library because it does not really look like the familiar selects the ODBC-Interface usually sees... (this are really only vague utterances...) I also would really like to see a workable solution.
regards Wolf ______________________________________________________________________________ Die Nummer, die man nie vergisst: Ihre pers�nliche Wunschrufnummer von WEB.DE! Jetzt einsteigen http://freemail.web.de/?mc=990002 _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
