Please help - this is really weird!Yesterday I developed a form with some computed text that retrieved data from our corporate SQL 2000 database using @dbcommand with ODBC.
These all worked ok when I refreshed the form.
This morning, nothing - they not only don’t retrieve the data, they don’t seem to be doing anything at all (i.e. not even failing, just not activating).
Nothing has changed - no upgrades to client or server, or the odbc dsn, or SQL server.
They had the form
@Dbcommand(“ODBC”:“NoCache”;“odbc_dsn_name”;“login”;“password”;“select surname from people where customer_reference = 123456”:“fail”)
Things I have tried :
-
doing the same in another database in case it is a database setting. Same result (or lack of) in other database
-
Restarting Domino (even though the form is on the client and this shouldn’t matter)
-
Changing the sql statement to be invalid (adding random characters) - this should force an error, but still saw nothing, which suggests the @dbcommand isn’t firing at all
-
Trying it on another workstation in case it is a setting - still no luck
-
Checked the ODBC is still a valid dsn by successfully executing the same sql as a data retrieval in Excel.
-
tried @dbcolumn instead of @dbcommand - still no output
Update
I have just tried with a ‘computed for display’ field instead of computed text, and it works! However, I am worried this will also stop working - or is there some essential reason why it is unreliable on a computed text item?
Any help / explanations welcome!