I have an application, written in Domino 5 that I am checking through before upgrading for a customer. I have tested this functionality on 6.5.4, 8.0.1 and 8.5.1. Below is the formula:
SQLstatement := “exec dbo.sp_myproc '” + LoggedInUserID + “'”;
x := @DbCommand( “ODBC” : “NoCache” ; “DS” ; “User1” ; “Pwd” ; SQLstatement);
@If(@IsError(x); “Error During Lookup”; x=“”; “1”; x);
This works on both 6.5.4 and 8.0.1 on the web without any problems. However on 8.5.1 it always returns an error.
Looking through the documentation it seems as though this should never have been supported or worked (even since release 5):
"For Web applications, you can use this function only with the syntax:
@DbCommand(“Domino”;“ViewNextPage”)
or
@DbCommand(“Domino”;“ViewPreviousPage”)
to create a link to the next or previous page in a view. You cannot use @DbCommand in any other context with Web applications."
The above text wasn’t in the 6.5.4 help, but is in the 8.0 help (and 8.5.1).
Has this functionality been completely disabled as of 8.5? It would be nice to have an official response to this to add to my report for the customer.
Thanks,
Ben