Hi there
I’m attempting to open a database view with columns from an external source using ODBC. I’ve used LotusScript in the Form and that works fine - but I’m trying to use @DbColumn for the Column Values in the view…
I’ve set this at
@DbColumn(“ODBC”;“Interclaims”;“”;“”;“Customers”;“Cust_No”;“”:“Ascending”)
But nothing happens when the database is opened… Am I missing something?
Thanks
Subject: RE: Using ODBC for View Column values
It’s not clear to me exactly where you’re trying to use this formula, but @DbFunctions can’t be used in view selection or column formulas, as is documented in the help.A view column formula doesn’t calculate the entire column in one go. It is evaluated for each NOTES DOCUMENT in the view and calculates the value for THAT DOCUMENT’S ROW ONLY.
A regular Notes view can only show Notes documents. To see information from other sources in the view, you would need something that makes the data in the other data source look like Notes documents. For instance, an LEI “virtual documents” activity. Or, if you have Notes documents and you just want to display some data based on a key lookup from data in the Notes document, you could use DECS “virtual fields.”
The LEI Redbook discusses your LEI and DECS integration options.
In version 8.0 (and in version 7, but not completely supported) you can also use NSFDB2 to store your NSF in a DB2 database. This lets you create “query views” that show information from the DB2 database – whatever you can retrieve with a query.
Subject: RE: Using ODBC for View Column values
“It’s not clear to me exactly where you’re trying to use this formula, but @DbFunctions can’t be used in view selection or column formulas, as is documented in the help.”
I think that was a brain fart! The methodology was based around an asp.NET Gridview - It’s been some years since I messed with ODBC and Notes - version 4.5 in fact -
“A view column formula doesn’t calculate the entire column in one go. It is evaluated for each NOTES DOCUMENT in the view and calculates the value for THAT DOCUMENT’S ROW ONLY.”
I kind of figured that after a few sharp whacks to the head!
"A regular Notes view can only show Notes documents. To see information from other sources in the view, you would need something that makes the data in the other data source look like Notes documents. For instance, an LEI “virtual documents” activity. Or, if you have Notes documents and you just want to display some data based on a key lookup from data in the Notes document, you could use DECS “virtual fields.”
The LEI Redbook discusses your LEI and DECS integration options"
We do actually have LEI running (which is why I’ve been very lazy about writing LotusScript for ODBC) - but it does carry a heavy overhead at the DB back-end with the EINOTEPROPS column. As for DECS we don’t seem to be able to make a connection - I suspect because our Sybase back-end is running under SPX! LEI doesn’t have that problem because it can use ODBC.
Thanks for your input - it is appreciated…